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
Table extensively accessed via Full Table Scans.
| Description | |
| What to do next | Perform the following options: n Examine associated statements in the Statements tab. Focus on Full Table Scan access types in the Access Types table. n Examine column usage for each statement in the Columns table. |
| Advice | Perform one of the following options: n Eliminate Full Table Scan by: Trying to identify common high selectivity columns for the top statements. Create an index matching the statements predicates. Partitioning the table according to the best predicates existing in the statements. n Improve Full Table Scan by: Moving the table to another tablespace with a higher block size. Increasing the value of the DB_FILE_MULTIBLOCK_READ_COUNT init.ora parameter. |
No comments:
Post a Comment