Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

What are the components of logical database structure of Oracle database?
The Logical Database Structure of an Oracle include : 
> The schema objects, 
> Data blocks, 
> Extents, 
> Segments and 
> Tablespaces.

> schema objects : means table, index, synonyms, sequences etc.

> Data blocks : are the smallest part of the oracle database defined by DB_BLOCK_SIZE parameter.

> Extent : A group of data blocks forms an extent.

> Segments : An extents groups tends to segments, 

> Table space : lastly a group of segment forms a tablespace.