Re: CPU process utilization problem

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.

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