|
Provided by: 123-CBT Computer Based Training Oracle Database 11g Database Performance and Space Management |
 |
Training
Provided by 123-CBT Computer Based Training
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.
|
|
||||||||
Oracle Database 11g Database Performance and Space Management
Overview:
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.Pre-Requisites:
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop ITarget Audience:
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.Modality:
WEBLesson:
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.|
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
