Database Tuning (MOSC)

MOSC Banner

How to check whether statistics collection for the schema/table is done by ANALYZE instead DBMS_STA

edited May 29, 2013 10:10PM in Database Tuning (MOSC) 7 commentsAnswered
Hi All,

I am  looking for the solution to find out whehter a schema or table's statistics collection gathered using DBMS_UTILITY.ANALYZE or ANALYZE TABLE command instead DBMS_STATS package?.  Please share if we able to get it from dictionary views like dba_optstat_operations for database/schema/table statistics gathered with DBMS_STATS package.

Thanks in advance,

Siva

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