Home » RDBMS Server » Server Administration » calculation
calculation [message #50736] Wed, 03 April 2002 22:31 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
Given the number of initial rows in a table, and also the datatypes of the different columns in that table, what is the formula for finding out how many rows can be accomodated in a data block?
Please help, it's urgent!
Re: calculation [message #51200 is a reply to message #50736] Tue, 07 May 2002 01:24 Go to previous message
Sreedhar
Messages: 30
Registered: March 2000
Member
Hi Krishna..

Check out this procedure.. for the Table size;

1)7292/<rowsize> == number of rows per block
2)number of rows per block * total number of rows to proces = size in bytes
3)size in bytes /1024/1024== size in megss

Let me know if u need more info...

Thanks
-Sreedhar
Previous Topic: Anyone out there working as Oracle DBA
Next Topic: Benefits of OCP
Goto Forum:
  


Current Time: Wed Dec 25 09:52:25 CST 2024