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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How do I find out the size of a index

RE: How do I find out the size of a index

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Wed, 13 Aug 2003 09:19:23 -0800
Message-ID: <F001.005CA7FF.20030813091923@fatcity.com>


Roger,

Try DBA_EXTENTS instead. Something like below:

SELECT SUBSTR(TABLESPACE_NAME,1,16) "Tablespace",

  SUBSTR(OWNER,1,9) "Owner",  
  SUBSTR(SEGMENT_NAME,1,30) "Index",
  SUBSTR(sum(BLOCKS * 8),1,16) "Size K"

FROM DBA_EXTENTS
WHERE segment_type = 'INDEX'
Group By TABLESPACE_NAME, OWNER, SEGMENT_NAME ORDER BY 1, 2, 3; Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Roger Xu [SMTP:roger_xu_at_dp7uptx.com]
>
> Hi,
>
> I can use "select blocks*8 from dba_tables where table_name='ABC'"
> to find out the size of a table.
> How do I find out the size of a index? I do not see a column BLOCK in
> dba_indexes.
>
> Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 13 2003 - 12:19:23 CDT

Original text of this message

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