Subject: Re: DB_BLOCK_SIZE: Possible Misinformation
Newsgroups: comp.databases.oracle.misc
References: <19970801153801.LAA18307@ladder02.news.aol.com>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com

SatarNag (satarnag@aol.com) wrote:
: In regards to changing the DB-Block_Size without re-creating your
: database, I must have been misinformed, Upon looking up in my
: documentation, it says it must be done on the creation of the database. I
: have just completed the Oracle DBA master's coarse (Oracle 7.3), offered
: by Oracle....And in my notes, i wrote down that the Block Size can be
: changed and that the database will start useing the new size and will
: adjust accordingly...I wrote this down cause I thought it was nice that it
: can be done. Maybe it still can be done, and that it's not documented in
: the books. I apoligize if I am mistaken. Maybe it's in Version 8??? 
: 
: Satar Naghshineh

Satar,

db_block_size can only be defined at database creation. Once the instance is
created, the datafiles are "hard-coded" with the blocks allocated, and this
cannot be altered. I just checked my Oracle8 docs and the same is true for
Oracle8.

Maybe you were thinking of db_block_buffers?

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 90+ Oracle tips, visit my Web Page:                       <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ack to Ari Kaplan's Home Page