Re: DMBS_JOB keeps cursors open?

Bill Buchan wrote in message <7fkfqa$bve$1_at_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.
>

Ah, just spotted that I need to set close_cached_open_cursors = true in init.ora if I want to close these cursors during intervals.

• Bill.