Oracle Database 11g: Performance Tuning (1Z0-054 )

Basic Tuning Tools [  ] Diagnose performance issues using top wait events and the time model [  ] Use dynamic performance views to view statistics and wait events [  ] Use Enterprise Manager Monitoring [  ] Identify the key tuning components of the alert logs Using Automatic Workload Repository [  ] Create and manage AWR snapshots [  ] Generate and read AWR reports, analyze Compare Periods reports Defining Problems [  ] Identify performance issues & set tuning priorities [  ] Interpret tuning diagnostics [  ] Tune for life cycle phase Using Metrics and Alerts [  ] Interprete metric views and alerts Baseline [  ] Create and manage AWR baselines [  ] Create AWR baselines for future time periods [  ] Monitor performance and enable adaptive thresholds Using AWR-Based Tools [  ] Tune automatic maintenance tasks [  ] Analyze ADDM reports [  ] Analyze Active Session History (ASH) reports Monitoring an Application [  ] Configure and manage services [  ] Use services with client applications, Database Resource Manager and Scheduler [  ] Configure services aggregation, tracing, and set performance-metric thresholds

Identifying Problem SQL Statements [  ] Describe SQL statement processing [  ] View the SQL statement statistics to identify the SQL statements that perform poorly [  ] Describe and use methods for Viewing Execution Plans Influencing the Optimizer [  ] Describe the optimizer's behavior [  ] Adjust parameters to influence the optimizer [  ] Influence the optimizer (access methods, join techniques and adjust data structures) SQL Performance Management [  ] Manage optimizer statistics [  ] Configure automatic SQL tuning and SQL profiling [  ] Set up and use SQL plan baseline Using SQL Performance Analyzer [  ] Describe SQL Performance Analyzer process and benefits [  ] Use SQL Performance Analyzer Using Database Replay [  ] Identify when and how to use Database Replay [  ] Use Enterprise Manager to record and replay workloads Tuning the Shared Pool [  ] Describe Latches and Mutexes [  ] Diagnose and change cursor sharing [  ] Diagnose and resolve shared pool fragmentation [  ] Manage the results cache and tune the large pool [  ] Tune the data dictionary cache

Tuning the Buffer Cache [  ] Describe the buffer cache architecture [  ] Explain the symptoms that indicate a buffer cache problem [  ] Tune the buffer cache for performance issues Tuning PGA and Temporary Space [  ] Diagnose PGA memory issues and size the PGA [  ] Diagnose temporary space issues [  ] Specify temporary tablespace parameters for efficient operation Automatic Memory Management [  ] Implement Automatic Shared Memory Management (ASMM) [  ] Implement Automatic Memory Management (AMM) Tuning Segment Space Usage [  ] Tune segment space management [  ] Use Automatic Segment Space Management [  ] Diagnose row migration and chaining [  ] Use segment shrinking and table compression Tuning I/O [  ] Diagnose database I/O issues [  ] Describe the Stripe and Mirror Everything (SAME) concept [  ] Set filesystemio_options and Choose appropriate I/O solutions [  ] Tune Automatic Storage Management (ASM) Appendix B Using Statspack [  ] Using Statspack

 

转载于:https://www.cnblogs.com/mengheyun/archive/2011/01/23/1949561.html