Oracle-L: Re: Statistics on SYS?

From: <babu.nagarajan_at_Cummins.com>
Date: Fri, 28 Feb 2003 10:51:20 -0800
Message-ID: <F001.0055D37C.20030228105120@fatcity.com>

I think you are not supposed to collect statistics on sys tables till 9i...

Babu

                                                                                                                                                    
                      Chuck Hamilton                                                                                                                
                      <chuckh_at_softhome.        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      net>                     cc:                                                                                                  
                      Sent by:                 Subject:  Statistics on SYS?                                                                         
                      root_at_fatcity.com                                                                                                              
                                                                                                                                                    
                                                                                                                                                    
                      02/28/03 12:09 PM                                                                                                             
                      Please respond to                                                                                                             
                      ORACLE-L

What's the current recommendation for gathering statistics on system schema objects like SYS, and OUTLN? Are they still saying not to do it? I am on 8.1.7.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
  INET: chuckh_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).




_____________
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: babu.nagarajan_at_Cummins.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Feb 28 2003 - 12:51:20 CST