Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2016-03-17 02:25:44 →
Size: 69
Editor: localhost
Comment:
← Revision 2 as of 2016-03-17 02:25:56 → ⇥
Size: 869
Editor: localhost
Comment:
Deletions are marked like this. Additions are marked like this.
Line 4: Line 4:
set linesize 300
SELECT upper(f.tablespace_name) "tablespace_name",
       d.Tot_grootte_Mb "tablespace(M)",
       d.Tot_grootte_Mb - f.total_bytes "used(M)",
       round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100,2) "use%",
       f.total_bytes "free_space(M)",
       round(f.total_bytes / d.Tot_grootte_Mb * 100,2) "free%"
 FROM
    (SELECT tablespace_name,
            round(SUM(bytes)/(1024*1024),2) total_bytes,
            round(MAX(bytes)/(1024*1024),2) max_bytes
      FROM sys.dba_free_space
     GROUP BY tablespace_name) f,
    (SELECT dd.tablespace_name, round(SUM(dd.bytes)/(1024*1024),2) Tot_grootte_Mb
      FROM sys.dba_data_files dd
      GROUP BY dd.tablespace_name) d
WHERE d.tablespace_name = f.tablespace_name
ORDER BY 4 DESC
/

show tablespace usages status

set linesize 300 SELECT upper(f.tablespace_name) "tablespace_name",

  • d.Tot_grootte_Mb "tablespace(M)", d.Tot_grootte_Mb - f.total_bytes "used(M)", round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100,2) "use%", f.total_bytes "free_space(M)", round(f.total_bytes / d.Tot_grootte_Mb * 100,2) "free%"
  • FROM
    • (SELECT tablespace_name,
      • round(SUM(bytes)/(1024*1024),2) total_bytes, round(MAX(bytes)/(1024*1024),2) max_bytes
      • FROM sys.dba_free_space
      • GROUP BY tablespace_name) f,
      (SELECT dd.tablespace_name, round(SUM(dd.bytes)/(1024*1024),2) Tot_grootte_Mb
      • FROM sys.dba_data_files dd GROUP BY dd.tablespace_name) d

WHERE d.tablespace_name = f.tablespace_name ORDER BY 4 DESC /

désert/Oracle/Check (last edited 2022-05-26 03:44:21 by merlyn)