How to measure table growth

[zircon06]

Hi santha or anyone,

Can anyone throw your thoughs how to measure tables size growth when upgrading from database from one version to another this is into oracle version upgrade but just on database side let us say database version at 4.5 level and upgrading to 4.8 level.

Thanks in advance

 

[SantaMufasa]

Can anyone throw your thoughs how to measure tables size growth when upgrading from...say database version at 4.5 level and upgrading to 4.8 level.

Zircon,

I'm not quite sure what you mean by "level" 4.5 to 4.8. You are posting this question in the "Oracle 10g" forum. Presently, the highest software version for most Oracle 10g platforms is "10.2.0.3". So I'm puzzled by the "4.5 -> 4.8-level" reference.

If I infer from your question correctly, you are wondering how to measure the disk-consumption impact (for just your tables) of upgrading from one Oracle version to another Oracle version:

Since version upgrades typically affect Oracle software, such version changes typically do not have any impact on your application-table structures and sizes.

Depending upon the software (and data dictionary) changes that a new Oracle version implements, there may be a negligible (typically increased) size change in data-dictionary object consumption. Any size change is, frankly, so insignificant that it would probably be a waste of anyone's time to try to identify such a difference.

If you still wish to pursue such information, you could query (individually or collectively) the sizes of all of the objects that Oracle user, "SYS" owns in an old version, then do the same query against a newer version. Comparing the results will give you a definitive (yet insignificant, in my opinion) answer to your question.

Let us know your thoughts.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]