Tablespace Size Report Script (updated)
by Seth Miller
I actually found it a little difficult to find a good sql script for reporting tablespace size so I took one that was almost there which I believe came from Oracle-Base and modified it to fit my needs. Feel free to comment or modify.
Update: I’ve made significant changes to this script including a header and the ability to change the output denomination between megabytes, gigabytes or terabytes with a simple script parameter. Take a look at the notes in the script for more details.