Re: Oracle block size - OS block size

I once worked on something that was claimed to be the biggest Oracle database in the world - it was nearly 10GB. (it was actually in the top few)

In the good old days (formerly known as 'these trying times') it really was important to save all those little bits. Discs were expensive and slow and memory was small because it was very expensive

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html






Nuno Souto wrote in message <3b2f188b.1973054_at_news-server>...


>

>Once I finally cut through the "bureaucracy" of this bunch of idiots,

>the db_block_size was set to 4K as a first try.  All batch runs

>immediately sliced the runtime into half with no visible or measurable

>impact on the on-line stuff.  Makes me wonder where these "guidelines"

>came from...

>