Database Tuning (MOSC)

MOSC Banner

How to find the tables that have stale statistics

edited Sep 30, 2012 10:54PM in Database Tuning (MOSC) 4 commentsAnswered
Hi Team,

I need a small clarification about stale statistics.Below are my queries so please clarify me

1.      How to find the tables that have stale statistics? (both database and schema level)

2.      Why is mark as stale?

3.      How to enable it?

4.      What is the impact if the object is stale state?

5.      Is there any performance impact if the object is stale?

Database version is 10.2.0.4

Thank you....

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