Re: Important: Oracle processes taking lots of CPU

From: New DBA <new_dba_on_the_block_at_yahoo.com>
Date: Wed, 24 Nov 2004 06:33:11 -0800 (PST)
Message-ID: <20041124143311.7921.qmail@web53307.mail.yahoo.com>

Hi Zoran,

> Oracle is not accounting everything in CPU used by
> this session.
> There are some other OS CPU time waits you can
> observe
> from the v$sysstat and v$sesstat, but only if you
> have
> set timed_os_statistics like:
> OS User level CPU time
> OS System call CPU time
> OS Other system trap CPU time
>
> For example OS User level CPU time is always greater
> (or it should be) then CPU used by this session.
> Also be aware of CPU used when call started if you
> have some crap Oracle version.
>

We aren't gathering OS statistics as of now. Are there any drawbacks of using the same?

In case I start gathering OS stats, how do I relate the OS System Call CPU time to a particular session?

Does this value get added to the CPU values in 10046 trace files? If not, then I won't gather much information about the process by gathering OS stats.

Regards
New DBA                 

---

Do you Yahoo!?
The all-new My Yahoo! - What will yours do? http://my.yahoo.com

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

Received on Wed Nov 24 2004 - 08:29:06 CST