iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

 

DBA_REPRESOL_STATS_CONTROL: Information about statistics collection for conflict resolutions for all replicated tables in the database

 

iSelfSchooling-SQL> desc DBA_REPRESOL_STATS_CONTROL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CREATED                       NOT NULL DATE

 STATUS                                 VARCHAR2(9)

 STATUS_UPDATE_DATE            NOT NULL DATE

 PURGED_DATE                            DATE

 LAST_PURGE_START_DATE                  DATE

 LAST_PURGE_END_DATE                    DATE

 

DBA_REPSCHEMA: N-way replication information

 

iSelfSchooling-SQL> desc DBA_REPSCHEMA;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAME                         NOT NULL VARCHAR2(30)

 DBLINK                        NOT NULL VARCHAR2(128)

 MASTERDEF                              VARCHAR2(1)

 SNAPMASTER                             VARCHAR2(1)

 MASTER_COMMENT                         VARCHAR2(80)

 MASTER                                 VARCHAR2(1)

 PROP_UPDATES                           NUMBER

 MY_DBLINK                              VARCHAR2(1)

 GNAME                         NOT NULL VARCHAR2(30)

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 

DBA_REPSITES: N-way replication information

 

iSelfSchooling-SQL> desc DBA_REPSITES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 GNAME                         NOT NULL VARCHAR2(30)

 DBLINK                        NOT NULL VARCHAR2(128)

 MASTERDEF                              VARCHAR2(1)

 SNAPMASTER                             VARCHAR2(1)

 MASTER_COMMENT                         VARCHAR2(80)

 MASTER                                 VARCHAR2(1)

 PROP_UPDATES                           NUMBER

 MY_DBLINK                              VARCHAR2(1)

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 

DBA_REPSITES_NEW: Information about new masters for replication extension

 

iSelfSchooling-SQL> desc DBA_REPSITES_NEW;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 EXTENSION_ID                  NOT NULL RAW(16)

 GOWNER                        NOT NULL VARCHAR2(30)

 GNAME                         NOT NULL VARCHAR2(30)

 DBLINK                        NOT NULL VARCHAR2(128)

 FULL_INSTANTIATION                     VARCHAR2(1)

 MASTER_STATUS                          VARCHAR2(13)

 

DBA_RESOURCE_INCARNATIONS: Resource incarnations that are running or eligible for HA status notification

 

iSelfSchooling-SQL> desc DBA_RESOURCE_INCARNATIONS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RESOURCE_TYPE                 NOT NULL VARCHAR2(30)

 RESOURCE_NAME                          VARCHAR2(256)

 DB_UNIQUE_NAME                NOT NULL VARCHAR2(30)

 DB_DOMAIN                     NOT NULL VARCHAR2(128)

 INSTANCE_NAME                 NOT NULL VARCHAR2(30)

 HOST_NAME                              VARCHAR2(512)

 STARTUP_TIME                           TIMESTAMP(9)

 

DBA_RESUMABLE: Resumable session information in the system

 

iSelfSchooling-SQL> desc DBA_RESUMABLE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 USER_ID                                NUMBER

 SESSION_ID                             NUMBER

 INSTANCE_ID                            NUMBER

 COORD_INSTANCE_ID                      NUMBER

 COORD_SESSION_ID                       NUMBER

 STATUS                                 VARCHAR2(9)

 TIMEOUT                                NUMBER

 START_TIME                             VARCHAR2(20)

 SUSPEND_TIME                           VARCHAR2(20)

 RESUME_TIME                            VARCHAR2(20)

 NAME                                   VARCHAR2(4000)

 SQL_TEXT                               VARCHAR2(1000)

 ERROR_NUMBER                           NUMBER

 ERROR_PARAMETER1                       VARCHAR2(80)

 ERROR_PARAMETER2                       VARCHAR2(80)

 ERROR_PARAMETER3                       VARCHAR2(80)

 ERROR_PARAMETER4                       VARCHAR2(80)

 ERROR_PARAMETER5                       VARCHAR2(80)

 ERROR_MSG                              VARCHAR2(4000)

 

