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 Loa 1 (2.02 MiB) Viewed 152 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!