Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
Oracle 11gR1
DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in the database. Its columns are the same as those in ALL_SCHEDULER_JOB_RUN_DETAILS.
·
ALL_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs accessible to the current user.
·
USER_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs owned by the current user.
Column
|
Datatype
|
NULL
|
Description
|
LOG_ID | NUMBER |
Unique identifier of the log entry (foreign key of the
*_SCHEDULER_JOB_LOG views) | |
LOG_DATE | TIMESTAMP(6) WITH TIME ZONE |
Date of the log entry
| |
OWNER | VARCHAR2(30) |
Owner of the Scheduler job
| |
JOB_NAME | VARCHAR2(65) |
Name of the Scheduler job
| |
JOB_SUBNAME | VARCHAR2(65) |
Subname of the Scheduler job (for a chain step job)
| |
STATUS | VARCHAR2(30) |
Status of the job run
| |
ERROR# | NUMBER |
Error number in the case of an error
| |
REQ_START_DATE | TIMESTAMP(6) WITH TIME ZONE |
Requested start date of the job run
| |
ACTUAL_START_DATE | TIMESTAMP(6) WITH TIME ZONE |
Actual date on which the job was run
| |
RUN_DURATION | INTERVAL DAY(3) TO SECOND(0) |
Duration of the job run
| |
INSTANCE_ID | NUMBER |
Identifier of the instance on which the job was run
| |
SESSION_ID | VARCHAR2(30) |
Session identifier of the job run
| |
SLAVE_PID | VARCHAR2(30) |
Process identifier of the slave on which the job was run
| |
CPU_USED | INTERVAL DAY(3) TO SECOND(2) |
Amount of CPU used for the job run
| |
DESTINATION | VARCHAR2(128) |
Destination for a remote job operation
| |
ADDITIONAL_INFO | VARCHAR2(4000) |
Additional information on the job run, if applicable
|
Note:
1.
select log_id, log_date, owner, job_name, status, error#, session_id, cpu_used
from DBA_SCHEDULER_JOB_RUN_DETAILS
order by log_date desc;
LOG_
ID
|
LOG_DATE
|
OWNER
|
JOB_NAME
|
STATUS
|
ERROR#
|
SESSION_ID
|
CPU_USED
|
21841
|
2008-08-27 3:00:01.537390 AM -07:00
|
SYS
|
PURGE_LOG
|
SUCCEEDED
|
0
|
2583,64846
|
+00 00:00:00.120000
|
21823
|
2008-08-26 11:32:06.500472 PM -07:00
|
SYS
|
GATHER_STATS_JOB
|
SUCCEEDED
|
0
|
2237,54039
|
+00 00:18:02.370000
|
21822
|
2008-08-26 10:31:50.250459 PM -07:00
|
SYS
|
AUTO_SPACE_ADVISOR_JOB
|
SUCCEEDED
|
0
|
1915,7243
|
+00 00:02:30.060000
|
21781
|
2008-08-26 3:00:01.537036 AM -07:00
|
SYS
|
PURGE_LOG
|
SUCCEEDED
|
0
|
1965,14939
|
+00 00:00:00.190000
|
21763
|
2008-08-25 11:32:35.448400 PM -07:00
|
SYS
|
GATHER_STATS_JOB
|
SUCCEEDED
|
0
|
1716,7061
|
+00 00:21:06.190000
|
21762
|
2008-08-25 10:22:00.425325 PM -07:00
|
SYS
|
AUTO_SPACE_ADVISOR_JOB
|
SUCCEEDED
|
0
|
1550,25877
|
+00 00:01:39.660000
|
21742
|
2008-08-25 3:00:01.297128 AM -07:00
|
SYS
|
PURGE_LOG
|
SUCCEEDED
|
0
|
2491,35936
|
+00 00:00:00.240000
|
