Re: Re: optimizer_index_cost_adj and optimizer_index_caching

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 10 Mar 2004 11:27:52 -0700
Message-Id: <6.0.3.0.2.20040310112704.02b8a390@pop.centrexcc.com>

dbms_stats.gather_system_stats does not exist prior to Oracle 9i, therefore it does not apply to 8i.

At 07:52 AM 3/10/2004, you wrote:
>Does this discussion in terms of taking system stats only apply to 9i?
>I see that in 8i IO stats are collected and in 9i CPU stats were added.
>All the info I have seen though infers this is new functionality for 9i
>and does'nt go into any detail on 8i.
>Has anyone had any success with taking system stats in 8i?
>
>Thanks
>--
>- David
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

---

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 Wed Mar 10 2004 - 13:38:40 CST