Database 11g

Monday, April 4, 2016

How to Check Particular Schema Size in Oracle Database



SQL> select owner,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments where owner='KIST' group by owner;

OWNER                          SIZE in GB
-----------------------------------------------------
KIST                               18.2417603



Happy Learning...

1 comment: