Database Administration (MOSC)

MOSC Banner

dbms_stats versus Gather Schema Stats Concurrent Program

edited Jan 12, 2010 5:03PM in Database Administration (MOSC) 5 commentsAnswered
Hi,

Does anyone the difference between the dbms_stats job done via back end versus the Gather Schema Stats submitted via the UI ( concurrent program ) for a particular schema.

Whenever I requests stats, my DBA does the dmbs_stats using sql*plus. I see some differences when this is done vs UI.

Thanks 

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