space used 1

[ptheriault]

In SQL Server there is system proc I can run name sp_spaceused that will show me how much space is used and free space. Is there a similar query in Oracle? I need to know how big each table space is and how much free space I have for each.

Thanks

 

[KenCunningham]

Santa (aka Dave of Sandy, Utah) has come early for you this year. See his freespace.sql in Thread759-1050122

Hopefully this will suit your requirements.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[ptheriault]

Thanks Ken,
That is just what I was looking for.

 

[KenCunningham]

No problem - but I feel a bit guily about a star that should be Dave's!!

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[ptheriault]

I gave him a star too.

 

[KenCunningham]

Excellent - thanks. My conscience is salved!

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[SantaMufasa]

Very thoughtful of both of you. I'm just pleased that people continue to find the code useful.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]