Re: DB_BLOCK_SIZE: Possible Misinformation

SatarNag (satarnag_at_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:                       <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->