Advanced Search

Show the state of the tablespace from Oracle Database

/ Published in: SQL
Save to your folder(s)
This SQL statement list tablaspace information from an Oracle database.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.