Database Tuning (MOSC)

MOSC Banner

Does 11gR2 version database collect stats differently?

edited Jun 20, 2012 11:33PM in Database Tuning (MOSC) 6 commentsAnswered
In Oracle 10.2.0.3 version database, when I query

SQL> select owner, job_name from dba_scheduler_jobs;

OWNER                          JOB_NAME
------------------------------ ------------------------------
SYS                            PURGE_LOG
SYS                            FGR$AUTOPURGE_JOB
SYS                            GATHER_STATS_JOB
SYS                            AUTO_SPACE_ADVISOR_JOB

I got this. But in 11.2.0.2 database ,when I issue the same query I got

SQL> select owner, job_name from dba_scheduler_jobs;

OWNER                          JOB_NAME
------------------------------ ------------------------------
SYS                            PURGE_LOG
SYS                            FILE_WATCHER
SYS                            ORA$AUTOTASK_CLEAN
SYS                            HM_CREATE_OFFLINE_DICTIONARY
SYS                            DRA_REEVALUATE_OPEN_FAILURES
ORACLE_OCM                     MGMT_CONFIG_JOB
ORACLE_OCM                     MGMT_STATS_CONFIG_JOB
ORACLE_OCM                     MGMT_CONFIG_JOB_1

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