RE: 9.2 V$ views

I see this uses V$LOCK. Could that have been problem itself?

CREATE OR REPLACE FORCE VIEW SYS.DBA_JOBS_RUNNING (SID, JOB, FAILURES, LAST_DATE, LAST_SEC,  THIS_DATE, 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,     j.field1 INSTANCE
  FROM sys.JOB$ j, v$lock v
  WHERE v.TYPE = 'JQ' AND j.job (+)= v.id2;

	Thanks
	Larry

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bricklen Anderson Sent: Monday, July 26, 2004 4:56 PM
To: oracle-l_at_freelists.org
Subject: Re: 9.2 V$ views

Wolfson Larry - lwolfs wrote:
> Brick,
> OK, replace with????? Just RULE hint?
>

yup

-- 
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login

_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than the
intended recipient is unauthorized. If you have received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------