Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO for sys/system objects

Re: CBO for sys/system objects

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 05 Apr 2006 19:09:54 +0200
Message-ID: <jeu732lfd2u9mne489dmgeim0bdmson6ra@4ax.com>


On 5 Apr 2006 09:06:48 -0700, wagen123_at_yahoo.com wrote:

>Oracle9i 9207 (64 bit)
>Solaris 9 (64 bit)
>
>We generate statistics for the user schemas via dbms_stats. Works fine
>although we had to tune a few queries with the RULE hint since it was
>faster.
>
>Questions:
>1) should we generate statistics for the sys/system objects? Is it
>recommended in 9i? we use the default stats gathering in 10g which
>includes the sys/system objects (out of the box)
>2) any known issues in 9i?
>
>Thanks for any pointers.
>wagen

Not supported in 9i.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Apr 05 2006 - 12:09:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US