selects on EXT#, LENGTH from SYS.UET$ still slow even in 10g isn't it ?

From: Sébastien de Mapias <sglrigaud_at_gmail.com>
Date: 11 Apr 2007 01:23:47 -0700
Message-ID: <1176279827.583499.76830@n59g2000hsh.googlegroups.com>

Hi,
I've read this Metalink note 273468.1 stating that queries on BYTES, BLOCKS or EXTENTS columns of DBA_SEGMENTS or DBA_EXTENTS are very slow on versions 8.1.7.0 to 9.2.0.4.

But obviously in 64-bit 10.2.0.2 on Sun/Solaris it's the same: SQL> select bytes
  2 from dba_extents i
  3 where i.owner='QSDF'
  4 and i.segment_name='MLKQJSDF'
  5* and i.extent_id=0
SQL> / BYTES

---

131072

Elapsed: 00:01:21.03

SQL> select distinct segment_type
  2 from dba_extents i
  3 where i.owner='QSDF'
  4* and i.segment_name='MLKQJSDF'
SQL> / SEGMENT_TYPE

---

INDEX Elapsed: 00:00:01.04

(more than one minute to give me the size of the first extent of this index in a local. managed tbsp, whereas I get a sorted result in one second)

Is there any way to get a better response time in 10g ?

Thanks.
SR Received on Wed Apr 11 2007 - 03:23:47 CDT