Re: February DBA Tip of the Month

In article <6bobuh$3d50$1_at_newssvr04-int.news.prodigy.com>, HONG CHEN <SCHEN1_at_prodigy.net> wrote:
>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?

Use the exp utlity to make a full database backup. Create a new database with the new db_block_size. Use the imp utility to restore. Imp may be much slower than exp.

>
>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.
>>
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!