ENTERPRISE EDITION INSTALLATION

·         IDENTIFY SYSTEM REQUIREMENTS

·         THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)

·         ORACLE_BASE

·         ORACLE_HOME

·         CONFIGURE THE INSTALLATION ENVIRONMENT

·         ENTERPRISE EDITION INSTALLATION

·         DBCA

THE ADMINISTRATOR INTERFACE

·         ENTERPRISE MANAGER TOUR

·         USING EM SQL WORKSHEET

·         DUTIES OF A DATABASE ADMINISTRATOR

·         EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL

THE ORACLE ENTERPRISE ARCHITECTURE

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY

·         WHAT IS AN ORACLE DATABASE INSTANCE?

·         MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)

·         ABOUT THE PGA

·         MANAGING MEMORY

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES

·         INSTANCE BACKGROUND PROCESSES

·         SQL EXECUTION PROCESSES

CREATING AN ORACLE DATABASE

·         CREATE A NEW DATABASE

·         CONFIGURE AN EXISTING DATABASE

·         DROP A DATABASE

·         MANAGE DBCA TEMPLATES

·         MANUALLY CREATE A DATABASE

MANAGING THE DATABASE INSTANCE

·         CONFIGURING A LINUX ENVIRONMENT

·         STARTING & STOPPING DATABASE CONTROL

·         STARTING & STOPPING THE DATABASE LISTENER

·         STARTING & STOPPING THE DATABASE INSTANCE

·         MORE ABOUT THE DATABASE FILES

MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES

·         ABOUT TABLESPACES

·         TABLESPACE MANAGEMENT

·         DROP TABLESPACE

·         ALTER TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES

·         MORE ABOUT TEMPORARY TABLESPACES

·         ABOUT TEMPORARY TABLESPACE GROUPS

·         MORE ABOUT PERMANENT TABLESPACES

·         MORE ABOUT BIGFILE TABLESPACES

·         MORE ABOUT THE SYSAUX TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES

·         DATA FILES & TEMP FILES

·         MANAGING DATA FILES

·         MANAGING TEMP FILES

·         ENABLE ORACLE-MANAGED FILES (OMF)

·         MANAGING UNDO DATA

·         ABOUT UNDO SPACE MANAGEMENT

·         CONFIGURE AUTOMATIC UNDO MANAGEMENT

·         UNDO_MANAGEMENT

·         UNDO_TABLESPACE

·         UNDO_RETENTION

·         GUARANTEE UNDO RETENTION

·         MONITOR UNDO SPACE

·         USE THE UNDO ADVISOR

NETWORK ENVIRONMENT: ORACLE SHARED SERVERS

·         SHARED SERVERS ARCHITECTURE

·         CONFIGURE SHARED SERVERS

·         MONITOR SHARED SERVERS

·         V$SHARED_SERVER

·         V$SHARED_SERVER_MONITOR

·         V$SESSION

·         V$CIRCUIT

·         V$DISPATCHER & V$DISPATCHER_CONFIG

·         V$QUEUE

SECURITY: IMPLEMENTING DATABASE SECURITY

·         DATABASE SYSTEM PRIVILEGES

·         DATABASE OBJECT PRIVILEGES

·         ADMINISTRATOR AUDITING OF DATABASE ACTIVITY

·         ENHANCED DEFAULT SECURITY SETTINGS

·         SECURITY: ADMINISTERING USER SECURITY

·         CREATE & MANAGE DATABASE ACCOUNTS

·         GRANT & REVOKE DATABASE PRIVILEGES

·         RESOURCE LIMITS VIA PROFILES

·         ALTER PROFILE

·         DROP PROFILE

·         PASSWORD MANAGEMENT VIA PROFILES

·         ABOUT ROLE-BASED SECURITY

·         WITH ADMIN OPTION

·         ALTER USER...DEFAULT ROLE

·         SET ROLE

·         ENHANCED DEFAULT SECURITY SETTINGS

·         MOVING DATA: SQL LOADER

·         LOADER CONCEPTS

·         CONTROL FILE OPTIONS

·         LOAD METHODS

·         USING THE EM INTERFACE

MOVING DATA: EXPORT & IMPORT

·         MANAGE DIRECTORY OBJECTS

·         ABOUT THE DATA PUMP ARCHITECTURE

·         DATA PUMP EXPORT

·         DATA PUMP IMPORT

·         DATA PUMP DATA DICTIONARY VIEWS

·         USING THE EM INTERFACE

DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT

·         THE MANAGEMENT & ADVISORY FRAMEWORK

·         MANAGE THE AUTOMATIC WORKLOAD REPOSITORY

·         AUTOMATIC DATABASE DIAGNOSTIC MONITOR

·         USE METRICS & ALERT THRESHOLDS

·         AUTOMATIC MAINTENANCE TASKS

·         MANAGING CONCURRENCY & LOCKS

·         ABOUT LATCHES & LOCKS

·         MANAGE & MONITOR LATCHES

·         MANAGE & MONITOR LOCKS

·         V$LOCK

·         V$LOCKED_OBJECT

·         V$SESSION

·         V$SESSION_WAIT

·         DBA_BLOCKERS & DBA_WAITERS

·         DBA_DML_LOCKS & DBA_DDL_LOCKS

·         DML_LOCKS

BACKUP & RECOVERY CONCEPTS & CONFIGURATION

·         ABOUT DATABASE BACKUP & RECOVERY STRUCTURES

·         MANAGING REDO DATA

·         MANAGING ARCHIVAL DATA

·         AUTOMATIC CRASH RECOVERY

·         CREATING A BASIC BACKUP STRATEGY