Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DMBS_JOB keeps cursors open?

DMBS_JOB keeps cursors open?

From: Bill Buchan <bbuchan_at_ossian.net>
Date: Wed, 21 Apr 1999 13:24:21 +0100
Message-ID: <7fkfqa$bve$1@phys-ma.sol.co.uk>


Just a quick sanity check please!

I have submitted a job using the DBMS_JOB package (for the first time ever!). This appears to have opened about 10 or so cursors which do not close in the interval between the jobs running.

SQL_TEXT



SELECT NAME FROM SYS.USER$ WHERE USER# = UID select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oi SELECT NAME FROM SYS.USER$ WHERE USER# = :b1 select sql_text from V$open_cursor
DELETE FROM JOB$ WHERE JOB = :b1
SELECT JOBSEQ.NEXTVAL FROM DUAL
UPDATE SYS.SNAP$ SET AUTO_FUN='null' WHERE ( SOWNER,VNAME ) INSERT INTO SYS.JOB$ ( JOB,LOWNER,POWNER,COWNER,NEXT_DATE,IN UPDATE SYS.SNAP$ SET AUTO_FUN=:b1,AUTO_DATE=:b2 WHERE ( SOWN INSERT INTO MONITOR_SGA SELECT SYSDATE,BYTES FROM SYS.V_$S <-- This is the job itself
SELECT 1 FROM SYS.JOB$ WHERE JOB = :b1 AND POWNER = :b2

Is this behaviour correct? (Oracle 8.0.4/NT4sp4)

Many thanks,

Received on Wed Apr 21 1999 - 07:24:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US