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

 
 

0 comments:

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