DBA_REWRITE_EQUIVALENCES: Description of rewrite equivalence accessible to DBA

 

iSelfSchooling-SQL> desc DBA_REWRITE_EQUIVALENCES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 SOURCE_STMT                            CLOB

 DESTINATION_STMT                       CLOB

 REWRITE_MODE                           VARCHAR2(10)

 

DBA_RGROUP: All refresh groups.  This view is not a join.

 

iSelfSchooling-SQL> desc DBA_RGROUP;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 REFGROUP                               NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 IMPLICIT_DESTROY                       VARCHAR2(1)

 PUSH_DEFERRED_RPC                      VARCHAR2(1)

 REFRESH_AFTER_ERRORS                   VARCHAR2(1)

 ROLLBACK_SEG                           VARCHAR2(30)

 JOB                           NOT NULL NUMBER

 PURGE_OPTION                           NUMBER(38)

 PARALLELISM                            NUMBER(38)

 HEAP_SIZE                              NUMBER(38)

 

DBA_ROLES: All Roles which exist in the database

 

iSelfSchooling-SQL> desc DBA_ROLES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 ROLE                          NOT NULL VARCHAR2(30)

 PASSWORD_REQUIRED                      VARCHAR2(8)

 

DBA_ROLE_PRIVS: Roles granted to users and roles

 

iSelfSchooling-SQL> desc DBA_ROLE_PRIVS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 GRANTEE                                VARCHAR2(30)

 GRANTED_ROLE                  NOT NULL VARCHAR2(30)

 ADMIN_OPTION                           VARCHAR2(3)

 DEFAULT_ROLE                           VARCHAR2(3)

 

DBA_ROLLBACK_SEGS: Description of rollback segments

 

iSelfSchooling-SQL> desc DBA_ROLLBACK_SEGS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SEGMENT_NAME                  NOT NULL VARCHAR2(30)

 OWNER                                  VARCHAR2(6)

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 SEGMENT_ID                    NOT NULL NUMBER

 FILE_ID                       NOT NULL NUMBER

 BLOCK_ID                      NOT NULL NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                   NOT NULL NUMBER

 MAX_EXTENTS                   NOT NULL NUMBER

 PCT_INCREASE                           NUMBER

 STATUS                                 VARCHAR2(16)

 INSTANCE_NUM                           VARCHAR2(40)

 RELATIVE_FNO                  NOT NULL NUMBER

 

DBA_RSRC_CONSUMER_GROUPS: all the resource consumer groups

 

iSelfSchooling-SQL> desc DBA_RSRC_CONSUMER_GROUPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 CONSUMER_GROUP                         VARCHAR2(30)

 CPU_METHOD                             VARCHAR2(30)

 COMMENTS                               VARCHAR2(2000)

 STATUS                                 VARCHAR2(30)

 MANDATORY                              VARCHAR2(3)

 

DBA_RSRC_CONSUMER_GROUP_PRIVS: Switch privileges for consumer groups

 

iSelfSchooling-SQL> desc DBA_RSRC_CONSUMER_GROUP_PRIVS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 GRANTEE                       NOT NULL VARCHAR2(30)

 GRANTED_GROUP                          VARCHAR2(30)

 GRANT_OPTION                           VARCHAR2(3)

 INITIAL_GROUP                          VARCHAR2(3)

 

DBA_RSRC_GROUP_MAPPINGS: all the consumer group mappings

 

iSelfSchooling-SQL> desc DBA_RSRC_GROUP_MAPPINGS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 ATTRIBUTE                              VARCHAR2(30)

 VALUE                                  VARCHAR2(128)

 CONSUMER_GROUP                         VARCHAR2(30)

 STATUS                                 VARCHAR2(30)

 

DBA_RSRC_MANAGER_SYSTEM_PRIVS: system privileges for the resource manager

 

iSelfSchooling-SQL> desc DBA_RSRC_MANAGER_SYSTEM_PRIVS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 GRANTEE                       NOT NULL VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 ADMIN_OPTION                           VARCHAR2(3)

 

