被收集统计信息反复毒打-凯发app官方网站

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分钟

阅读(657) | 评论(0) | 转发(0) |

上一篇：表空间脱个机吧

下一篇：达梦temp管理

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们