Table Space Usage
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Table Space Usage as PDF for free.
More details
- Words: 38
- Pages: 1
set pages 700 set linesize 1000 select t.tablespace_name,total_MB,round((total_MB-free_MB),2) used_MB, round(free_MB,2) free_MB, round(((total_MB-free_MB)/total_MB)*100,2) per_used,round((free_MB/total_MB)*100,2) per_free from (select tablespace_name,sum(bytes/1024/1024) free_MB from dba_free_space group by tablespace_name) f, (select tablespace_name,sum(bytes/1024/1024) total_MB from dba_data_files group by tablespace_name) t where f.tablespace_name(+)=t.tablespace_name order by 5;
Related Documents
Table Space Usage
May 2020 3
Transportable Table Space Refresh
November 2019 8
Table Space Create Error
November 2019 13
Create Table Space
November 2019 8
One Table Space Oracle
May 2020 6