Posted By

ceduard0 on 07/12/13


Tagged

DBA


Versions (?)

Show the state of the tablespace from Oracle Database


 / Published in: SQL
 

This SQL statement list tablaspace information from an Oracle database.

  1. SELECT a.TABLESPACE_NAME,a.BYTES/1024/1024 "Mb free",b.BYTES/1024/1024 "Mb used",
  2. (a.BYTES/1024/1024)+(b.BYTES/1024/1024) "Mb Total"
  3. FROM SM$TS_FREE a,SM$TS_USED b
  4. WHERE a.TABLESPACE_NAME = b.TABLESPACE_NAME;

Report this snippet  

You need to login to post a comment.