Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> error gathering statistics on less than 100 %
Hi,
I found a curious problem on 9.2 when trying to get less than 100% on a table
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M
E', ESTIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWON
LY');
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_ME', E
STIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY');
END;
*
ERROR en lƯnea 1:
ORA-00904: : identificador no vßlido ORA-06512: en "SYS.DBMS_STATS", lƯnea 9136 ORA-06512: en "SYS.DBMS_STATS", lƯnea 9150 ORA-06512: en lƯnea 1
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M
E', ESTIMATE_PERCENT=>1, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONL
Y');
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_ME', E
STIMATE_PERCENT=>1, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY');
END;
*
ERROR en lƯnea 1:
ORA-00904: : identificador no vßlido ORA-06512: en "SYS.DBMS_STATS", lƯnea 9136 ORA-06512: en "SYS.DBMS_STATS", lƯnea 9150 ORA-06512: en lƯnea 1
But when I get 100% I don't get that problem.
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M E', ESTIMATE_PERCENT=>100, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWO NLY'); Procedimiento PL/SQL terminado correctamente.
Trying with other tables I don't get that problem.
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'CUENTAS_ME', ESTIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY' );
Procedimiento PL/SQL terminado correctamente.
SQL>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 22 2005 - 20:24:50 CST
![]() |
![]() |