| 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: Urgent Oracle CPU issue
Take a look at resource manager. If this particular process logons onto
the database via a peculiar Oracle account it will help. Setting the
resource limits would could cause the process to fail depending on what
they did for error handling.=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
Sent: Wednesday, April 20, 2005 5:06 PM
To: oracle-l_at_freelists.org
Subject: Urgent Oracle CPU issue
I am having a databasse been using very much of CPU where during peak
time, a single process used to call several time and so taking almost
all CPU and stop the site.Is there way I can control that one session
cannot use excessive CPU.
=20
If I use CPU_PER_SESSIOn , then if I say that 30 sec per session, then
what happen after 30 second, is the session hanged on closed . I am at
8.1.7.4
=20
If I use Resource limit, can any have any example that can help. The
load is high between 10-12 EST
=20
Thanks for everybody time=20
Sanjay
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2005 - 17:33:40 CDT
 |
 |