Name
DBA_SCHEDULER_RUNNING_JOBS
Synopsis
This view shows all jobs currently running in the database.
Column name |
Description |
OWNER |
Owner of the job. |
JOB_NAME |
Name of the job. |
SESSION_ID |
Session ID, as shown in V$SESSION, of this job process. |
SLAVE_PROCESS_ID |
Process ID of the slave process. |
RUNNING_INSTANCE |
Instance number of the database in which this job is running. This parameter is only relevant if this is a clustered database. |
RESOURCE_CONSUMER_GROUP |
Name of the resource consumer group this job is associated with. This governs how much resource—such as CPU, parallel query server, etc.—is assigned to the job. |
ELAPSED_TIME |
Elapsed time since this job run started. Shown in the INTERVAL datatype. |
CPU_USED |
Amount of CPU cycles (in time) consumed by this job. Shown in the INTERVAL datatype. |
Oracle Database 10g Release 2 adds several new columns to the DBA_SCHEDULER_RUNNING_JOBS view .
JOB_SUBNAME |
Sub-name of this current job |
SLAVE_OS_PROCESS_ID |
Operating system process ID of the slave process |
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.