Re: SQL to list actual space used
From: John Morgan <John_Morgan_at_OIT.PeachNet.EDU>
Date: 9 Nov 1993 13:26:25 GMT
Message-ID: <2bo5q1$c_at_news-feed-2.peachnet.edu>
Date: 9 Nov 1993 13:26:25 GMT
Message-ID: <2bo5q1$c_at_news-feed-2.peachnet.edu>
In article <CG809E.L64_at_uk.ac.brookes> Tommy Wareing,
p0070621_at_oxford-brookes.ac.uk writes:
>Does anyone have a script to give the size of an INDEX on a table?
>Or an algorithm to determine what the size would be?
>
You can use:
SELECT SEGMENT_NAME, SEGMENT_TYPE, SUM(BYTES)
FROM USER_SEGMENTS
GROUP BY SEGMENT_NAME, SEGMENT_TYPE;
This will list each segment type (Table, index, or Rollback) to which you
have access and its size in bytes (present size).
Received on Tue Nov 09 1993 - 14:26:25 CET