AWR snapshots not capturing regularly
HI Experts,
I found thar AWR snapshots are not capturing regularly.
Enter value for num_days: 5
Listing the last 5 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
prod PROD 14738 11 Mar 2013 13:30 2
14739 11 Mar 2013 14:30 2
14740 11 Mar 2013 15:30 2
14741 11 Mar 2013 16:30 2
14742 11 Mar 2013 17:30 2
14743 11 Mar 2013 18:30 2
14744 11 Mar 2013 19:30 2
14745 11 Mar 2013 20:30 2
14746 11 Mar 2013 21:30 2
14747 11 Mar 2013 22:30 2
14767 12 Mar 2013 14:30 2
14768 12 Mar 2013 15:30 2
14769 12 Mar 2013 16:30 1
And also i fi=ound more growth in Sysaux tablespace regularly.
Recently I changed statistics_level to All . Is this causes this issue?
Regards,
Raaza
I found thar AWR snapshots are not capturing regularly.
Enter value for num_days: 5
Listing the last 5 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
prod PROD 14738 11 Mar 2013 13:30 2
14739 11 Mar 2013 14:30 2
14740 11 Mar 2013 15:30 2
14741 11 Mar 2013 16:30 2
14742 11 Mar 2013 17:30 2
14743 11 Mar 2013 18:30 2
14744 11 Mar 2013 19:30 2
14745 11 Mar 2013 20:30 2
14746 11 Mar 2013 21:30 2
14747 11 Mar 2013 22:30 2
14767 12 Mar 2013 14:30 2
14768 12 Mar 2013 15:30 2
14769 12 Mar 2013 16:30 1
And also i fi=ound more growth in Sysaux tablespace regularly.
Recently I changed statistics_level to All . Is this causes this issue?
Regards,
Raaza
0