OraFAQ Forum: Server Administration » O/S Blocks vs Database blocks

Home » RDBMS Server » Server Administration » O/S Blocks vs Database blocks

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

O/S Blocks vs Database blocks [message #239673]

Wed, 23 May 2007 00:58

california_6_1
Messages: 29
Registered: February 2007

Junior Member

I was wondering, whats the co-relation between Database Blocks and OS blocks? Let's say, I have a database running on a 64-bit OS and the database block size is 8kb.

How does an O/S handle and fullfill any block request from database?

Appreciated if someone please advice.

Thanks,
Cali

Report message to a moderator

Re: O/S Blocks vs Database blocks [message #239674 is a reply to message #239673]

Wed, 23 May 2007 01:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> whats the co-relation between Database Blocks and OS blocks
typically DB block > OS block
so why does it matter (to you)?
Once you have the answer, how will it change your life?

Report message to a moderator

Re: O/S Blocks vs Database blocks [message #239685 is a reply to message #239674]

Wed, 23 May 2007 01:27

california_6_1
Messages: 29
Registered: February 2007

Junior Member

Dude,

If you dont know the answer, its best to keep quiet. dont post messages and embarass yourself..

Thanks,

Report message to a moderator

Re: O/S Blocks vs Database blocks [message #239690 is a reply to message #239685]

Wed, 23 May 2007 01:41

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Cali,

If you want an answer, first be polite with those who can help you.
Next Ana gives the answer (although I said >= instead of >).

Regards
Michel

Report message to a moderator