Re: SQL*Plus: Priority Of SQL-Requests
From: Remco Blaakmeer <remco_at_rd31-144.quicknet.nl>
Date: 8 Mar 1999 23:51:11 GMT
Message-ID: <7c1npf$ek5$2_at_rd31-144.quicknet.nl>
Date: 8 Mar 1999 23:51:11 GMT
Message-ID: <7c1npf$ek5$2_at_rd31-144.quicknet.nl>
In article <36E3DD98.2651B2BB_at_tilak.or.at>,
Oliver HAID <oliver.haid_at_tilak.or.at> writes:
> Hello!
>
>
> Does somebody know if (and how!) it is possible to change the priority
> of SQL-requests using SQL*Plus?
>
> Executing
> nice sqlplus <...>
> is possibly not what I want.
Yes, I think this _is_ what you want. The database process processing the queries is executed as a child of sqlplus, so it has the same 'niceness' as sqlplus.
Remco
-- rd31-144: 12:45am up 3 days, 23:37, 7 users, load average: 1.01, 1.02, 1.06Received on Tue Mar 09 1999 - 00:51:11 CET