Session 1: INTRODUCTION TO ORACLE DATABASE 10g
- Relational database concepts
- Database administration tasks
- DBA responsibilities
Session 2: ORACLE DATABASE 10g ARCHITECTURE
- Oracle architecture
- The Oracle instance
- Memory structures
- Background processes
- Server and client processes
- The Oracle database
Session 3: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE
- Installation Prerequisites
- Understand system requirements
- Use optimal flexible architecture
- Authentication methods for a database
- Oracle environment variables
- Install Oracle software using the Oracle Universal Installer (OUI)
- Use the Database Configuration Assistant (DBCA) to create a database
- Use DBCA to manage templates
- Upgrade a database using Database Upgrade Assistant (DBUA)
Session 4: ADMINISTER A DATABASE
- Administrative tools available to a DBA
- Using SQL*Plus in Oracle to manage a database
- Administer the database using Enterprise Manager (EM)
- Start and stop the agent
- Start and stop the EM Database Console
- Access EM
- EM navigation
- Grant EM administrative privileges to a user
Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
- Overview of network configuration
- Oracle Net Listener configuration and management
- Oracle Net Naming methods
- Tools for configuring and managing the Oracle network
- Configure client connections with Net Manager
- View listener configuration
- Start and stop the Oracle listener
- Use TNSPING to test Oracle Net connectivity
- Connect to the database
Session 6: MANAGE AN ORACLE INSTANCE
- Access an Oracle database
- Database authentication methods
- Initialization parameters
- Password file
- SHUTDOWN the database
- STARTUP the database
- View alert log and trace files
Session 7: TABLESPACE AND DATAFILE MANAGEMENT
- Overview of tablespaces and datafiles
- Use EM to view the storage structure of the database
- Create tablespace commands
- Locally managed tablespaces
- Dictionary managed tablespaces
- Bigfile tablespaces
- Temporary tablespaces
- Multiple temporary tablespaces
- Create tablespaces
- Manage tablespaces
- Use standard and non-standard block sizes
- Create and manage tablespaces using OMF
- Manage tablespaces
Session 8: MANAGE REDO LOGS
- Redo log file structure
- Maintaining redo log files
- Log switches and checkpoints
- Multiplex redo log files
- Manage online redo log files with OMF
- List redo log information
Session 9: MANAGE CONTROL FILES
- The usage of the control file
- The contents of a control file
- Manage control files
- Standby control file
- Manage control files with OMF
- List control file information
Session 10: MANAGE SCHEMA OBJECTS
- Create a new table
- View the attributes and contents of a table
- Understand data integrity
- Define constraints
- Create indexes
- View index attributes
- Create views
- Create and use sequences
Session 11: MANAGE USERS
- Database administration accounts
- User accounts
- Create a user account
- Change a user's password
- Alter and drop a user account
- Monitor user information
- Terminate user sessions
Session 12: MANAGE PROFILES AND RESOURCES
- Create profile command
- Manage passwords with profiles
- Control resource usage with profiles
- Alter and drop profile command
Session 13: MANAGING PRIVILEGES
- Database access
- System level roles and privileges
- Object level privileges
- The grant and revoke commands
- Create roles
- Modify and drop roles
- Control the availability of roles
- Use predefined roles
- Synonyms
- Listing valid grants
- Product user profiles
Session 14: DATABASE AUDITING
- Auditing SYS statements
- Auditing end user sessions
- Auditing the use of privileges
- Auditing modifications made to database objects
- Audit table relocation
- Fine grained auditing
Session 15: UNDO MANAGEMENT
- Undo data overview
- Monitor and administer undo
- Configure undo retention
- Guarantee undo retention
- Use the undo advisor
- Size the undo tablespace
Session 16: MANAGE DATA
- Use Data Pump to export data
- Use Data Pump to import data
- Use SQL Loader
- Create directory objects
Session 17: ORACLE SHARED SERVER
- When shared servers should be used
- Configure shared servers
- Monitor shared servers
- Shared server architecture
Session 18: MONITORING AND RESOLVING LOCK CONFLICTS
- Detect and resolve lock conflicts
- Manage deadlocks
Session 19: PROACTIVE DATABASE MAINTENANCE
- Automatic Workload Repository
- Automatic Database Diagnostic Monitoring
- Monitor an Oracle database
- Use the Advisors
- Set up notification rules
Session 20: PERFORMANCE MONITORING
- Troubleshoot invalid and unusable objects
- Gather optimizer statistics
- View performance metrics
- React to performance issues
Session 21: BACKUP AND RECOVERY CONSIDERATIONS
- Oracle Suggested Backup Strategy
- Database backup, restore and recover
- Types of failure
- Tune instance recovery
- Checkpoints, redo log files and archive log files
- Configure ARCHIVELOG mode
- Configure a database for recoverability
Session 22: DATABASE BACKUPS
- Types of RMAN backup
- Backup sets and image copies
- Create consistent database backups
- Perform online backups
- Perform incremental backups
- Automate database backups
- Monitor the flash recovery area
- Manage backups
Session 23: DATABASE RECOVERY
- Recover from the loss of a system critical data file
- Recover from the loss of a non system critical data file
- Recover from the loss of a control file
- Recover from the loss of a redo log file
Session 24: FLASHBACK
- Flashback Query
- Flashback Version Query
- Flashback Transaction Query
- Flashback Table
- Flashback Drop