Home » RDBMS Server » Server Administration » how to calculate free tablespace ?
how to calculate free tablespace ? [message #171667] Wed, 10 May 2006 23:30 Go to next message
wayn
Messages: 2
Registered: May 2006
Location: Australia
Junior Member
Hi,

I am trying to find out a method to calculate the tablespace usage :

1. How much free space in MB of each tablespace.
2. The usage in percentage.

In my database system, many datafiles will have autoextents turned on and therefore a reported 100% tablespace full may not truly mean it is going to run out of space. This would apply only if the max_extents of the datafile has been reached.

Any advice will be appreciated.

waynz

Report message to a moderator

Re: how to calculate free tablespace ? [message #171681 is a reply to message #171667] Thu, 11 May 2006 01:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
link 1
link 2

MHE

Report message to a moderator

Re: how to calculate free tablespace ? [message #171684 is a reply to message #171681] Thu, 11 May 2006 01:31 Go to previous message
wayn
Messages: 2
Registered: May 2006
Location: Australia
Junior Member
Greaaat! Laughing thanks.

waynz

Report message to a moderator

Previous Topic: V$ tables
Next Topic: find out export process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:20:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.