DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.SCHEDULER$_CLASS

Object Details
Object Name: SCHEDULER$_CLASS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_CLASS_PK
  1. ColumnOBJ#
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_CLASS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
RES_GRP_NAME VARCHAR2 (128)
DEFAULT_PRIORITY NUMBER

AFFINITY VARCHAR2 (64)
LOG_HISTORY NUMBER

FLAGS NUMBER

COMMENTS VARCHAR2 (240)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJ#
,      RES_GRP_NAME
,      DEFAULT_PRIORITY
,      AFFINITY
,      LOG_HISTORY
,      FLAGS
,      COMMENTS
FROM SYS.SCHEDULER$_CLASS;

Dependencies

[top of page]

SYS.SCHEDULER$_CLASS does not reference any database object

SYS.SCHEDULER$_CLASS is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_JOB_CLASSES
ViewDBA_SCHEDULER_JOB_CLASSES
Package BodyDBMS_ISCHED - show dependent code
Package BodyDBMS_SCHED_MAIN_EXPORT - show dependent code