Re: Urgent Oracle CPU issue

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Thu, 21 Apr 2005 00:53:35 +0100

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@xxxxxxxxx> 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>
> 
> 
>

--
//www.freelists.org/webpage/oracle-l

Other related posts: