Re: CPU process utilization problem

From: Karsten Farrell <kfarrell_at_medimpact.com>
Date: Fri, 25 Oct 2002 16:41:26 GMT
Message-ID: <Wueu9.146$6z.14288199@newssvr13.news.prodigy.com>

Billy Verreynne wrote:
> DominiqS wrote:
>
>

>>1. I am trying to investigate a problem  where cpu  process utilization is
>>95% on one of out servers running Oracle at about 2.00am in the morning  .
>>How do I troubleshoot Where do I start ?, how do I solve this problem,
>>what are the things to look for ?.

>
>
> Run top to get the PID of the process(es) causing the heavy CPU load.
>

And if you're on Solaris, you might not have the 'top' utility. I found this to be roughly equivalent (not as easy to type as 'top' however):

prstat -n 20 -s cpu -u root,oracle 1 1

> If these are Oracle processes, use the Unix PID and look for the
> corresponding process entries in Oracle's V$PROCESS table (where spid =
> Unix pid).
>
> You can then join with V$SESSION and access all the statistical and event
> data for these process (see V$SESSION_EVENT, V$SESSTAT, V$SESSION_WAIT
> etc). This will tell you exactly what the process are doing (down to which
> physical block from what segment in which datafile and tablespace are
> read).
>
>

>>2.What are the main tuning tips and tricks to know as a DBA, (I know a few
>>but not much), what are the main tuning website to have in your favourites
>>as a DBA.

>
>
> Main tuning tip? Reading the Oracle Performance and Tuning Manual wins that
> one hands down.
>
> --
> Billy
Received on Fri Oct 25 2002 - 11:41:26 CDT