Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3688691
  • 博文数量: 715
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7745
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(715)

文章存档

2023年(75)

2022年(134)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: 数据库开发技术

2022-09-17 17:21:40


乱试

  1. SQL> exec GATHER_SCHEMA_STATS('APP')
  2. 2 ;
  3. exec GATHER_SCHEMA_STATS('APP')
  4. ;

  5. exec GATHER_SCHEMA_STATS('APP')
  6.                               *
  7. line 1, column 53, nearby [)] has error[-2007]:
  8. Syntax error.
  9. used time: 0.449(ms). Execute id is 0.
  10. SQL> CALL GATHER_SCHEMA_STATS('APP')
  11. 2 ;
  12. CALL GATHER_SCHEMA_STATS('APP')
  13. ;
  14. [-2207]:Error in line: 2
  15. Member access [GATHER_SCHEMA_STATS] unresolved.
  16. used time: 0.515(ms). Execute id is 0.
  17. SQL> EXECUTE GATHER_SCHEMA_STATS('APP')
  18. 2 ;
  19.  EXECUTE GATHER_SCHEMA_STATS('APP')
  20. ;

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

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

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

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

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

  56. execute DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS');
  57.                                                                         *
  58. line 1, column 80, nearby [,] has error[-2007]:
  59. Syntax error.
  60. used time: 0.302(ms). Execute id is 0.
  61. SQL> DBMS_STATS.GATHER_SCHEMA_STATS('APP',100,TRUE,'FOR ALL COLUMNS SIZE AUTO');
  62. ^C
  63. DMSQL executed successfully
  64. used time: 00:04:18.123. Execute id is 6207.
  65. SQL> SQL>
  66. SQL>
  67. SQL> DBMS_STATS.GATHER_SCHEMA_STATS('APP',1,TRUE,'FOR ALL COLUMNS SIZE AUTO');
  68. DMSQL executed successfully
  69. used time: 00:01:02.419. Execute id is 6208.
  70. SQL>
收集1%也要1分钟。

怎么也得1分钟
阅读(926) | 评论(0) | 转发(0) |
0

上一篇:表空间脱个机吧

下一篇:达梦temp管理

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