被收集统计信息反复毒打

乱试

SQL> exec GATHER_SCHEMA_STATS('APP')
2 ;
exec GATHER_SCHEMA_STATS('APP')
;

exec GATHER_SCHEMA_STATS('APP')
                              *
line 1, column 53, nearby [)] has error[-2007]:
Syntax error.
used time: 0.449(ms). Execute id is 0.
SQL> CALL GATHER_SCHEMA_STATS('APP')
2 ;
CALL GATHER_SCHEMA_STATS('APP')
;
[-2207]:Error in line: 2
Member access [GATHER_SCHEMA_STATS] unresolved.
used time: 0.515(ms). Execute id is 0.
SQL> EXECUTE GATHER_SCHEMA_STATS('APP')
2 ;
 EXECUTE GATHER_SCHEMA_STATS('APP')
;

 EXECUTE GATHER_SCHEMA_STATS('APP')
                                  *
line 1, column 60, nearby [)] has error[-2007]:
Syntax error.
used time: 0.587(ms). Execute id is 0.
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
                                                                               *
line 1, column 80, nearby [,] has error[-2007]:
Syntax error.
used time: 2.217(ms). Execute id is 0.
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE);
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE);

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE);
                                                      *
line 1, column 80, nearby [,] has error[-2007]:
Syntax error.
used time: 1.851(ms). Execute id is 0.
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,NULL);
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,NULL);

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,NULL);
                                                           *
line 1, column 80, nearby [,] has error[-2007]:
Syntax error.
used time: 0.537(ms). Execute id is 0.
SQL> execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');

execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
                                                                               *
line 1, column 80, nearby [,] has error[-2007]:
Syntax error.
used time: 0.704(ms). Execute id is 0.
SQL> execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS');
execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS');

execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS');
                                                                        *
line 1, column 80, nearby [,] has error[-2007]:
Syntax error.
used time: 0.302(ms). Execute id is 0.
SQL> DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
^C
DMSQL executed successfully
used time: 00:04:18.123. Execute id is 6207.
SQL> SQL>
SQL>
SQL> DBMS_STATS.GATHER_SCHEMA_STATS('APP',1,TRUE,'FOR ALL COLUMNS SIZE AUTO');
DMSQL executed successfully
used time: 00:01:02.419. Execute id is 6208.
SQL>

收集1%也要1分钟。

怎么也得1分钟