In this chapter, we will examine the eight major file types that make up a database and instance. The files associated with an instance are simply
  • Parameter files: These files tell the Oracle instance where to find the control files, and they also specify certain initialization parameters that define how big certain memory structures are, and so on. We will investigate the two options available for storing database parameter files.

  • Trace files: These are diagnostic files created by a server process, generally in response to some exceptional error condition.

  • Alert files: These are similar to trace files, but they contain information about “expected” events, and they also alert the DBA in a single, centralized file of many database events.


File System Trace File Parameter File Temp File Flat File 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Thomas Kyte 2010

Personalised recommendations