Discussion Board

Data block-> Extent-> Segment Oracle allocates logical database space for all data in a database. The units of database space allocation are data blocks, extents, and segments. At the finest level of granularity, Oracle stores data in data blocks (also called logical blocks, Oracle blocks, or pages). One data block corresponds to a specific number of bytes of physical database space on disk. The next level of logical database space is an extent. An extent is a specific number of contiguous data blocks allocated for storing a specific type of information. The level of logical database storage greater than an extent is called a segment. A segment is a set of extents, each of which has been allocated for a specific data structure and all of which are stored in the same tablespace. Prajakta Pandit 02-9-2017 06:00 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*