Friday, May 5, 2017

DBA DATABASE SCHEMA SIZE Check

DATABASE SCHEMA SIZE from the database


set linesize 2000
set pagesize 5000
col owner for a155

select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner;

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/