***********************************************************
* Description: SQL for querying schema, table segment size
* Compatiablity: RDBMS 11g, 12c
* Date: 10:42 PM EST, 04/05/2017
***********************************************************


<1> Checking schema size:
     |
     |__ SQL> SELECT sum(bytes/1024/1024) FROM dba_segments WHERE owner = 'APP_DEV';
	 
	 
<2> Checking table size:
     |
     |__ SQL> select OWNER,SEGMENT_NAME, BYTES/1024/1024 as MB from dba_segments where owner='TEST' and SEGMENT_NAME='BA_BENFS';
                                                          
             OWNER       SEGMENT_NAME               MB
             ----------- ------------------ ----------
             NEBF        BA_BENFS            4.0078125