Re: February DBA Tip of the Month

I would like to know the exact way to make use of the 4k db_block_size. Do we have to recreate the database in order to use it? How do we get the datafiles back from 2k db_block_size to the new databse created?

Cam, could you tell us please?

Steven
Cam White wrote in message <01bd3241$88e7d640$1373b1cd_at_Preveal2>...
>From the DBA Pipeline - a free, internet-based community for Oracle DBAs
>hosted by author Mike Ault, and sponsored by RevealNet. Stop by and visit
>the DBA Pipeline for lively technical discussions, free white papers, tips
>and insights from Oracle DBAs around the world.
>http://www.revealnet.com/dbapipe/index.htm
>
>February's Tip of the Month
>
>Sizing database blocks
>
>Oracle always reads in 64k chunks. It is best to size your database blocks
>and multi-block read count such that their product is 64k. Optimal results
>for full table scans have been reported with a 4k block size and a 16k
>multi_block_read_count equivilent setting.
>
>Join the DBA Pipeline. It is completeley free, with no restricted areas.
>If you are (or plan to be) an Oracle DBA, this is a great place to keep
>your finger on the pulse of Oracle technology.
>
>Best wishes,
>
>Cam White
>RevealNet, Inc.
>
Received on Mon Feb 09 1998 - 00:00:00 CST