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.Learning Objectives
- 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.