| Index size. [message #57723] |
Wed, 02 July 2003 09:12  |
Craig
Messages: 28
Registered: October 2001
|
Junior Member |
|
|
How do I find out the size of an Index within a tablespace
Cheers
|
|
|
|
| Re: Index size. [message #57736 is a reply to message #57723] |
Wed, 02 July 2003 15:28  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
SELECT segment_name, tablespace_name, blocks, bytes
FROM dba_segments
WHERE segment_name = 'YOUR_INDEX'
AND segment_owner = 'WHO OWNS THE INDEX';
all_segments can replace dba_segments if you dont have access. this tells you how much space in bytes and blocks has been allocated to the segment (index, table, etc...).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
