SQL Performance (MOSC)

MOSC Banner

DBMS_STATS.GATHER_SCHEMA_STATS method is not gathering statistics of all the tables of a given schem

edited Mar 5, 2016 4:04AM in SQL Performance (MOSC) 19 commentsAnswered
Hi,
In our database I observed that DBMS_STATS.GATHER_SCHEMA_STATS method is not gathering statistics of all the tables of the given schema.

We are gathering statistics with below script.

==========================================================================================
exec dbms_Stats.gather_schema_stats(ownname=>'SCHEMA_NAME',cascade=>TRUE,estimate_percent=>40);
==========================================================================================

Also these tables are not temporary tables. I want to know what is happening because of which all the tables are not getting analyzed.

Please help to understand this.

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