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 0

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