Re: dictionary access via CBO without statistics

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 17 Apr 2003 14:11:30 +0200
Message-ID: <b7m5io$5b6$1@news.mch.sbs.de>

"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message news:b7lk8h$9s$1_at_news.mch.sbs.de...
> Hi,
> I got 2 databases (8.1.7.4, solaris) on which accesses to dictionary
objects
> (e.g. dba_extents) are made using cbo. I checked that no statistics are on
> any sys' tables and indexes using:
> select * from dba_tables where owner='SYS' and last_analyzed is not
null
> select * from dba_indexes where owner='SYS' and last_analyzed is not
> null
>
> The execution plan shows costs and if a /*+ rule */ hint is used, the
> queries a much faster.
>
> optimizer_mode is choose.
>
> Some more hints / bugs?

Just found the problem. It's generic 8i, very bad on my databases with >100 LMTs (oracle applications).
See metalink note 102277.1

Stephan Received on Thu Apr 17 2003 - 07:11:30 CDT