| How to work out Rows per Block? [message #61429] |
Thu, 22 April 2004 16:19  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
I would like to work out how many rows I am storing in each block for a particular segment.
Any ideas on how to do this?
Thanks .... IA
|
|
|
|
| Re: How to work out Rows per Block? [message #61433 is a reply to message #61429] |
Thu, 22 April 2004 21:54  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Well the simple way to do this is just find the block size of ur DB by the intialization parameter DB_BLOCK_SIZE, after that check AVG_ROW_LEN in DBA_/USER_TABLES. Divide the size of ur oracle block with AVG_ROW_LEN, which will give u the approx (because a protion of memory in each block is used to store the internal information known as block overhead) no of rows which is getting stored in ur block.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
