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 resources are spent performing Full index scans on the index specified in the Object column
| Heavy Index Full Scan finding |
| Description | |
| What to do next | Perform one of the following options: n Click the Locate icon to focus on the relevant step in the execution plan. n Select the finding type to investigate the objects used and their structure in the Objects tab. n Select the finding type to investigate step statistics and resource consumption in the Statistics tab. |
| Advice | To reduce the Full Scan resource consumption consider: n Creating an index matching the statement’s predicates. n If the full scan is using I/O heavily and the step name is a fast full scan, consider changing the DB_FILE_MULTIBLOCK_READ_COUNT init.ora parameter to a higher value. n Partition the table according to the best predicates existing in the statement. n Use a parallel query option. n Move the table to another tablespace with a higher block size. |
.
No comments:
Post a Comment