Page History
...
Table 12-10 High Background Process Wait
...
| Description |
|---|
| What to do |
...
| next | Perform one of the following options: |
...
|
...
|
| Advice |
...
| Examine the Oracle events that are grouped into the Background Processes Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Table 12-11 High Parallel Query Server Wait
...
| Description |
|---|
| What to do |
...
| next | Perform one of the following options: |
...
|
...
|
| Advice |
...
| Examine the Oracle events that are grouped into the Parallel Query Server Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Table 12-12 High Other Wait
...
| Description |
|---|
| What to do |
...
| next | Perform one of the following options: |
...
|
...
|
| Advice |
...
| In the Statistics tab, examine the Oracle events that are grouped as Other Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Table 12-13 High Buffer Wait
Description
What to do next Perform one of the following options:
...
Table 12-14 High Remote Query Wait
Description
What to do next Perform one of the following solutions:
...
Table 12-15 High Client Communication Wait
Description
What to do next Perform one of the following options:
...
Table 12-16 High Resource Manager Wait
Description
What to do next Perform one of the following options:
...
Your instance has spent much of its In Oracle time waiting for MTS Wait.
Table 12-17 High MTS Wait
Description
What to do next Perform one of the following options:
...
Table 12-18 Heavy Statement
Description
What to do next Try to determine what is causing the statement's high resource consumption. In the SQL tab, examine the text of the relevant statement, and its findings, execution plan, change data and statistics.
...
Table 12-19 Frequently Executed Statement
Description
What to do next Go to the Activity tab and examine the statement executors (programs and users).
...
Table 12-20 Heavily Accessed Object
Description
What to do next Perform one of the following options:
...
Much of the instance In Oracle time is spent waiting for a lock on the table.
Table 12-21 Locked Object
Description
What to do next Perform one of the following options:
...
Table 12-22 High Sorts on Disk
Description
What to do next In the Activity tab, examine temporary tablespace overtime I/O consumption, and the statements using temporary tablespace I/O.
...
Table 12-23 High Undo Activity
Description
What to do next Examine Undo activity over time and the statement accessing it, in the Activity tab.
...
Table 12-24 Heavy Cluster Activity
Description
What to do next Examine Cluster activity over time and the statement accessing it, in the Activity tab.
...
Much of the instance time is spent waiting for a lock on the cluster.
Table 12-25 Cluster Locks
Description
What to do next Examine the lock for the statement in the Activity tab.
...
Table 12-26 Storage Contention On Device
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-27 Storage Contention On Device
Description
What to do next ■ Examine the device activity over time and database files contention.
...
The fact that a storage device (LUN) is causing a lot of I/O waits could be caused from an intensive load or as a result of two sorts of contentions: a logical contention (e.g. imbalanced activity of the database) or a physical contention (e.g. one of the underlying physical devices is being shared with another heavy I/O consuming activity).
Table 12-28 Storage Contention On Device Storage Contention On Device
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-29 Storage Contention On Device
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-30 Storage Contention on Redo Logs and DB Files
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-31 Storage Device on Temporary Objects
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-32 Heavy Storage Device Holding Undo Objects
Description
What to do next ■ Examine the device activity over time and database files contention.
...
Table 12-33 Unbalanced Storage Devices Activity
Description
What to do next ■ Compare the storage devices activity over time.
...
Table 12-34 Heavy J2EE Caller Service
Description
What to do next ■ Try to determine what is causing the J2EE Caller Service’s high resource consumption.
...
Table 12-35 High SQL Executions for J2EE Caller Service
Description
What to do next ■ Try to determine what is causing the J2EE Caller Service’s high resource consumption and high number of executions.
...
Table 12-36 Slow Statement
Description
What to do next Try to determine what is causing the statement's high average time. In the SQL tab, examine the text of the relevant statement, and its findings, execution plan, change data and statistics. The Recommend is executed as explain in the Recommend tab.
...
Table 12-37 Heavy Full Scan
Description
What to do next Try to determine what is causing the J2EE Caller Service to spent a high amount of its resources on performing disk related full scans on the referenced objects:
...
Table 12-38 High Redo Log Buffer Wait
Description
What to do next Perform one of the following options:
...
Table 12-39 High Buffer Wait
Description
What to do next Perform one of the following options:
...
Table 12-40 High Temporary I/O
Description
What to do next Perform the following:
...