If you are using 8i , you can setup Resource Manager. For more info about this subject see Oracle Administratorīs Guide.
HIH,
Antonio Belloni
"Carle,
William T To: Multiple recipients of list ORACLE-L
(Bill), <[EMAIL PROTECTED]>
ALINF" cc:
<[EMAIL PROTECTED] Subject: RE: limit user CPU usage
om>
Sent by:
root@fatcity.
com
15/01/02
16:30
Please
respond to
ORACLE-L
Hi,
You can set up a profile to set resource limits and have the user use
that profile. This is explained in the Oracle Administrator's Guide.
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, January 15, 2002 12:10 PM
To: Multiple recipients of list ORACLE-L
Hi, Guys,
Is there some parameters or user-profile prometers in Oracle can limit
user CPU usage?
I mean, make specific user or all users use less CPU, I has a SQL query
that use 100% CPU.
I know the SQL is bad, but before developer change it, Is there something I
can do?
Any suggestion will be highly appreciated.
My environment is Oracle8.1.6 on Win2000.
Thanks,
Kevin Wang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
