Which two inferences can you derive from the details in…

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section?(Choose two.)

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section?(Choose two.)

A.
The values for Redo size and Block changes imply that only updates were performed by
transactions.

B.
The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred
quite often.

C.
The values for DB Time and DB CPU imply that the database had a high proportion of
idle time during the specified snapshot interval.

D.
The values for SQL Work Area and User calls imply that only sort-based operations were
performed.

E.
The values for Logical reads and Physical reads imply that the number of disk reads per
second was less than the total number of DB block reads and consistent gets per second.



Leave a Reply 3

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


vasya

vasya

imo B and E are right