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 -> DBA_SEGMENTS and Full scan

DBA_SEGMENTS and Full scan

From: Guitarator <d.jeanneret_at_wanadoo.fr>
Date: 16 Jun 2006 02:24:19 -0700
Message-ID: <1150449859.366514.267510@y41g2000cwy.googlegroups.com>


Hi

Actually a single request on the Dba_segments have 7 Full_scan on SYS.TAB$, SYS.TABPARTS$, SYS.CLU$ ... . Is there a way to contourn this problem ?

SELECT SUM(bytes)/1024/1024
 FROM DBA_SEGMENTS
  WHERE tablespace_name = 'TBDATA001'
    AND segment_type = 'TABLE'
/

Oracle version is 9.2.0.6
O.S. AIX 5.3 Received on Fri Jun 16 2006 - 04:24:19 CDT

Original text of this message

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