Home » RDBMS Server » Performance Tuning » dba_hist_snapshot vs dba_hist_active_sess_history (oracle 11g rel 2 (
dba_hist_snapshot vs dba_hist_active_sess_history [message #614259] Tue, 20 May 2014 02:31 Go to next message
Messages: 65
Registered: January 2009
On one of the database AWR retention period is 8 days but I see the data in dba_hist_active_sess_history older than 8 days from 15.04.2014 and in dba_hist_snapshot corresponding snap ids are not available. In dba_hist_snapshot snap ids are available only from last 8 days.
My problem is that for the month of Apr-2014, I am unable to generate AWR and unable to findout the performance bottlenecks.

Could you please advise the difference between snap ids dba_hist_snapshot and dba_hist_active_sess_history?
Why previous snap ids are not available?

Kindly suggest and please educate me.
Thanks in advance!

Re: dba_hist_snapshot vs dba_hist_active_sess_history [message #614300 is a reply to message #614259] Tue, 20 May 2014 07:30 Go to previous message
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
>I am unable to generate AWR and unable to findout the performance bottlenecks.
I am unable to make my car go.
Tell me how to make my car go.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Previous Topic: % cpu used by a session
Next Topic: what are the disadvan of using incremental stats in oracle 11g?
Goto Forum:

Current Time: Sun Nov 18 16:31:07 CST 2018