Oracle Tablespace Notes

Submitted by code_admin on Wed, 07/18/2018 - 11:25
  1. select *
  2. from V$TABLESPACE
  3. ;
  4. select *
  5. from DBA_FREE_SPACE
  6. where tablespace_name='USERS'
  7. ;
  8.  
  9. SELECT TABLESPACE_NAME "TABLESPACE", FILE_ID,
  10.    COUNT(*)    "PIECES",
  11.    MAX(blocks) "MAXIMUM",
  12.    MIN(blocks) "MINIMUM",
  13.    AVG(blocks) "AVERAGE",
  14.    SUM(blocks) "TOTAL"
  15.    FROM DBA_FREE_SPACE
  16. GROUP BY TABLESPACE_NAME, FILE_ID;
  17.  
  18. select
  19.    tablespace_name,
  20.    used_percent
  21. from
  22.    dba_tablespace_usage_metrics

Tags

RJM Article Type
Quick Reference