I do not know if my job,DBMS_STATS.GATHER_DATABASE_STATS, is working
I would like understand Statistics of oracle. I have 2 questions 1 about the job and 2 about the type of job.
1**********
- I would like know if my job of statistics work : I see the column STATE is "scheduled" and The column NEXT_RUN_DATE is NULL.
I would like understand when my job shall start.
select owner, JOB_NAME, state,LAST_START_DATE, NEXT_RUN_DATE from dba_scheduler_jobs where job_name = 'GATHER_STATS_JOB';
OWNER JOB_NAME STATE
------------------------------ ------------------------------ ---------------
LAST_START_DATE
---------------------------------------------------------------------------
NEXT_RUN_DATE
---------------------------------------------------------------------------
SYS GATHER_STATS_JOB SCHEDULED
09-MAR-11 10.00.01.771388 PM +01:00
*****************************************
-2**********
- I would like know if type of statistics is correct : I show the paremeters of my job.