Re: monitor space

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Tue, 17 Aug 1999 08:35:15 +0100
Message-ID: <7pb3bo$g66$1@taliesin.netcom.net.uk>

Brian Yan wrote in message <7pa4fa$s9o$1_at_nnrp1.deja.com>...
>Hi there,
>
>I am confused now. My space monitoring report shows that the percent
>free of tablespace is close to 0%, but my supervisor still said it had
>plenty of space. The reason is as follows,
>
>Tablespace TS1 has size 500M, it only has one table TB1 on it. TB1 has a
>big initial extent 499M, although right now the row number of TB1 is
>zero. In this case, percent free of a tablespace does make sense at all.
>
>My question is, is there a way to calculate the percent of used space
>rather than the allocated space? I tried out several methods, but it
>looks like DATA Dictionary does not contain "space used" information.
>Please let me know if you have a way to calculate the used space.
>

Have a look at http://www.jlcomp.demon.co.uk/freespac.html courtesy of Jonathan Lewis - it may do what you want.

Alex Received on Tue Aug 17 1999 - 02:35:15 CDT