Re: Set Priority for a session

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/02
Message-ID: <954707613.13611.1.pluto.d4ee154e@news.demon.nl>#1/1

You can't from Oracle and also they advise you NOT to change priorities. You'd rather tune you procedure before you resort to such drastic measures. Once the procedure is optimal, it is still the last option to try. As you don't provide any details on your procedure, regrettably I can't help you further.

Hth,

Sybrand Bakker, Oracle DBA

Michael Kakuschky <kuschky_at_nikocity.de> wrote in message news:8c5ami$k0l$1_at_news.nikoma.de...
> Hello,
>
> knows anybody a way to assign a process or session more CPU - time.
Because
> we starting a PL/SQL procedure from sqlplus . It works but it use only a
> littlebit of CPU Time and Disk activity and so its very slowly.
>
> Michael
>
>
Received on Sun Apr 02 2000 - 00:00:00 CST