1Z0-457 · Question #35
What feature of the Diagnostic Pack for Oracle Database collects statistics on all active sessions and stores it in memory?
The correct answer is A. Active Session History (ASH). Oracle introduced Active Session History (ASH) in Oracle Database 10g. ASH automatically collects session related wait information via the Oracle database kernel (thus reducing the impacts of the collection of this information). The information is first captured into a memory…
Question
What feature of the Diagnostic Pack for Oracle Database collects statistics on all active sessions and stores it in memory?
Options
- AActive Session History (ASH)
- BAutomatic Database Diagnostic Monitor (ADDM)
- CAutomatic Workload Repository (AWR)
- DAutomatic Storage Management (ASM)
How the community answered
(30 responses)- A70% (21)
- B10% (3)
- C17% (5)
- D3% (1)
Explanation
Oracle introduced Active Session History (ASH) in Oracle Database 10g. ASH automatically collects session related wait information via the Oracle database kernel (thus reducing the impacts of the collection of this information). The information is first captured into a memory buffer that is of a fixed size and is allocated from the SGA fixed area when the database is started.
Topics
Community Discussion
No community discussion yet for this question.