DBMS_JOBS ... static session?

Hello;
Oracle 8.1.7.3.50-Z/OS

We have Jobs awaking every 30 seconds; and creating a session. IS ist possible to have only one session without creating always a new one?
( Perfomance issue )

Orca

The simple answer is no. Each job will always spawn a new session. If you absolutely must work in the same session you can simulate this using some code. Basically what you need to do is use a queue:

http://www.oracle-base.com/Articles/...dQueuing9i.asp

If your job puts a request onto a queue it can be read from a single session by some code that does something like:

LOOP
-- 1) Read from queue with unlimited timeout. This means it will wait forever for a message to appear on the queue.
-- 2) Do some processing based on contents of the message on the queue.
END LOOP;

It's not ideal but it would solve your problem.

Cheers

Hello;
This seems to be a very good idea!
Thank you!

Orca

Quote:

---

Originally posted by Orca777
Hello;
This seems to be a very good idea!
Thank you!

Orca

---

I haven't see a bad idea from Tim! :-) You can find top quality articles at http://www.oracle-base.com/Articles/9i/Articles9i.asp

ok julian : the 'seems' was not against tim, it was against to check if it is possible in the concrete environment/Design.
But ...
only THE ONE never failes ... ;-))

Orca