DBA_RSRC_MAPPING_PRIORITY: the consumer group mapping attribute priorities

 

iSelfSchooling-SQL> desc DBA_RSRC_MAPPING_PRIORITY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 ATTRIBUTE                              VARCHAR2(30)

 PRIORITY                               NUMBER

 STATUS                                 VARCHAR2(30)

 

DBA_RSRC_PLANS: All the resource plans

 

iSelfSchooling-SQL> desc DBA_RSRC_PLANS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 PLAN                                   VARCHAR2(30)

 NUM_PLAN_DIRECTIVES                    NUMBER

 CPU_METHOD                             VARCHAR2(30)

 ACTIVE_SESS_POOL_MTH                   VARCHAR2(30)

 PARALLEL_DEGREE_LIMIT_MTH              VARCHAR2(30)

 QUEUEING_MTH                           VARCHAR2(30)

 COMMENTS                               VARCHAR2(2000)

 STATUS                                 VARCHAR2(30)

 MANDATORY                              VARCHAR2(3)

 

DBA_RSRC_PLAN_DIRECTIVES: all the resource plan directives

 

iSelfSchooling-SQL> desc DBA_RSRC_PLAN_DIRECTIVES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 PLAN                                   VARCHAR2(30)

 GROUP_OR_SUBPLAN                       VARCHAR2(30)

 TYPE                                   VARCHAR2(14)

 CPU_P1                                 NUMBER

 CPU_P2                                 NUMBER

 CPU_P3                                 NUMBER

 CPU_P4                                 NUMBER

 CPU_P5                                 NUMBER

 CPU_P6                                 NUMBER

 CPU_P7                                 NUMBER

 CPU_P8                                 NUMBER

 ACTIVE_SESS_POOL_P1                    NUMBER

 QUEUEING_P1                            NUMBER

 PARALLEL_DEGREE_LIMIT_P1               NUMBER

 SWITCH_GROUP                           VARCHAR2(30)

 SWITCH_TIME                            NUMBER

 SWITCH_ESTIMATE                        VARCHAR2(5)

 MAX_EST_EXEC_TIME                      NUMBER

 UNDO_POOL                              NUMBER

 MAX_IDLE_TIME                          NUMBER

 MAX_IDLE_BLOCKER_TIME                  NUMBER

 SWITCH_TIME_IN_CALL                    NUMBER

 COMMENTS                               VARCHAR2(2000)

 STATUS                                 VARCHAR2(30)

 MANDATORY                              VARCHAR2(3)

 

DBA_RULES: Rules in the database

 

iSelfSchooling-SQL> desc DBA_RULES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_CONDITION                         CLOB

 RULE_EVALUATION_CONTEXT_OWNER          VARCHAR2(30)

 RULE_EVALUATION_CONTEXT_NAME           VARCHAR2(30)

 RULE_ACTION_CONTEXT                    RE$NV_LIST

 RULE_COMMENT                           VARCHAR2(4000)

 

DBA_RULESETS: Rulesets in the database: maintained for backward compatibility

 

iSelfSchooling-SQL> desc DBA_RULESETS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 RULESET_NAME                  NOT NULL VARCHAR2(30)

 RULESET_STORAGE_TABLE                  VARCHAR2

 BASE_TABLE                             VARCHAR2(61)

 RULESET_COMMENT                        VARCHAR2(4000)

 

DBA_RULE_SETS: Rule sets in the database

 

iSelfSchooling-SQL> desc DBA_RULE_SETS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RULE_SET_OWNER                NOT NULL VARCHAR2(30)

 RULE_SET_NAME                 NOT NULL VARCHAR2(30)

 RULE_SET_EVAL_CONTEXT_OWNER            VARCHAR2(30)

 RULE_SET_EVAL_CONTEXT_NAME             VARCHAR2(30)

 RULE_SET_COMMENT                       VARCHAR2(4000)

 

DBA_RULE_SET_RULES: Rules in all rule sets in the database

 

