| 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: limit user CPU usage
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Hi,
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> 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.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail
Signature" <font
color="#339966" face=Impact><span style='font-family:Impact;color:#339966;
font-style:italic'>
<span
style='font-size:12.0pt;font-family:Impact;color:#339966;font-style:italic'>Bill
Carle
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:navy'>AT&T<font
color=navy face="Century Gothic"><span style='font-family:"Century Gothic";
color:navy;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:navy'>Database
Administrator<span
style='font-family:"Century Gothic";color:navy;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:navy'>816-995-3922<font
color=navy face="Century Gothic"><span style='font-family:"Century Gothic";
color:navy;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:navy'>wcarle_at_att.com<font
color=navy face="Century Gothic"><span style='font-family:"Century Gothic";
color:navy;mso-color-alt:windowtext'>
<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
class=EmailStyle15><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: kevin wang
[mailto:kwang_at_vivonet.com]
Sent: Tuesday, January 15, 2002
12:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: limit user CPU usage
<span
style='font-size:12.0pt'>
<font size=2 color=black
face=Arial>Hi,
Guys,<span style='font-size:
10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>Is
there some parameters or user-profile prometers in Oracle can limit user
CPU usage?<span
style='font-size:10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>I mean,
make specific user or all users use less CPU, I has a SQL query that use 100%
CPU.<span style='font-size:
10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>I know
the SQL is bad, but before developer change it, Is there something I can
do?<span style='font-size:
10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>Any
suggestion will be highly appreciated.<font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>My
environment is Oracle8.1.6 on Win2000.<font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>Thanks,<font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>Kevin
Wang<span style='font-size:
10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>
<font
color=black>
Received on Tue Jan 15 2002 - 13:49:51 CST
 |
 |