Oracle
1Z0-064 · Question #89
For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)
The correct answer is C. to identify which module in an application was being executed in a session E. to find the amount of Program Global Architecture (PGA) memory being currently consumed by a. See the full explanation below for the reasoning.
Question
For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)
Options
- Ato investigate intermittent performance problems in a session, only when the problem lasted less
- Bto find the exact number of executions of a specific query in a session in the last two minutes
- Cto identify which module in an application was being executed in a session
- Dto identify a scheduler job that is not responding
- Eto find the amount of Program Global Architecture (PGA) memory being currently consumed by a
How the community answered
(15 responses)- A7% (1)
- B13% (2)
- C80% (12)
Community Discussion
No community discussion yet for this question.