Database Tuning (MOSC)

MOSC Banner

I do not know if my job,DBMS_STATS.GATHER_DATABASE_STATS, is working

edited Mar 14, 2011 4:30AM in Database Tuning (MOSC) 9 commentsAnswered
hello,

      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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center