Scribd Logo
Upload

Welcome to Scribd!

  • 203 views

    Dbms Scheduler

    Uploaded by

    elcaso34
    The document lists jobs in the Oracle scheduler. It shows the owner, job name, status, and comments for each job. Many of the jobs are for regular database maintenance tasks like purging logs, managing statistics, cleaning up files and objects, and monitoring disk space. It also lists some Oracle Configuration Manager jobs for collecting configuration and statistics.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Dbms Scheduler

    Uploaded by

    elcaso34
    203 views2 pages
    The document lists jobs in the Oracle scheduler. It shows the owner, job name, status, and comments for each job. Many of the jobs are for regular database maintenance tasks like purging logs, managing statistics, cleaning up files and objects, and monitoring disk space. It also lists some Oracle Configuration Manager jobs for collecting configuration and statistics.

    Original Title

    dbms_scheduler

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists jobs in the Oracle scheduler. It shows the owner, job name, status, and comments for each job. Many of the jobs are for regular database maintenance tasks like purging logs, managing statistics, cleaning up files and objects, and monitoring disk space. It also lists some Oracle Configuration Manager jobs for collecting configuration and statistics.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    203 views2 pages

    Dbms Scheduler

    Uploaded by

    elcaso34
    The document lists jobs in the Oracle scheduler. It shows the owner, job name, status, and comments for each job. Many of the jobs are for regular database maintenance tasks like purging logs, managing statistics, cleaning up files and objects, and monitoring disk space. It also lists some Oracle Configuration Manager jobs for collecting configuration and statistics.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    dbms_scheduler

    Trabajo de Mantenimientos

    dbms_jobs --- Desarroladores

    Grid solo hay llamadas a scritps

    set pages 99
    set lines 150

    col owner FOR a10


    col JOB_NAME for A40
    col comments FOR a90

    SELECT OWNER,
    JOB_NAME,
    ENABLED,
    COMMENTS
    FROM DBA_SCHEDULER_JOBS
    /

    OWNER JOB_NAME ENABL COMMENTS


    ---------- ---------------------------------------- -----
    -----------------------------------------------------------------------------------
    -------
    SYS PURGE_LOG TRUE purge log job
    SYS ORA$AUTOTASK_CLEAN TRUE Delete obsolete AUTOTASK
    repository data
    SYS HM_CREATE_OFFLINE_DICTIONARY FALSE Create offline dictionary
    in ADR for DRA name translation
    SYS DRA_REEVALUATE_OPEN_FAILURES TRUE Reevaluate open failures
    for DRA
    SYS ORA$PREPLUGIN_BACKUP_JOB FALSE
    SYS BSLN_MAINTAIN_STATS_JOB TRUE Oracle defined automatic
    moving window baseline statistics computation job
    SYS FGR$AUTOPURGE_JOB FALSE file group auto-purge job
    SYS RSE$CLEAN_RECOVERABLE_SCRIPT TRUE auto clean job for
    recoverable script
    SYS SM$CLEAN_AUTO_SPLIT_MERGE TRUE auto clean job for auto
    split merge
    SYS LOAD_OPATCH_INVENTORY FALSE Load opatch inventory on
    request
    SYS FILE_WATCHER FALSE File watcher job
    SYS PMO_DEFERRED_GIDX_MAINT_JOB TRUE Oracle defined automatic
    index cleanup for partition maintenance operations with deferred global index
    maintenance
    SYS CLEANUP_NON_EXIST_OBJ TRUE Cleanup Non Existent
    Objects in obj$
    SYS CLEANUP_ONLINE_IND_BUILD TRUE Cleanup Online Index
    Build
    SYS CLEANUP_TAB_IOT_PMO TRUE Cleanup Tables after IOT
    PMO
    SYS CLEANUP_TRANSIENT_TYPE TRUE Cleanup Transient Types
    SYS CLEANUP_TRANSIENT_PKG TRUE Cleanup Transient
    Packages
    SYS CLEANUP_ONLINE_PMO TRUE Cleanup after Failed PMO
    SYS FILE_SIZE_UPD TRUE Update file size
    periodically
    SYS XMLDB_NFS_CLEANUP_JOB FALSE
    ORACLE_OCM MGMT_CONFIG_JOB TRUE Configuration collection
    job.
    ORACLE_OCM MGMT_STATS_CONFIG_JOB TRUE OCM Statistics collection
    job.

    22 rows selected.

    SQL> select client_name, status from dba_autotask_client;

    CLIENT_NAME STATUS
    ---------------------------------------------------------------- --------
    auto optimizer stats collection ENABLED
    auto space advisor ENABLED
    sql tuning advisor ENABLED

    You might also like