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

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