how to gather statistics in oracle 9i [message #417575] |
Mon, 10 August 2009 05:48  |
suryakantnirala
Messages: 19 Registered: May 2009 Location: Mumbai
|
Junior Member |
|
|
where i am gather statistics using dbms_stats
"sql>exec dbms_stats.gather_schema_stats ( -
ownname => 'DOMAIR', -
options => 'GATHER', -
estimate_percent => dbms_stats.auto_sample_size, -
method_opt => 'for all columns size auto', -
cascade => true, -
degree => 5 -
)
/"
then it's display an error which is given below
/
"BEGIN dbms_stats.gather_schema_stats ( ownname => 'DOMAIR',
options => 'GATHER', estimate_percent => dbms_stats.auto_sample_
size, method_opt => 'for all columns size auto', cascade
=> true, degree => 5 ); END;
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.DBMS_STATS", line 10301
ORA-06512: at "SYS.DBMS_STATS", line 10795
ORA-06512: at "SYS.DBMS_STATS", line 10982
ORA-06512: at "SYS.DBMS_STATS", line 11036
ORA-06512: at "SYS.DBMS_STATS", line 11013
ORA-06512: at line 1
SQL> SP2-0103: Nothing in SQL buffer to run."
please help me solve it
|
|
|
|
|