Using Performance Analysis
Performance Analysis offers a rich set of sophisticated and user-friendly features that enable DBAs to rapidly and effectively focus their attention on application and database related performance issues, solve problems quickly and improve overall application responsiveness throughout the application lifecycle.
The following library of animated demonstrations shows how commonly occurring use cases can be resolved employing Performance Analysis.
|
DBA Use Case |
Solution Methodology |
Demo |
|
Identifying Performance Deviation |
Using the Review Performance Deviations hyperlink, we investigate causes and solutions to wait contention |
|
|
Identifying real-time problematic session/statement consuming I/O resources |
Using the Real-time Top Sessions tab, we can review the most I/O resource consuming sessions/statements. |
|
|
Understanding an impact of schema changes on performance |
Using the Change Tracking Tab in History mode, we can identify the database schema changes causing the execution plan change and its resulting performance degradation. |
|
|
Diagnosing and resolving real time lock contention |
Using the Real-time Blocking locks tab, we can review the sessions/statements generating the lock contention. |
|
|
Diagnosing redo log contention |
Using the Advisories hyperlink, the cause of contending redo log activity can be identified and addressed. |
|
|
Shared pool latch contention |
Using the  Performance Advisories hyperlink, we investigate causes and solutions to shared pool latch contention |
|
|
Determining origin of the CPU load |
We review the system utilization metrics to determine the actual (Oracle or non-Oracle) source of CPU load. |
|
|
Diagnosing Baseline deviations |
Reconcile recent instance performance with any environmental updates using the Review Performance Deviation tab content. |
|
|
Analyzing resource metrics deviation |
Determining the reasons for resource load deviation using analysis of instance performance metrics. |
|
|
Optimizing buffer cache size |
Review diagnosis and suggested Action Plan for optimizing buffer cache size when performance degradation is caused by sub-optimal buffer cache settings. |
|
|
Diagnosing and resolving buffer busy wait |
Using the context-sensitive Performance Advisory analysis for diagnosing of buffer busy wait event and as a guide for remedial action. |
|
|
Diagnosing non-applicative (internal) locks |
Using the Performance Advisories, we can determine the source of the non-applicative (internal) lock contention and review the recommended solutions. |
|
|
Diagnosing and resolving redo log contention |
Using the context-sensitive Performance Advisory analysis to optimize redo log configuration to address the performance degradation caused by sub-optimal settings. |
|
|
Identifying application component causing high redo load |
Drill down to the most frequently executed statement causing redo log contention to understand the sudden increase in workload. |
|
|
Resolving shared pool latch contention |
Using the context-sensitive Performance Advisory analysis for diagnosing the cause of shared pool latch contention and as a guide for optimal database settings and recommendations for application tuning. |
|
|
Diagnosing latch contention |
Using the Real-time Top Sessions tab, we can review the statements/sessions generating the most intensive latch contention. |
|
|
Diagnosing high network utilization |
Using the Real-time Top Sessions tab, we can review the most network resource consuming sessions/statements |
|
|
Diagnosing and resolving resource and workload distribution across RAC nodes |
Using both real-time and history cluster representation facilitates monitoring and diagnosing of RAC workload and resource distribution for appropriate tuning. |
|
|
Diagnosing RAC nodes workload balance by means of compare utility |
Using the compare mechanism to isolate the load-imbalance causing resource. |
|
|
Analyzing instance workload against baseline using Compare utility |
Using the compare mechanism to detail a specific time period’s workload with that of the baseline. |
|
|
Using the Filter dimension feature to customize data display |
Apply the dimension filtering feature to display only the most relevant data. |
|
|
Generating Executive Workload Summary report |
For supervisory responsibilities, this mechanism provides a ready ability to access and distribute an immediate entire instance workload scorecard. |
|
|
Analyzing Oracle Application resources usage (Historical) |
Using the ERP functionality to determine which Oracle application dimensions were the greatest consumers of resources. |
|
|
Analyzing PeopleSoft resources usage (Historical) |
Using the ERP functionality to determine which PeopleSoft dimensions were the greatest consumers of resources. |
|
|
Displaying Oracle Application session details (Real-time) |
Using the ERP functionality, to understand currently running Oracle Application session details: application user, application client machine, module, etc. |
|
|
Displaying PeopleSoft session details (Real-time) |
Using the ERP functionality, to understand currently running PeopleSoft session details: application user, application client machine, module, etc. |