New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Oracle Exam 1Z0-457 Topic 1 Question 22 Discussion
Actual exam question for
Oracle's
1Z0-457 exam
Question #: 22
Topic #: 1
[All 1Z0-457 Questions]
Topic #: 1
What feature of the Diagnostic Pack for Oracle Database collects statistics on all active sessions and stores it in memory?
Suggested Answer:
A
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.
Currently there are no comments in this discussion, be the first to comment!