Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> error gathering statistics on less than 100 %

error gathering statistics on less than 100 %

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: 2005-12-22 20:24:50
Message-id: cd4305c10512221124x54a19a5ek5303d4826523cc5b@mail.gmail.com


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-l
Received on Thu Dec 22 2005 - 20:24:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US