 |
|
Oracle Tips by Burleson |
Chapter 5 -
Monitoring Oracle Job Execution
Monitoring Jobs Prior to
10g
PROCEDURE start_log;
PROCEDURE end_log;
PROCEDURE error_log;
FUNCTION get_job
RETURN job_run_details.job%TYPE;
FUNCTION get_cpu_used
RETURN job_run_details.cpu_used%TYPE;
END job_run_details_api;
/
SHOW ERRORS
CREATE OR REPLACE PACKAGE BODY
job_run_details_api AS
g_log_id job_run_details.log_id%TYPE;
--
-----------------------------------------------------------------
PROCEDURE start_log AS
--
-----------------------------------------------------------------
|
|
|
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. |
|
|