iSelfSchooling-SQL> desc DBA_RULE_SET_RULES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RULE_SET_OWNER                NOT NULL VARCHAR2(30)

 RULE_SET_NAME                 NOT NULL VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_SET_RULE_ENABLED                  VARCHAR2(8)

 RULE_SET_RULE_EVAL_CTX_OWNER           VARCHAR2(30)

 RULE_SET_RULE_EVAL_CTX_NAME            VARCHAR2(30)

 RULE_SET_RULE_COMMENT                  VARCHAR2(4000)

 

DBA_SCHEDULER_CHAINS: All scheduler chains in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_CHAINS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 NUMBER_OF_RULES                        NUMBER

 NUMBER_OF_STEPS                        NUMBER

 ENABLED                                VARCHAR2(5)

 EVALUATION_INTERVAL                    INTERVAL DAY(3)

 USER_RULE_SET                          VARCHAR2(5)

 COMMENTS                               VARCHAR2(240)

 

DBA_SCHEDULER_CHAIN_RULES: All rules from scheduler chains in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_CHAIN_RULES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 CONDITION                              VARCHAR2(4000)

 ACTION                                 VARCHAR2(4000)

 COMMENTS                               VARCHAR2(4000)

 

DBA_SCHEDULER_CHAIN_STEPS: All steps of scheduler chains in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_CHAIN_STEPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 STEP_NAME                     NOT NULL VARCHAR2(30)

 PROGRAM_OWNER                          VARCHAR2(98)

 PROGRAM_NAME                           VARCHAR2(98)

 EVENT_SCHEDULE_OWNER                   VARCHAR2(98)

 EVENT_SCHEDULE_NAME                    VARCHAR2(98)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 SKIP                                   VARCHAR2(5)

 PAUSE                                  VARCHAR2(5)

 RESTART_ON_RECOVERY                    VARCHAR2(5)

 STEP_TYPE                              VARCHAR2(14)

 TIMEOUT                                INTERVAL DAY(3) TO S

                                        ECOND(0)

 

DBA_SCHEDULER_GLOBAL_ATTRIBUTE: All scheduler global attributes

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_GLOBAL_ATTRIBUTE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 ATTRIBUTE_NAME                NOT NULL VARCHAR2(30)

 VALUE                                  VARCHAR2(128)

 

DBA_SCHEDULER_JOBS: All scheduler jobs in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_JOBS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 JOB_NAME                      NOT NULL VARCHAR2(30)

 JOB_SUBNAME                            VARCHAR2(30)

 JOB_CREATOR                            VARCHAR2(30)

 CLIENT_ID                              VARCHAR2(64)

 GLOBAL_UID                             VARCHAR2(32)

 PROGRAM_OWNER                          VARCHAR2(4000)

 PROGRAM_NAME                           VARCHAR2(4000)

 JOB_TYPE                               VARCHAR2(16)

 JOB_ACTION                             VARCHAR2(4000)

 NUMBER_OF_ARGUMENTS                    NUMBER

 SCHEDULE_OWNER                         VARCHAR2(4000)

 SCHEDULE_NAME                          VARCHAR2(4000)

 SCHEDULE_TYPE                          VARCHAR2(12)

 START_DATE                             TIMESTAMP(6)

 REPEAT_INTERVAL                        VARCHAR2(4000)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 EVENT_RULE                             VARCHAR2(65)

 END_DATE                               TIMESTAMP(6)

 JOB_CLASS                              VARCHAR2(30)

 ENABLED                                VARCHAR2(5)

 AUTO_DROP                              VARCHAR2(5)

 RESTARTABLE                            VARCHAR2(5)

 STATE                                  VARCHAR2(15)

 JOB_PRIORITY                           NUMBER

 RUN_COUNT                              NUMBER

 MAX_RUNS                               NUMBER

 FAILURE_COUNT                          NUMBER

 MAX_FAILURES                           NUMBER

 RETRY_COUNT                            NUMBER

 LAST_START_DATE                        TIMESTAMP(6)

 LAST_RUN_DURATION                      INTERVAL DAY(9)

 NEXT_RUN_DATE                          TIMESTAMP(6)

 SCHEDULE_LIMIT                         INTERVAL DAY(3)

 MAX_RUN_DURATION                       INTERVAL DAY(3)

 LOGGING_LEVEL                          VARCHAR2(4)

 STOP_ON_WINDOW_CLOSE                   VARCHAR2(5)

 INSTANCE_STICKINESS                    VARCHAR2(5)

 RAISE_EVENTS                           VARCHAR2(4000)

 SYSTEM                                 VARCHAR2(5)

 JOB_WEIGHT                             NUMBER

 NLS_ENV                                VARCHAR2(4000)

 SOURCE                                 VARCHAR2(128)

 DESTINATION                            VARCHAR2(128)

 COMMENTS                               VARCHAR2(240)

 FLAGS                                  NUMBER

 

