论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-04-23 16:17 |只看该作者 |倒序浏览

这两天看statspack的时间，遇到两个小问题，不是很理解，请前辈解答一下，先谢谢了！

Changing the interval of statistics collection
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  To change the interval of statistics collection use the dbms_job.interval
  procedure
  e.g.
execute dbms_job.interval(1,'SYSDATE+(1/4

');

Where 'SYSDATE+(1/4

' will result in the statistics being gathered each
1/48th of a day (i.e. every 30 minutes).

To force the job to run immediately,
execute dbms_job.run(<job number>

;

(1)在看spdoc.txt的时候看到这段代码时，对于执行任务的的job number怎么获取，这是我执行 execute dbms_job.interval(1,'SYSDATE+(1/4

')时遇到的提示信息

execute dbms_job.interval(1,'SYSDATE+(1/4

');
BEGIN dbms_job.interval(1,'SYSDATE+(1/4

'); END;

*
ERROR at line 1:
ORA-23421: job number 1 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 687
ORA-06512: at "SYS.DBMS_JOB", line 237
ORA-06512: at line 1

(2)对于执行 @?/rdbms/admin/spreport脚本后，生成的脚本放在什么地方？
(3)想请教一下spreport与sprepins两个脚本分别代表什么意思？
(4)在执行SQL报告一单时提到一个hash的概念，但是我看完后不是很明白这个hash值的来源，以及怎样获取，请各位前辈解答，谢谢！