ivonko.com

Archive for March, 2010

Oracle partition size in Mb

by on Mar.17, 2010, under Development

Make connection as system or with user with “DBA” privilege

select partition_name,segment_name,
round(sum(bytes)/1024/1024,2) as Mb
from sys.dba_segments
where 1=1
and segment_name =’SOME_PARTITIONED_TABLE’ –table name
and tablespace_name = ‘USERS’ — tablespace name
and partition_name in (‘P16032010′,’P17032010′)
group by partition_name, segment_name

Comments Off more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Archives

All entries, chronologically...