1) ENTERPRISE EDITION INSTALLATION

• IDENTIFY SYSTEM REQUIREMENTS
  • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
  • ORACLE_BASE
  • ORACLE_HOME
  • CONFIGURE THE INSTALLATION ENVIRONMENT
  • ENTERPRISE EDITION INSTALLATION
  • DBCA

2) THE ADMINISTRATOR INTERFACE

• ENTERPRISE MANAGER TOUR
  • USING EM SQL WORKSHEET
  • DUTIES OF A DATABASE ADMINISTRATOR
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL

3) THE ORACLE ENTERPRISE ARCHITECTURE

4) 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

5) EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES

• INSTANCE BACKGROUND PROCESSES
  • SQL EXECUTION PROCESSES

6) CREATING AN ORACLE DATABASE

• CREATE A NEW DATABASE
  • CONFIGURE AN EXISTING DATABASE
  • DROP A DATABASE
  • MANAGE DBCA TEMPLATES
  • MANUALLY CREATE A DATABASE

7) 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

8) MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES

• ABOUT TABLESPACES
  • TABLESPACE MANAGEMENT
  • DROP TABLESPACE
  • ALTER TABLESPACE

9) 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

10) MANAGE DATABASE STORAGE STRUCTURES

• DATA FILES & TEMP FILES
  • MANAGING DATA FILES
  • MANAGING TEMP FILES
  • ENABLE ORACLE-MANAGED FILES (OMF)

11) 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

12) 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

13) SECURITY: IMPLEMENTING DATABASE SECURITY

• DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
  • ENHANCED DEFAULT SECURITY SETTINGS

14) 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

15) MOVING DATA: SQL LOADER

• LOADER CONCEPTS
  • CONTROL FILE OPTIONS
  • LOAD METHODS
  • USING THE EM INTERFACE

16) 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

17) DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT

• THE MANAGEMENT & ADVISORY FRAMEWORK
  • MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
  • AUTOMATIC DATABASE DIAGNOSTIC MONITOR
  • USE METRICS & ALERT THRESHOLDS
  • AUTOMATIC MAINTENANCE TASKS

18) 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

19) BACKUP & RECOVERY CONCEPTS & CONFIGURATION

• ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
  • MANAGING REDO DATA
  • MANAGING ARCHIVAL DATA
  • AUTOMATIC CRASH RECOVERY
  • CREATING A BASIC BACKUP STRATEGY