Re: Oracle Block

Michael Ling <Michael.Ling_at_citicorp.com> wrote:
>
>How big is an Oracle block?

-- 
Michael:
Oracle block sizes are variable. You set it with the init.ora parm
db_block_size. What you set it to depends on the type of hardware
you're on and what your database is going to do. This parameter
only really has an effect when you do a CREATE DATABASE. Don't ever
change it after you have created the database, it ain't pretty.
Setting it to a larger size will get you a higher MAXEXTENTS parameter
when doing object (table or index) creation. In 7.3 MAXEXTENTS goes away 
anyway.
Hope this helps.
==================================================================
Bob Manieri                           email : bmanieri_at_ford.com
Database Administrator                voice : (610) 584-7085
Ford Electronics, Lansdale, PA        pager : (609) 342-0314
------------------------------------------------------------------
Business is war....information is the high ground.  - J.Abrahamson
..we can deprive the enemy of the high ground.  - J. Buford
==================================================================