dictionary access via CBO without statistics

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 17 Apr 2003 09:15:54 +0200
Message-ID: <b7lk8h$9s$1@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?

TIA
Stephan Received on Thu Apr 17 2003 - 02:15:54 CDT