Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening?

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)

A.
too many buffer busy waits

B.
very low buffer cache-hit ratio

C.
very high buffer cache-hit ratio

D.
many waits on the db file scattered read event



Leave a Reply 0

Your email address will not be published. Required fields are marked *