Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
howto:ora18oln7 [2019/10/06 13:29]
ibk [Monitor Used Space]
howto:ora18oln7 [2019/10/06 13:30] (current)
ibk [Monitor Used Space]
Line 371: Line 371:
  
 Check used space per tablespace: Check used space per tablespace:
-<​code ​sql>+<​code>​
 select tablespace_name,​ round(bytes/​1024/​1024) MB, round(bytes/​1024/​1024/​1024,​3) GB from cdb_data_files;​ select tablespace_name,​ round(bytes/​1024/​1024) MB, round(bytes/​1024/​1024/​1024,​3) GB from cdb_data_files;​
 </​code>​ </​code>​
Line 391: Line 391:
  
 If you just want the summary of user data: If you just want the summary of user data:
-<​code ​sql>+<​code>​
 select round(sum(bytes)/​1024/​1024) MB, round(sum(bytes)/​1024/​1024/​1024,​3) GB from cdb_data_files select round(sum(bytes)/​1024/​1024) MB, round(sum(bytes)/​1024/​1024/​1024,​3) GB from cdb_data_files
 where tablespace_name not like '​SYS%'​ and tablespace_name not like '​UNDO%';​ where tablespace_name not like '​SYS%'​ and tablespace_name not like '​UNDO%';​