| |
 |
|
Oracle Tips by Burleson |
Chapter 5 -
Monitoring Oracle Job Execution
Monitoring Jobs Prior to
10g
g_log_id,
SYSDATE,
l_owner,
get_job,
'IN PROGRESS',
SYSDATE,
l_instance_id,
l_session_id
);
COMMIT;
END start_log;
--
-----------------------------------------------------------------
--
-----------------------------------------------------------------
PROCEDURE end_log AS
--
-----------------------------------------------------------------
PRAGMA
AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE job_run_details
SET status = 'COMPLETE',
actual_end_date = SYSDATE,
run_duration =
NUMTODSINTERVAL(SYSDATE - actual_start_date,
'DAY'),
cpu_used = get_cpu_used
SEE CODE DEPOT FOR FULL SCRIPT
COMMIT;
END end_log;
--
-----------------------------------------------------------------
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
