Page History
...
Precise for Oracle is capable of providing additional insight into a problem by helping you focus on the item or object that is causing the problem. When you click on certain findings in the SQL tab or the Object tab, and you launch to the tab that can provide additional information on the problem, the row representing the item or object that is most likely causing the problem is highlighted. This provides a further indication as to where you should focus your analysis.
About the Highlights area
The Highlights area displays a brief description of the findings for the selected type of operation.
The What to do next area displays one or more recommended steps to identify the cause of the problem. Carefully review all data for the finding before continuing.
About the Advice area
The Advice area displays one or more recommended options to resolve or reduce the problem for the selected finding. Carefully review all data for the finding and then perform the advice that best suits your needs.
How to investigate findings
When you start investigating the findings, it is good practice to start with the finding that has the highest severity ranking in the Findings table.
...
Several Dashboard tab findings exist in the table to help the user. The Dashboard tab for an instance has the following findings:
- High CPU Wait
- High Other Host Wait
- High Memory Wait
- High Shared Pool Wait
- High Rollback Segment Wait
- High Redo Log Buffer Wait
- High Log Switch and Clear Wait
- High RAC/OPS Wait
- High Other Lock Wait
- High Background Process Wait
- High Parallel Query Server Wait
- High Buffer Wait
- High Other Wait
- High Remote Query Wait
- High Client Communication Wait
- High Resource Manager Wait
- High MTS Wait
- Heavy Statement
- Frequently Executed Statement
- Heavily Accessed Object
- Locked Object
- High Sorts on Disk
- High Undo Activity
- Heavily Accessed Cluster
- Locked Cluster
- Storage Contention on Device (Clariion)
- Storage Contention on Device (Symmetrix Thick)
- Storage Contention on Device (Symmetrix Thin)
- Storage Contention on Device (Symmetrix F.A.S.T. VP)
- Storage Contention on Redo Logs and DB Files
- Storage Contention on Temporary Objects
- Heavy Storage Device Holding Undo Objects
- Unbalanced Storage Devices Activity
- Heavy J2EE Caller Service
- High SQL Executions for J2EE Caller Service
Anchor | ||||
---|---|---|---|---|
|
Your instance has spent much of its In Oracle time waiting for CPU.
Table 12-1 High CPU Wait
...
Description |
---|
What to do |
...
next | Perform one of the following options: |
...
|
...
|
...
|
...
|
Advice |
...
Perform one of the following options: |
...
|
...
|
...
|
Anchor | ||||
---|---|---|---|---|
|
Your instance has spent much of its In Oracle time in Other Host Wait.
Table 12-2 High Other Host Wait
...
Description |
---|
What to do |
...
next | Perform one of the following options: |
...
|
...
|
Advice |
...
Other Host Wait can result from any of the following causes: asynchronous I/O, gateways, or the use of NFS and TP monitors. Check the statements and programs suffering from this state and check whether the above resources are being utilized efficiently. |
High Memory Wait
Your instance has spent much of its In Oracle time waiting for memory.
...