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)
|