You may want to consider determining *why* that process
is taking so much CPU, and fix the problem.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 4/20/05, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
> 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.
>
> 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 <http://8.1.7.4>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2005 - 19:57:45 CDT
