12 March 2016

Oracle SQL to find a Table size

Here you go,


select SEGMENT_NAME, round((bytes*0.000001),2) size_in_mb , round((bytes*0.000001),2) *0.001 size_in_gb from dba_SEGMENTS
where SEGMENT_NAME = 'Table Name'

6 comments:

oraclefusion said...

Thanks for sharing the useful information about the oracle concept and good points were mentioned in the blog for the further information visit our site
Oracle Fusion Financials

oraclefusion SCM said...

Hi,

this is very informative blog.interesting and valuable. Thanks for sharing this blog.
oracle fusion SCM on line training

oraclefusion said...

I was searching for this kind of stuff from past few days and nice points were stated in this article and for the further information visit our site
Oracle Fusion Financials Training

oracleSCM said...

Hi,

this is very informative blog.Thanks for sharing such a good blog.
oracle fusion HCM on line training

Unknown said...

we are the leading oracle fusion financials training institutes search engine. we have huge database regarding oracle institutions present in india. we can provide complete institute details as we don't have money charge policy for the information provided



Oracle fusion Financials Training in hyderabad

Oracle Fusion Financials online Training in hyderabad

Aravindmudraveni said...
This comment has been removed by the author.