Home » RDBMS Server » Performance Tuning » number of rows per db block
number of rows per db block [message #162225] Thu, 09 March 2006 04:05 Go to next message
srhl
Messages: 24
Registered: December 2005
Junior Member
How to calculate number of rows per DB block?
Ex:

db block size=8192
row length(number of bytes that row occupies) = 40

is it 8192/40?

Thanks in advance.
Re: number of rows per db block [message #162250 is a reply to message #162225] Thu, 09 March 2006 06:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Roughly speaking,
(8192 - PCTFREE)/40

[Updated on: Thu, 09 March 2006 07:15]

Report message to a moderator

Re: number of rows per db block [message #162363 is a reply to message #162250] Thu, 09 March 2006 21:10 Go to previous message
srhl
Messages: 24
Registered: December 2005
Junior Member
Thanks for your reply.
You said, 'Roughly speaking' , means is there any other way to calculate this?
how to calculate the rowlength?
Is there any SQL to be used or we can manually calculate the number of bytes occupied by each row?
Previous Topic: Index Monitoring
Next Topic: When to rebuild indexes ...
Goto Forum:
  


Current Time: Fri Mar 29 10:25:05 CDT 2024