How to find size of objects in Oracle.

When you want to find size of object (table, index) in your oracle database, you can use this script.

SELECT sum(bytes)/1048576 Megs, segment_name
FROM dba_extents
WHERE segment_name = '&object_name'
GROUP BY segment_name
/

Ref : http://www.arikaplan.com/oracle/ari60399.html

== TaTsHuYa ==