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 containing many deleted blocks is 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 or more of the following options: n Eliminate full table scan by: Creating an index matching the statements predicates. Partitioning the table according to the best predicates existing in the statements. n Treat deleted blocks: Consider exporting the table data, truncating the table, and then reloading the data. If the dirty blocks problem is repeated, the reorganization solution may be less relevant and the user can use an index using range scan or even full index scan to reduce access to the table. 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