RE: system statistics in 10g

From: Nelson, Allan <anelson_at_miswaco.com>
Date: Thu, 17 Jun 2004 12:37:25 -0500
Message-ID: <7E0DB3A126BA9146AC30744E2B7E4245974299@midhouhqxch01.net.smith.com>

That reference is not to optimizer statistics but rather to extended sql trace statistics. You can use dbms_job to schedule dbms_stats to fix your issue. Cron is also available if you want to do it outside the database for some reason.

Allan

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Thursday, June 17, 2004 12:25 PM
To: oracle-l_at_freelists.org
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_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

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Jun 17 2004 - 12:35:16 CDT