Durasi : 5 hari

1. Introduction
   Oracle Database Architecture  
   Oracle Memory Structures
   Process Structures  
   Oracle Instance Management  
   Server Process and Database Buffer Cache 
   Physical Database Structure  
   Tablespaces and Data Files  
   SYSTEM and SYSAUX Tablespaces  
   Segments, Extents, and Blocks  
   Logical and Physical Database Structures
2. Installing the Oracle Database Software
   Installation: System Requirements 
   Optimal Flexible Architecture (OFA)
   Setting Environment Variables  
   Installing the Oracle Software
   Database Configuration Options
3. Creating an Oracle Database
   Planning the Database 
   Database Configuration Assistant (DBCA)  
   Using the DBCA to Create a Database  
4. Managing the Oracle Instance
   Starting and Stopping Database Control
   Oracle Enterprise Manager 
   Accessing Oracle Enterprise Manager 
   Using SQL*Plus and iSQL*Plus to Access Your Database
   Initialization Parameter Files 
   Database Startup and Shutdown
   Viewing the Alert Log 
5. Managing Database Storage Structures
   Storage Structures  
   Tablespaces and Data Files 
   What Is Automatic Storage Management?  
   ASM: Key Features and Benefits  
   ASM: Concepts 
6. Administering User Security
   Database User Accounts  
   Predefined Accounts: SYS and SYSTEM  
   Creating a User 
   Authenticating Users 
   System Privileges  
   Object Privileges  
   Benefits of Roles  
   Profiles and Users  
7. Managing Schema Objects
   What Is a Schema? 
   Specifying Data Types in Tables 
   Defining Constraints  
   Dropping a Table  
   Truncating a Table  
   Indexes  
   Sequences 
8. Managing Data and Concurrency
   Manipulating Data Through SQL  
   PL/SQL  
   Triggers  
   Triggering Events  
   Locks  
9. Managing Undo Data
   Undo Data  
   Monitoring Undo  
   Administering Undo 
10. Implementing Oracle Database Security
    Separation of Responsibilities  
    Database Security 
    Standard Database Auditing  
    Configuring the Oracle Network Environment
    Oracle Net Services 
    Tools for Configuring and Managing the Oracle Network
    Adding Listener Addresses
    User Sessions: Dedicated Server
    User Sessions: Shared Servers 
    SGA and PGA
11. Proactive Maintenance
    Proactive Maintenance  
    Introducing Terminology  
    Optimizer Statistics  
    Automatic Workload Repository (AWR)  
    Automatic Database Diagnostic Monitor (ADDM)  
    Advisory Framework
    Server-Generated Alerts
12. Performance Management
    Performance Monitoring
    SQL Tuning Advisor
    Using the SQL Access Advisor
    Managing Memory Components 
    Using the Memory Advisor
    Dynamic Performance Statistics
    Invalid and Unusable Objects 
13. Backup and Recovery Concepts
    Categories of Failures
    Instance Recovery
    Media Failure
    Control Files
    Redo Log Files
    Multiplexing the Redo Log
    Archive Log Files
14. Performing Database Backups
    Backup Solutions: Overview
    Recovery Manager (RMAN)
    Managing Backups
    Flash Recovery Area
15. Performing Database Recovery
    Opening a Database
    Changing Instance Status 
    Keeping a Database Open 
    Loss of a Control File  
    Loss of a Redo Log File
    Loss of a Data File in NOARCHIVELOG Mode
    Loss of a Noncritical Data File in ARCHIVELOG Mode 
    Loss of a System-Critical Data File in ARCHIVELOG Mode  
16. Performing Flashback
    Flashback Technology: Benefits  
    Flashback Database:
    Flashback Table
    Flashback Drop
    Flashback Time Navigation
    Flashback Query
    Flashback Versions Query:
    Flashback Transaction Query
17. Moving Data
    Moving Data: General Architecture  
    Directory Object
    Loading Data with SQL*Loader 
    Data Pump
    External Table Population