Oracle-L: RE: Desupport of RBO

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 07 Oct 2003 11:14:28 -0800
Message-ID: <F001.005D24A4.20031007111428@fatcity.com>

in 10g, you can analyze sys (9i too, but don't know if anyone actually does it) as well as fixed tables ... though frequent fixed table analysis is not recommended.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Tuesday, October 07, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L

We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly. During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G.

Hopefully... 10G still has a data dictionary I imagine.

: )

Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Tue Oct 07 2003 - 14:14:28 CDT