Re: Important: Oracle processes taking lots of CPU
- From: New DBA <new_dba_on_the_block@xxxxxxxxx>
- To: zoran_martic@xxxxxxxxx
- Date: Wed, 24 Nov 2004 06:33:11 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
