Database DataWarehousing (MOSC)

MOSC Banner

DBMS_STATS - non-partition table - how to gather stats without GLOBAL stats?

edited Oct 11, 2010 6:42PM in Database DataWarehousing (MOSC) 5 commentsAnswered
 I am trying to gather stats on a data load table as follows and it is some how gathering GLOBAL stats which I don't want. not sure what changed.
exec DBMS_STATS.GATHER_TABLE_STATS(user,'T_STAGE_LOAD' ,estimate_percent => 35 ,degree =>4,CASCADE => FALSE);

OWNER, TABLE_NAME, NUM_ROWS, SAMPLE_SIZE, LAST_ANALYZED, GLOBAL_STATS
 PROD, TABLE_DBMS_STATS, 1000, 1000,10/7/2010 10:36:31 PM,YES
 PROD,T_STAGE_LOAD,8530940,2985829,10/7/2010 6:30:36 PM,YES


I also tried the following test on a small test table but Oracle still gathering GLOBAL stats:

DELETE stats: exec dbms_ddl.analyze_object(type => 'TABLE', schema => 'RXERPROD', name => 'TABLE_DBMS_STATS', method => 'DELETE')

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