SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql for tablespaces used percent??

ScottZhengMay 24 2006 — edited May 27 2006

Hi all,
I need to show the details of the[b] tablespaces as following:
file_name total_size usedSize usedpercent freeSize
---------------------- -------------- -------------- ----------------- ----------
users_01.dbf 1000 650 65% 350
users_02.dbf 1000 800 80% 200
USERS(subtotal) 2000 1450 72.5% 550
rb_01.dbf 1000 700 70% 300
rb_02.dbf 1000 600 60% 400
RBS(subtotal) 2000 1300 65% 700
......
TOTAL 20000 12000 60% 8000

Who can provide a simple sql statement?
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2006

Added on May 24 2006

10 comments

1,184 views