Oracle Architectural Components
- Defining an Oracle Database, the Oracle server, and
the Oracle Instance
- Establishing a connection and creating a session
- Understanding the physical structure
- Understanding the memory structure
- Understanding the process structure
- Understanding the logical structure
- Outlining the stages of an SQL statement
Getting Started with the Oracle Server
- Identifying database administrative tools
Identifying The Features Of The Universal Installer
Defining The Optimal Flexible Architecture
Creating A Database During Installation
Creating A New Database
Identifying Database Administrative Users
- Understanding operating system and password file authentication
SQL*Plus
- Enterprise Manager
Managing An Oracle Instance
- Creating, managing, and using initialization files:
PFILE and SPFILE
- Identifying the various states of starting an instance
Identifying the various options available to shutdown
an instance Monitoring Alert and Trace files
|
Creating a database
- Using the Database Configuration Assistant to create
a database
- Creating a database manually
Using The Data Dictionary
- Identifying the uses and contents of the data dictionary
- Using the data dictionary to retrieve information about
the database
Maintaining The Control File
- Explaining the uses of the control file
- Listing the contents of the control file
- Multiplexing the control file
- Managing control file with Oracle Managed Files (OMF)
- Obtaining control file information
Maintaining Redo Log Files
- Explaining the purpose of and how online redo log files
work
- Control log switches and checkpoint
- Maintaining online redo log files
- Managing online redo log files using OMF
- Multiplexing and maintaining online redo log files
- Archiving online redo log files
- Obtaining online and archived redo log file information
Managing Tablespaces And Datafiles
Describing Storage Hierarchy
|
