Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Governor?
A copy of this was sent to Jeff De Luca <jeff_at_cls.uob.com.sg>
(if that email address didn't require changing)
On Wed, 03 Feb 1999 19:35:20 +0800, you wrote:
>Does Oracle 8 or 8i have a query governor funciton? i.e. don't allow a
>query to run that exceeds n rows returned, or x cpu seconds, or etc.?
>
>If it does, do you get a partial result or some kind of error message?
>
>Thanks,
>
>jdl
Oracle 7 and 8 have profiles (create profile...) which can be used to limit CPU time per call/session, logical reads per call/session, physical reads per call/session, connect times, and some other things.
You would get an error message.
Oracle8i will add to this a resource manager which allows you to prioritize users by application (eg: this app gets 80% of the machine, this one gets 10% and this other one 10%).
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Feb 03 1999 - 11:07:13 CST