Database Administration (MOSC)

MOSC Banner

would like to retrieve the parameters used in gather stats procedure

edited Sep 27, 2013 5:50PM in Database Administration (MOSC) 7 commentsAnswered
suppose if i have executed the below procedure:

exec dbms_stats.GATHER_TABLE_STATS(ownname =>'PHERMES',TabName=>'PAYMENTRETURN',estimate_percent => 30, method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE, DEGREE=>DBMS_STATS.AUTO_DEGREE);

How can i retrieve the parameters used above like estimate_percent,method_opt,cascade and DEGREE later if i want to cross-check......

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