| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Adhoc queries and limiting the amount of records queried...
Aside from severely restricting access to analysts who need to investigate
problems in production data we limit the CPU time in their profile to 5
minutes. That's a pretty generous limit and they've never had any issues
with it.
-----Original Message-----
Sent: Tuesday, October 29, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
I just wanted to ping the list to see what other people have done to control or constrain adhoc query users???
We have a group that is struggling with the adhoc query piece that's in production. Some of the users end up firing off insane queries. The group is trying to find a way to limit the amount of records queried for, so that a wild query doesn't hose the database.
Appending a ROWNUM to the WHERE clause is one idea. Using USER PROFILEs is another. Any other thoughts??
Dare I ask...this custom app also runs on SQL Server, so SQL Server ideas would also be appreciated.
Many thanks!!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 29 2002 - 15:18:56 CST
 |
 |