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