Thanks Everbody for several suggestion. Actually this
is suddently started and I found the process but it is
not controllable as the process is invoked several
time during the peak time and it is also doing lot of
Intermedia index sync etc. This is the reason I am
thinking to limit the resource and this hapen only for
an hour or two. I will surely try the event and will
look into the Resource manager.
Thanks
--- Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
wrote:
> 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
>
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 - 22:09:46 CDT
