Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Query Governor?
The closest thing to a governor is the use of a profile. You can set up
a profile that restricts cpu, i/o, memory usage, etc. Once the
threshold you've set is exceeded, the user receives an error message and
can do no further work in that session.
> -----Original Message-----
> From: Jeff De Luca [SMTP:jeff_at_cls.uob.com.sg]
> Posted At: Wednesday, February 03, 1999 6:35 AM
> Posted To: comp.databases.oracle.server
> Conversation: Query Governor?
> Subject: Query Governor?
>
> 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
Received on Wed Feb 03 1999 - 08:42:01 CST