DBA_SCHEDULER_JOB_ARGS: All arguments with set values of all scheduler jobs in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_JOB_ARGS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 JOB_NAME                      NOT NULL VARCHAR2(30)

 ARGUMENT_NAME                          VARCHAR2(30)

 ARGUMENT_POSITION                      NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 VALUE                                  VARCHAR2(4000)

 ANYDATA_VALUE                          ANYDATA

 OUT_ARGUMENT                           VARCHAR2(5)

 

DBA_SCHEDULER_JOB_CLASSES: All scheduler classes in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_JOB_CLASSES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 JOB_CLASS_NAME                NOT NULL VARCHAR2(30)

 RESOURCE_CONSUMER_GROUP                VARCHAR2(30)

 SERVICE                                VARCHAR2(64)

 LOGGING_LEVEL                          VARCHAR2(4)

 LOG_HISTORY                            NUMBER

 COMMENTS                               VARCHAR2(240)

 

DBA_SCHEDULER_JOB_LOG: Logged information for all scheduler jobs

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_JOB_LOG;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 LOG_ID                        NOT NULL NUMBER

 LOG_DATE                               TIMESTAMP(6) WITH TI

                                        ME ZONE

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(65)

 JOB_SUBNAME                            VARCHAR2(65)

 JOB_CLASS                              VARCHAR2(30)

 OPERATION                              VARCHAR2(30)

 STATUS                                 VARCHAR2(30)

 USER_NAME                              VARCHAR2(30)

 CLIENT_ID                              VARCHAR2(64)

 GLOBAL_UID                             VARCHAR2(32)

 ADDITIONAL_INFO                        CLOB

 

DBA_SCHEDULER_JOB_RUN_DETAILS: The details of a job run

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_JOB_RUN_DETAILS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 LOG_ID                                 NUMBER

 LOG_DATE                               TIMESTAMP(6)

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(65)

 JOB_SUBNAME                            VARCHAR2(65)

 STATUS                                 VARCHAR2(30)

 ERROR#                                 NUMBER

 REQ_START_DATE                         TIMESTAMP(6)

 ACTUAL_START_DATE                      TIMESTAMP(6)

 RUN_DURATION                           INTERVAL DAY(3)

 INSTANCE_ID                            NUMBER

 SESSION_ID                             VARCHAR2(30)

 SLAVE_PID                              VARCHAR2(30)

 CPU_USED                               INTERVAL DAY(3)

 ADDITIONAL_INFO                        VARCHAR2(4000)

 

DBA_SCHEDULER_PROGRAMS: All scheduler programs in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_PROGRAMS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 PROGRAM_NAME                  NOT NULL VARCHAR2(30)

 PROGRAM_TYPE                           VARCHAR2(16)

 PROGRAM_ACTION                         VARCHAR2(4000)

 NUMBER_OF_ARGUMENTS                    NUMBER

 ENABLED                                VARCHAR2(5)

 DETACHED                               VARCHAR2(5)

 COMMENTS                               VARCHAR2(240)

 

