To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.
- Planning and Tuning Activities - identify the tuning steps required to establish the Oracle Database 11g environment.
- Performance Monitoring and Management - identify the steps for monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors.
- SQL Tuning and Access Advisors - recognize the steps for using the SQL Tuning Advisor and SQL Access Advisors to analyze SQL statements and improve data retrieval.
- Using Database Replay - recognize the general steps required to capture a production workload and replay it in a test environment, using the Database Replay feature.
- Tuning a SQL Statement - identify a high load SQL statement and then tune it using the SQL Tuning Advisor.
- Managing and Monitoring Space - recognize the steps for generally managing and monitoring space in Oracle Database 11g.
- Reclaiming Space - recognize the steps for shrinking segments and reclaiming available space using the Segment Advisor and resumable statements.
- Transportable Tablespaces - identify the steps for moving large volumes of data between two Oracle Database 11g databases, using transportable tablespaces.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.