Calculate the variable-length key size:
Posted by:
AUM A
Date: January 02, 2008 10:10PM
Hi All,
I apologize if this is not the right place to post this question. However I wish to calculate the variable length key size.Upon some reserach i was able to conclude that to Calculate the variable-length data size: determine how much space is used to store the columns within the row:
The expected row length for dynamic-sized rows is calculated using the following expression:
3 + (number of columns + 7) / 8
+ (number of char columns)
+ (packed size of numeric columns)
+ (length of strings)
+ (number of NULL columns + 7) / 8
Do we have a better and a easier way to calculate this as i wish to fetch these variables and do the calculation thru a perl script.
Subject
Views
Written By
Posted
Calculate the variable-length key size:
3432
January 02, 2008 10:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.