error gathering statistics on less than 100 % 2005-12-22 - By Juan Carlos Reyes Pacheco
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 (See ORA-00904.ora-code.com): : identificador no v?lido
ORA-06512 (See ORA-06512.ora-code.com): en "SYS.DBMS_STATS", l?nea 9136
ORA-06512 (See ORA-06512.ora-code.com): en "SYS.DBMS_STATS", l?nea 9150
ORA-06512 (See ORA-06512.ora-code.com): 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 (See ORA-00904.ora-code.com): : identificador no v?lido
ORA-06512 (See ORA-06512.ora-code.com): en "SYS.DBMS_STATS", l?nea 9136
ORA-06512 (See ORA-06512.ora-code.com): en "SYS.DBMS_STATS", l?nea 9150
ORA-06512 (See ORA-06512.ora-code.com): 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-l
|
|
