Database Tuning (MOSC)

MOSC Banner

AWR snapshots taking too long -- fixed object stats

edited Dec 20, 2013 2:57PM in Database Tuning (MOSC) 3 commentsAnswered

Oracle 11.2.0.3 with PSU 16902043.  AWR snapshots have suddenly stopped working.  I used the information in Doc 1301503.1 to determine that they are starting, but are not completing.  Doc 1392603.1 suggests that fixed object stats might be nonexistant or stale.  I checked, and it looks like dbms_stats.gather_fixed_object_stats has not been run in YEARS!  Questins:

1.  When is the best time to run dbms_stats.gather_fixed_object_stats?  Should it be during a typical workload or can it be done with a lesser workload and the resulting stats still be okay?

2.  Will running dbms_stats.gather_fixed_object_stats affect users?  That is, will users notice any performance drag while it runs?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center