OraFAQ Forum: Server Administration » Find used/free space of a tablespace

Home » RDBMS Server » Server Administration » Find used/free space of a tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find used/free space of a tablespace [message #132762]

Tue, 16 August 2005 01:26

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

I have created a tablespace called ts1 with 20mb size a week back. now i want to find how much of that tablespace is free and how much is having data.

Thanks,
Praveen

Report message to a moderator

Re: Find used/free space of a tablespace [message #132788 is a reply to message #132762]

Tue, 16 August 2005 03:59

dmitry.nikiforov
Messages: 723
Registered: March 2005

Senior Member

select fs.tablespace_name,
sum(fs.bytes) "Free space",
sum(df.bytes) - sum(fs.bytes) "Used space"
from dba_free_space fs,
dba_data_files df
where fs.tablespace_name = df.tablespace_name
group by fs.tablespace_name;

Rgds.

Report message to a moderator

Re: Find used/free space of a tablespace [message #132789 is a reply to message #132788]

Tue, 16 August 2005 04:21

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Great..

Regds
Dinesh

Report message to a moderator

Previous Topic:	Need Your Help
Next Topic:	create database error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 10:41:28 CST 2025