Friday, June 11, 2010

Disk Space used by a Table in Oracle

 How to find the Disk Space used by a table in Oracle, Here is the query

SELECT   segment_name table_name,
         SUM(BYTES) /(1024 * 1024) table_size_meg
FROM     user_extents
WHERE    segment_type = 'TABLE' AND
         segment_name = 'MY_TABLE'
GROUP BY segment_name



Post a Comment


ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com