Oracle Database 10g DBA - Part I

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
• Backup the control file
• 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
• Product user profiles

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

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
• Flashback Database