Re: Oracle Block Size and Solaris 2.6

satar_at_my-dejanews.com wrote:
: Can you please tell me where you got this information that Oracle Now
: recommends 8-16k block sizes for most things? If it is from your Instructor,
: please give me his name and work phone number or e-mail address.

It was from 2 different instructors teaching the O7DBA course. No, I will not give out their names or email addresses! That'd be impolite of me.

: Just curious...not attacking your post at all. My Documentation "Oracle for
: Sun Performance Tuning Tips" (Part No. A25584-1) says on page 17: "We

Well... 1) when was it dated? 2) realise that documentation _always_ languishes behind "best practice recommendations."

Umm, A quick search on technet.oracle.com for block_size shows

    Oracle8 Tuning

     Release 8.0
     A58246-01

    19
    Tuning Parallel Execution

    DB_BLOCK_SIZE     Recommended value: 8K or 16K

    The database block size must be set when the database is created. If     you are creating a new database, use a large block size.

http://technet.oracle.com/doc/server.804/a58246/pextune.htm

Although this segment is specifically for parallel execution, I was told this is now generally correct.

Technet is a great place to find answers :-)

--

rgds
Stephen Received on Mon Dec 07 1998 - 17:00:03 CST