Re: system statistics in 10g
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Jun 2004 23:00:09 +0100
You should have found a CPU time,
and a couple of I/O times (seek and block
transfer) in aux_stats$ that get set at database
startup. 10g will be using the mechanism,
even if there aren't any values for the rest
of them - so it's a good idea either to
disable the feature, or to set some suitable
values.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st
----- Original Message -----
From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, June 17, 2004 6:25 PM
Subject: system statistics in 10g
Hi,
I was reading oracle docs and it mentioned that "system statistics" are
enabled by default but when I query aux_stats$ TABLE they are not there
and only when I ran dbms_stats.gather_system_stats they are inserted
into this table. Do I need to set some parameter to enable these on 10g
or they have same behavior as of 9i?
Thanks
--Harvinder
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
