Nope, checked that: SQL> show parameter statistics NAME TYPE VALUE ------------------------------------ ----------- = ------------------------------ statistics_level string TYPICAL timed_os_statistics integer 0 timed_statistics boolean TRUE Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Post Hoc Ergo Propter Hoc" -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der Sent: Monday, July 26, 2004 5:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Moving to 9i..... > For some reason, Oracle is doing LOTS more system calls. I tried > trussing a couple of the hot server processses, I see lots and lots of > poll(), pread() and times() sys calls. Inside the db, this translates > to lots and lots of latch free on cache buffers chains and library > cache. But, I suspect that it's secondary due to the CPU staravtion > caused by the heavy syscall activity. Do you have timed_os_statistics enabled? (if statistics_level =3D all = then timed_os_statistics defaults to true...) Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------