DBA_SCHEDULER_PROGRAM_ARGS: All arguments of all scheduler programs in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_PROGRAM_ARGS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 PROGRAM_NAME                  NOT NULL VARCHAR2(30)

 ARGUMENT_NAME                          VARCHAR2(30)

 ARGUMENT_POSITION             NOT NULL NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 METADATA_ATTRIBUTE                     VARCHAR2(12)

 DEFAULT_VALUE                          VARCHAR2(4000)

 DEFAULT_ANYDATA_VALUE                  ANYDATA

 OUT_ARGUMENT                           VARCHAR2(5)

 

DBA_SCHEDULER_RUNNING_CHAINS: All steps of all running chains in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_RUNNING_CHAINS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(30)

 JOB_SUBNAME                            VARCHAR2(30)

 CHAIN_OWNER                            VARCHAR2(30)

 CHAIN_NAME                             VARCHAR2(30)

 STEP_NAME                              VARCHAR2(30)

 STATE                                  VARCHAR2(11)

 ERROR_CODE                             NUMBER

 COMPLETED                              VARCHAR2(5)

 START_DATE                             TIMESTAMP(6)

 END_DATE                               TIMESTAMP(6)

 DURATION                               INTERVAL DAY(9)

 SKIP                                   VARCHAR2(5)

 PAUSE                                  VARCHAR2(5)

 RESTART_ON_RECOVERY                    VARCHAR2(5)

 STEP_JOB_SUBNAME                       VARCHAR2(30)

 STEP_JOB_LOG_ID                        NUMBER

 

DBA_SCHEDULER_SCHEDULES: All schedules in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_SCHEDULES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 SCHEDULE_NAME                 NOT NULL VARCHAR2(30)

 SCHEDULE_TYPE                          VARCHAR2(8)

 START_DATE                             TIMESTAMP(6)

 REPEAT_INTERVAL                        VARCHAR2(4000)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 END_DATE                               TIMESTAMP(6)

 COMMENTS                               VARCHAR2(240)

 

DBA_SCHEDULER_WINDOWS: All scheduler windows in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOWS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 WINDOW_NAME                   NOT NULL VARCHAR2(30)

 RESOURCE_PLAN                          VARCHAR2(30)

 SCHEDULE_OWNER                         VARCHAR2(4000)

 SCHEDULE_NAME                          VARCHAR2(4000)

 SCHEDULE_TYPE                          VARCHAR2(8)

 START_DATE                             TIMESTAMP(6)

 REPEAT_INTERVAL                        VARCHAR2(4000)

 END_DATE                               TIMESTAMP(6)

 DURATION                               INTERVAL DAY(3)

 WINDOW_PRIORITY                        VARCHAR2(4)

 NEXT_START_DATE                        TIMESTAMP(6)

 LAST_START_DATE                        TIMESTAMP(6)

 ENABLED                                VARCHAR2(5)

 ACTIVE                                 VARCHAR2(5)

 MANUAL_OPEN_TIME                       TIMESTAMP(6)

 MANUAL_DURATION                        INTERVAL DAY(3)

 COMMENTS                               VARCHAR2(240)

 

DBA_SCHEDULER_WINDOW_DETAILS: The details of a window

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOW_DETAILS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 LOG_ID                                 NUMBER

 LOG_DATE                               TIMESTAMP(6)

 WINDOW_NAME                            VARCHAR2(65)

 REQ_START_DATE                         TIMESTAMP(6)

 ACTUAL_START_DATE                      TIMESTAMP(6)

 WINDOW_DURATION                        INTERVAL DAY(3)

 ACTUAL_DURATION                        INTERVAL DAY(3)

 INSTANCE_ID                            NUMBER

 ADDITIONAL_INFO                        VARCHAR2(4000)

 

DBA_SCHEDULER_WINDOW_GROUPS: All scheduler window groups in the database

 

iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOW_GROUPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 WINDOW_GROUP_NAME             NOT NULL VARCHAR2(30)

 ENABLED                                VARCHAR2(5)

 NUMBER_OF_WINDOWS                      NUMBER

 NEXT_START_DATE                        VARCHAR2(64)

 COMMENTS                               VARCHAR2(240)

 

 

 

Google
 
Web web site