Running stored procedure at low priority

From: Johan Nilsson <jni_at_esrange.ssc.se.--->
Date: Thu, 3 Dec 1998 13:32:48 +0100
Message-ID: <366684aa.0@d2o19.telia.com>

Hi,

platform : NT 4.0 SP4, Oracle Workgroup Server 7.3.3.0.0

How can I run a stored procedure or SQL query at a low priority in the database (THREAD_PRIORITY_BELOW_NORMAL for you Win32 programmers), is it even possible?

The reason I'm asking is that I'm running a SQL Plus job at regular intervals (every second hour) that takes some time to complete (updates some statistics) and I would like a quick response from the system during these times also.

T.I.A // Johan

---

If replying by e-mail, please remove the spam protection '.---' from the end of my return address. Received on Thu Dec 03 1998 - 06:32:48 CST