Oracle Replication Tips by Burleson

Monitoring Oracle Jobs

Monitoring jobs is a relatively simple process.  The Oracle database maintains a data dictionary view called dba_jobs that contains the status of all jobs executing in the database.  Here is a description of the dba_jobs view:

SQL> desc dba_jobs
 Name          Null?    Type
 ------------- -------- --------------
 JOB           NOT NULL NUMBER
 LOG_USER      NOT NULL VARCHAR2(30)
 PRIV_USER     NOT NULL VARCHAR2(30)
 SCHEMA_USER   NOT NULL VARCHAR2(30)
 LAST_DATE              DATE
 LAST_SEC               VARCHAR2(8)
 THIS_DATE              DATE
 THIS_SEC               VARCHAR2(8)
 NEXT_DATE     NOT NULL DATE
 NEXT_SEC               VARCHAR2(8)
 TOTAL_TIME             NUMBER
 BROKEN                 VARCHAR2(1)
 INTERVAL      NOT NULL VARCHAR2(200)
 FAILURES               NUMBER
 WHAT                   VARCHAR2(4000)
 NLS_ENV                VARCHAR2(4000)
 MISC_ENV               RAW(32)
 INSTANCE               NUMBER

Note that only the user that created the job can change it, unless he is a SYSDBA level administrator, in which case he can use the dbms_job package.  This means that if different groups of replicated tables were created with separate users, then the monitoring schema will need SYSDBA privileges and you will want to use dbms_job

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Get a Personal Oracle Replication Mentor

The author is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle replication question. 

You can get me personally, or any Oracle Certified replication DBA with more than 20 years of full-time IT experience.