| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving to 9i.....
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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel P=F5der
Sent: Monday, July 26, 2004 5:46 PM
To: oracle-l_at_freelists.org
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jul 26 2004 - 16:50:56 CDT
 |
 |