Skip to end of metadata
Go to start of metadata

-          Oracle data is stored in terms of data blocks

-          Data blocks are defined by the parameter db_block_size

-          By default it is 8 kb

-          Oracle data is stored physically on the file structure using data file with extension .dbf, but they will address logically for easy maintenance and administration, but the data files with        extension .data.

-          SQL.mdf(main data files)

-          SQL.ldf(log data file)

-          SQL.ndf(next data file)

  • No labels