Database Administration (MOSC)

MOSC Banner

Finding the table size.

edited Mar 16, 2010 1:54AM in Database Administration (MOSC) 6 commentsAnswered
 Hi All.

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),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center