L2_Overview_Of_Physical_Database_Structure.pptVIP

Overview of Physical Database Structures Oracle DBA Class Teacher Burgess Database Concepts pp. 36-37 – Softcopy pages. Pages 1-8, 1-9 Objectives Introduce and discuss the various Oracle Physical Database Structures including the following operating system files: Datafiles – where most of the data is stored. Redo log files – used to record DDL statements. Objectives Control files – tell where all of the files are located – like diary. Backup Files – the backed up data. Alert Files – used for troubleshooting and to alert the DBA of problems. Overview of Physical Database Structures – (Please Draw) Database Files and Instance Overview of Physical Database Structures p. 1-8 The following sections explain the physical database structures of an Oracle database, including datafiles, redo log files, and control files. Every Oracle database has one or more physical datafiles. The datafiles contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the datafiles allocated for a database. EM to look at Physical Structure of Oracle The following screen in EM will let us look at several of the files that make up the Physical Structure of Oracle Try it: EM – Administration - Datafiles EM – Administration - Control files EM – Administration - Redo Log Groups – View Please write these commands in your book! EM - Datafiles EM - Controlfiles EM – Redo Log Groups - View Overview of Physical Database Structures p. 1-8 Data in a datafile is read, as needed, during normal database operation and stored in the memory cache of Oracle. Overview of Physical Database Structures p. 1-8 For example, assume that a user wants to access some data in a table of a database. If the requested information is not already in the memory cache for the database, then it is read from the appropriate datafiles and stored in memory. This creates a hard disk I/O. Oracle looks in memory cache first! Please write it down in your book.