DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Oracle (http://www.daniweb.com/forums/forum129.html)
-   -   !! Size of a table (http://www.daniweb.com/forums/thread142734.html)

jinsonsanik Aug 28th, 2008 4:11 am
!! Size of a table
 
Please help me out to find the actual size of the table .

i have used two methods one is (num_rows*avg_row_len)/1024 .

other one vsize(columns1) (for each column in table).

but both the methods are not giving me the right answer help me if u know actual method to find the table size using table overhead ,pctfree and pctused parameters


All times are GMT -4. The time now is 1:28 am.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC