top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

what is Physical Storage of the Data in Oracle?

+3 votes
254 views
what is Physical Storage of the Data in Oracle?
posted Oct 14, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The finest level of granularity of the database are the data blocks.

 Data Block:  One Data Block correspond to specific number of physical database space
 Extent:  Extent is the number of specific number of contigious data blocks.
 Segments:  Set of Extents allocated for Extents. There are three types of  Segments
                    a) Data Segment:  Non Clustered Table has data segment data of every table is stored in cluster data segment
                    b) Index Segment:  Each Index has index segment that stores data
                    c) Roll Back Segment:  Temporarily store 'undo' information
answer Oct 15, 2014 by Arun Gowda
...