Database Administration (MOSC)

MOSC Banner

AWR snapshots not capturing regularly

edited Mar 12, 2013 5:45AM in Database Administration (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center