What is the Active Session History (ASH) buffer?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the Active Session History (ASH) buffer?
Rating:
The Active Session History buffer is defined as a first-in, first-out buffer in memory that collects statistics on current session activities. The statistics are gathered by extracting samples from the V view every second. Since the statistics are gathered every second, the system gets overwhelmed very soon. To avoid this, ASH continually flushes out all old statistics and replaces it by newer statistics. The ASH buffer is present in the SGA and its size is fixed for the lifetime of the instance.
Rating:
Was this information helpful?
Other articles
- What is V?
- What is the db_flashback_retention_target parameter?
- What are non-critical files?
- What is the CHANGE command?
- What is ORBn?