Home » RDBMS Server » Server Administration » O/S Blocks vs Database blocks
O/S Blocks vs Database blocks [message #239673] Wed, 23 May 2007 00:58 Go to next message
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
Re: O/S Blocks vs Database blocks [message #239674 is a reply to message #239673] Wed, 23 May 2007 01:01 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
Re: O/S Blocks vs Database blocks [message #239685 is a reply to message #239674] Wed, 23 May 2007 01:27 Go to previous messageGo to next message
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,
Re: O/S Blocks vs Database blocks [message #239690 is a reply to message #239685] Wed, 23 May 2007 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: O/S Blocks vs Database blocks [message #239705 is a reply to message #239690] Wed, 23 May 2007 02:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

This has been discussed earlier
http://www.orafaq.com/forum/t/27122/0/
Re: O/S Blocks vs Database blocks [message #239867 is a reply to message #239705] Wed, 23 May 2007 08:49 Go to previous message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Thank you so much Michel Cadot and tahpush for your answers. really appreciated.

Previous Topic: Oracle DBA Fundamentals II (Note Sheets)
Next Topic: DBCA errors (in server with 10g and 8i)
Goto Forum:
  


Current Time: Sat Dec 10 07:23:08 CST 2016

Total time taken to generate the page: 0.09759 seconds