Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Statement 's I/O may indicate Index Scattered read operation (often full scan) on the index specified in the Object column.
| CPU Used for Index Scattered read |
| Description | |
| What to do next | Perform one of the following options: n Click the Locate icon to find the relevant step in the execution plan. n Select the findings type to investigate the objects used and their structure in the Objects tab. n Select the Activity workspace, locate the statement associated with objects, and drill to the index consumption for the statement in the Activity workspace. |
| Advice | To reduce the CPU consumption, consider the following solutions: n If the index is not used to prevent a sort operation, consider adding the INDEX_FFS hint and change DB_FILE_MULTIBLOCK_READ_COUNT parameter to a higher value. n Switch to another index or add a new index. n Use a parallel query option. n Move the index to another tablespace with a higher block size. Findings refer to the whole statement - not to a specific execution plan. If a step does not exist in the selected execution plan (unless this is due to an index overhead), switch to another plan and locate the relevant step. |
No comments:
Post a Comment