Sanjay,
Can you trace the session using event 10046, for sometime, during the time when the CPU
utilization is high? It may provide clues as to what's going on during that timeframe.
Cheers!
- Kirti
- 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
>
> If I use Resource limit, can any have any example that can help. The load is high
> between 10-12 EST
>
> Thanks for everybody time
> Sanjay
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2005 - 20:46:33 CDT