Data Block is smallest unit of storage in an Oracle database - Oracle Architecture

Q.  Which is the smallest unit of storage in an Oracle database?
- Published on 04 Aug 15

a. Data Block
b. Segment
c. Extent
d. Data file

ANSWER: Data Block
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - At the finest level of granularity, Oracle Database 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

    -Datafiles - They are physical structures that conform to the operating system in which Oracle is running.
    -A database's data is collectively stored in the datafiles that constitute each tablespace of the database.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)