I also just learned today of a "fix" for the view: dba_jobs_running. In
Oracle8 and Oracle8i, that view worked well (and quickly). In Oracle9
and Oracle10, it is *VERY* slow! The problem is the outer_join to
v$lock in the definition of this view. I ran this statement (as SYS) to
"fix" the performance problem in this view, and to give me the name of
the job that is running at the same time. (We have a single-instance
configuration, so the "instance" column added no value for me.)

create or replace view dba_jobs_running
(SID, JOB, FAILURES,
LAST_DATE, LAST_SEC, THIS_DATE,
THIS_SEC, WHAT)
-- THIS_SEC, INSTANCE)
as select v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
substr(j.what,1,40)
-- j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = 'JQ' and j.job = v.id2;
--where v.type = 'JQ' and j.job (+)= v.id2;

Note: the lines commented out contain the default view definition (at
least in Oracle10.1).


-----Original Message-----
From: JEFFERY
[mailto:oracledba-ezmlmshield-x62637575.[Email address protected]
Sent: Wednesday, October 04, 2006 4:11 PM
To: LazyDBA Discussion
Subject: Spam: RE: ORACLE JUBS STILL BROKEN

Check dba_jobs_running to see if it was already running when you
executed the command.

If you are on Oracle 8.1.7, also check the number of "FAILURES" in
dba_jobs, if this is '16' you might has to bounce the database.

I've had similar issues with replication 'jobs' where if "FAILURES" = 16
I was toast because of some BUG.

Good luck

Jeff

-----Original Message-----
From: oracledba-return-133106-JEFFERY.L.SCHRENK=saic.[Email address
protected]
[mailto:oracledba-return-133106-JEFFERY.L.SCHRENK=saic.[Email address
protected]
On Behalf Of Qi cheng
Sent: Wednesday, October 04, 2006 11:59 AM
To: LazyDBA Discussion
Subject: ORACLE JUBS STILL BROKEN

after issue: EXECUTE dbms_job.broken(61,FALSE);

the job seems still broken.

Any ideas?

Thanks.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page