September 28, 2015
Oracle Database
How to Display Temporary Tablespace Free Space in oracle database
Query: set pagesize 60 column “Tablespace” heading “Tablespace Name” format a30 column “Size” heading “Tablespace|Size (mb)” format 9999999.9 column “Used” heading “Used|Space (SQL> mb)” format 9999999.9 column “Left” heading “Available|Space (mb)” format 9999999.9 …