Oracle Database Administration/Architecture

This lesson introduces Oracle database architecture.

Objectives and Skills
Objectives and skills for the database architecture portion of Oracle Database Administration I certification include:
 * Exploring the Oracle Database Architecture
 * Explain the Memory Structures
 * Describe the Process Structures
 * Overview of Storage Structures

Readings

 * 1) Oracle: Database 2-Day DBA Managing the Oracle Instance

Multimedia

 * 1) YouTube: General Oracle Architecture
 * 2) YouTube: Processes & Memory
 * 3) YouTube: Datafiles & Tablespaces pt 1

Activities

 * 1) Complete the tutorial Oracle: Managing the Oracle Instance.
 * 2) Identify instance configuration.
 * 3) Review Oracle: Introduction to Oracle Database Architecture.
 * 4) Using either SQL*PLUS or SQL Developer, connect to Oracle Database as either SYSTEM or SYS AS SYSDBA.
 * 5) Use the following query to identify clustered (YES) or stand-alone mode:
 * 6) Use the following query to identify data protection level:
 * 7) Use the following query to identify Streams configuration:
 * 8) Identify memory structures.
 * 9) Review Oracle: Memory Architecture.
 * 10) Use the following query to identify System Global Area (SGA) memory structures and usage:
 * 11) Use the following query to identify Program Global Area (PGA) memory usage:
 * 12) Identify process structures.
 * 13) Review Oracle: Process Architecture.
 * 14) Use the following query to identify current sessions:
 * 15) Use the following query to identify current processes:
 * 16) Identify storage structures.
 * 17) Review Oracle: Tablespaces, Datafiles, and Control Files.
 * 18) Use the following query to identify user extents:
 * 19) Use the following query to identify data files:
 * 20) Use the following query to identify table spaces:
 * 21) Use the following query to identify log files:
 * 22) Use the following query to identify the control file:
 * 23) Use the following query to identify log information: