error gathering statistics on less than 100 %
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 22 Dec 2005 15:24:50 -0400
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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
