Home » RDBMS Server » Server Administration » size of index
size of index [message #61910] Wed, 09 June 2004 10:34 Go to next message
Galvano
Messages: 3
Registered: July 2003
Junior Member
Hi ! I have to estimate the size of all indexes of a tablespace.
I work with Oracle 9.2 and Solaris 5.8.
I would like to Know how to compute index size from its
structure and number of rows , and which factors influence the size of indexes.

Thank You

Galvano

Italy

Report message to a moderator

Re: size of index [message #61915 is a reply to message #61910] Wed, 09 June 2004 21:11 Go to previous message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
select sum(bytes)
from dba_extents
where segment_type='INDEX';

Report message to a moderator

Previous Topic: Question for you.
Next Topic: controlfile is older than datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:23:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.