/ Published in: SQL
This SQL statement list tablaspace information from an Oracle database.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT a.TABLESPACE_NAME,a.BYTES/1024/1024 "Mb free",b.BYTES/1024/1024 "Mb used", (a.BYTES/1024/1024)+(b.BYTES/1024/1024) "Mb Total" FROM SM$TS_FREE a,SM$TS_USED b WHERE a.TABLESPACE_NAME = b.TABLESPACE_NAME;