How to Check the table Size in Oracle

• To check table name segment type, owner and table size in GB  

select owner,segment_name,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments  where owner='GL' and segment_type='TABLE' and segment_name in

('GL_LEDGERS',

'GL_JE_LINES',

'GL_CODE_COMBINATIONS',

'GL_CODE_COMBINATIONS_KFV',

'GL_PERIODS',

'GL_JE_HEADERS',

'RA_CUST_TRX_LINE_GL_DIST_ALL',

'GL_BUDGET_VERSIONS',

'GL_BUDGETS',

'GL_PERIOD_TYPES',

'GL_BALANCES',

'GL_JE_BATCHES')

group by owner,segment_name order by "SIZE in GB" desc;

• To check table name segment type table size in GB .

select owner,segment_name,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments where segment_type='TABLE' and segment_name in

('MTL_TRANSACTION_ACCOUNTS',

'MTL_SYSTEM_ITEMS_B',

'MTL_CATEGORIES_B',

'JTF_RS_GROUPS_B',

'JTF_RS_RESOURCE_EXTNS',

'IBY_PAYMENT_METHODS_TL',

'PO_LINES_ALL',

'PO_HEADERS_ALL',

'RA_CUST_TRX_LINE_GL_DIST_ALL',

'RA_CUSTOMER_TRX_ALL',

'RA_TERMS_B',

'XLA_AE_LINES',

'XLE_ENTITY_PROFILES',

'XLA_AE_HEADERS',

'XLA_DISTRIBUTION_LINKS',

'XLA_CONTROL_BALANCES',

'XLA_TRANSACTION_ENTITIES',

'XLA_AE_LINE_ACS',

'XLA_AC_BALANCES')

group by owner,segment_name order by "SIZE in GB" desc;