Kevin,
You can also use Resource manager to limit the CPU usage on certain user
groups .
It's pretty cool.
HTH
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 1:42 PM
> Thanks, Ron, I will try it.
>
> Kevin Wang
>
>
cc:
<[EMAIL PROTECTED] Subject: RE: limit user CPU usage
om>
Thanks, Ron, I will try it.
Kevin Wang
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 11:55 AM
Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will lim
Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will limit the amount of
time in hundredths of a second to the user assigned to the profile. I
woul experiment with the values before I assigned it to a user. The
manual does not say it
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-
From: kevin wang
[mailto:[EM