OraFAQ Forum: Performance Tuning » number of rows per db block

Home » RDBMS Server » Performance Tuning » number of rows per db block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

number of rows per db block [message #162225]

Thu, 09 March 2006 04:05

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.

Report message to a moderator

Re: number of rows per db block [message #162250 is a reply to message #162225]

Thu, 09 March 2006 06:40

Mahesh Rajendran
Messages: 10708
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

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?

Report message to a moderator

Previous Topic:	Index Monitoring
Next Topic:	When to rebuild indexes ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 14:52:16 CST 2024