You notice a high number of waits for the db file scattered read and db file sequential read events
in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation,
you find that queries are performing too many full table scans and indexes are not being used
even though the filter columns are indexed.
Identify three possible reasons for this.
A.
Missing or stale histogram statistics
B.
Undersized shared pool
C.
High clustering factor for the indexes
D.
High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E.
Oversized buffer cache
Explanation:
D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use
to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O
operation during a sequential scan. The total number of I/Os needed to perform a full table scan
depends on such factors as the size of the table, the multiblock read count, and whether parallel
execution is being utilized for the operation.
E instead of C?
C is correct: High clustering factor for the indexes will cause the CBO to use FULL table scan instead of using the index.
ACD as the indexes can be defeated by missing stats/histograms, high clustering factor, high value for db_file_multiblock_read_count which can make full table scan for small tables cheaper that using indexes
Setting the value for DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter too high which favors full scans
Here are some of the websites we suggest for our visitors.
we came across a cool web-site that you simply may well take pleasure in. Take a appear if you want
Here is a superb Weblog You may Uncover Interesting that we Encourage You
here are some links to websites that we link to mainly because we consider they are worth visiting
that could be the end of this post. Right here you will locate some sites that we believe youll value, just click the hyperlinks over
check beneath, are some absolutely unrelated websites to ours, nevertheless, they may be most trustworthy sources that we use
here are some links to websites that we link to simply because we feel they are worth visiting
Here is an excellent Blog You may Discover Fascinating that we Encourage You
Wonderful story, reckoned we could combine a handful of unrelated information, nevertheless truly really worth taking a search, whoa did one particular find out about Mid East has got much more problerms at the same time
Wonderful story, reckoned we could combine a number of unrelated data, nonetheless actually worth taking a appear, whoa did 1 discover about Mid East has got far more problerms too
Sites of interest we’ve a link to
ACD