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 table scans on the table specified in the Object column.
| Heavy Table 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 the step statistics, step resource consumption and step vs. plan over time. |
| Advice | To reduce the Full Scan resource consumption consider: n Creating an index matching the statement's predicates. n If full scan is using I/O heavily 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