Thursday, September 1, 2011

Oracle Database Structure

Oracle database physical structure consist of-

1.Control files,
2.Data files,
3.Redo log files.


Additional files are- Parameter file, Password file, Archive log files.

The logical structure consist of-
1.Tablespaces,
2.Segments,
3.Extents,
4.Data blocks,
5.Operating system blocks