Home » RDBMS Server » Performance Tuning » dba_hist_snapshot vs dba_hist_active_sess_history (oracle 11g rel 2 (11.2.0.3.0))
dba_hist_snapshot vs dba_hist_active_sess_history [message #614259] Tue, 20 May 2014 02:31 Go to next message
ind9
Messages: 60
Registered: January 2009
Member
Hi,
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!

Regards
Ind
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
BlackSwan
Messages: 23151
Registered: January 2009
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: Sat Dec 20 07:47:41 CST 2014

Total time taken to generate the page: 0.11607 seconds