Oracle Internal Arch. ( contd.)
Temporary Segments : contain data in execution of a single SQL statement & then released. This is not same as temporary tables, although they use temporary segments.
Extent : This is a unit of space by which a segment is initially created and later grows as per storage parameters specified in ‘create index’ or ‘create table’. The storage parameters can be initial, next extent size, % increase of subsequent extent, min & max extents, etc.