Database Tuning (MOSC)

MOSC Banner

ORA-01007: variable not in select list and ORA-06512: at "SYS.DBMS_STATS", line 15188

edited Aug 13, 2012 5:36PM in Database Tuning (MOSC) 9 commentsAnswered
Dear all,

I have upgraded my database version from 10.2.0.4.3 to 10.2.0.5.7.  After upgrade, i ran the gather schema as

exec dbms_stats.gather_schema_stats(ownname=>'PENTAISF',options=> 'GATHER',estimate_percent => 30,method_opt=> 'FOR ALL COLUMNS SIZE AUTO',cascade=> TRUE,degree=> 5)

This process took about 79 hours to complete.  After completed, i ran another gather schema with ,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY as

BEGIN dbms_stats.gather_schema_stats(ownname=>'PENTAISF',options=>'GATHER',estimate_percent => 30,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY',cascade=>TRUE,degree=> 5); END;

this process took about 81:19:47.37 hours, but it prompt out error and this process terminated. The error is

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