To:
statspack:我运行spauto时出现以下错误.
begin
*
ERROR 位于第 1 行:
ORA-23420: 间隔必须以将来的一个时间作评估
ORA-06512: 在"SYS.DBMS_JOB", line 57
ORA-06512: 在"SYS.DBMS_JOB", line 134
ORA-06512: 在line 3
Job number for automated statistics collection for this instance
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Note that this job number is needed when modifying or removing
the job:
JOBNO
----------
Job queue process
~~~~~~~~~~~~~~~~~
Below is the current setting of the job_queue_processes init.ora
parameter - the value for this parameter must be greater
than 0 to use automatic statistics gathering:
NAME_COL_PLUS_SHOW_PARAM TYPE
---------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
------------------------------------------------------------------------------
job_queue_processesinteger
6
Next scheduled run
~~~~~~~~~~~~~~~~~~
The next scheduled run for this job is:
未选定行
请问版主碰到这个问题没,win平台,ora9.2.0.1
From: westlife 2005.10.31 01:17
|