Oracle
1Z0-064 · Question #49
Examine the Load Profile section of an AWR report: Which two inferences can you derive from the details in this section? (Choose two.)
The correct answer is B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite D. The values for SQL Work Area and User calls imply that only sort-based operations were. See the full explanation below for the reasoning.
Question
Examine the Load Profile section of an AWR report:
Which two inferences can you derive from the details in this section? (Choose two.)
Exhibit
Options
- AThe values for Redo size and Block changes imply that only updates were performed by
- BThe values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite
- CThe values for DB Time and DB CPU imply that the database had a high proportion of idle time
- DThe values for SQL Work Area and User calls imply that only sort-based operations were
- EThe values for Logical reads and Physical reads imply that the number of disk reads per second
How the community answered
(60 responses)- A10% (6)
- B83% (50)
- C3% (2)
- E3% (2)
Community Discussion
No community discussion yet for this question.
