Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

retention period of v$actvive_session_history

1665591Jan 7 2015 — edited Jan 8 2015

Hi Gurus,

I am trying to understand the concept of ASH.I have some doubt . please clear me on th following

1. How long oracle will retain the data in v$actvive_session_history?

2. While taking the AWR snapshot i have read some thing like 1 row in 10 from the ASH buffer is copied down into the AWR repository. what may be the condition for selecting these 1 row ?

3. Is all dba_hist_ view have the same retention as specified for the AWR repository retention ?

4. How can I check if a particular query is executed in the past ? ( only specific query is provided by the developer )

I would greatly appreciate any help

Thanks in Advance,

Mahi

This post has been answered by Hemant K Chitale on Jan 7 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2015

Added on Jan 7 2015

#general-database-discussions

7 comments

2,364 views