Finding the table size.
I have another challange which I am still trying to resolve.
One of the tables in my production system is 550 GB. We are planning to archive the old data. For that matter I have to now calculate the size of the table in ranges as in size from 2006-2007 and 2007-2008 etc.
There is a formula in metalink to calculate the average row size. LIke the following:
select round(avg(nvl(vsize(ID),0)),0) + round(avg(nvl(vsize(CLIENT_ID),0)),0) + round(avg(nvl(vsize(CN_RUNNING_NO),0)),0) + round(avg(nvl(vsize(DDATE),0)),0) + round(avg(nvl(vsize(INTERVAL_START_TIME),