Heavy Scattered I/O on Index Wait

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

Statement I/O is spent on scattered I/O (usually representing a full scan) on the index specified in the Object column.

Heavy Scattered I/O on Index findings

	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 index I/O 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.

    

Get Oracle Certifications for all Exams
Free Online Exams.com