10 Useful queries Active Session History(Oracle ASH)

What is Active Session History(ASH) Active Session History (ASH) was introduced in Oracle 10g. It samples the activity of each active database session every second. The data is held in a buffer in memory in the database.The design goal is to keep about an hour (your mileage will vary). If a session is not active …

10 Useful queries Active Session History(Oracle ASH) Read More »