Oracle 11g Architecture
What is an Oracle Database? A database is a collection of data. An Oracle database holds its data in a coordinated set of files stored on disk, including following types: Parameter Files - The Oracle Parameter File (PFILE or SPFILE) holds initialization parameters which indicate where the control files are, how memory is allocated, how logging is performed, and other characteristics of the Oracle instance. Control Files - The Control File stores information needed to verify that the database is consistent, including a list of all database files making up the instance and other important data. Redo Log Files - The Redo Log files store a sequence of entries describing all actions taken against the database. This data is used to recover a database in the event of instance failure. Data Files - The Data Files contain blocks of data which store database objects (e.g., tables, indexes, materialized views, etc.) in the database. Temp Files - The Temp files contain