Home » RDBMS Server » Server Administration » how to change the initial db_blk_size in control files?
how to change the initial db_blk_size in control files? [message #52694] Wed, 07 August 2002 01:12 Go to next message
renan
Messages: 4
Registered: July 2002
Junior Member
dear Orafaq,
need your help... last week we have just migrated our database to O8i(8.1.6). however, during the trial-run, we found the response time of the database to be slow.
one major factor that were looking@the moment is the initial settings of the database (mostly the size of the data blocks).
does anyone know how to resize the initial db_blk_size in the control files??..

thanks,
renan 08/07
Re: how to change the initial db_blk_size in control files? [message #52697 is a reply to message #52694] Wed, 07 August 2002 04:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you cannot change block size, once the database is created.
so,
change the block size in initora.
and recreate the database.
Re: how to change the initial db_blk_size in control files? [message #52703 is a reply to message #52697] Wed, 07 August 2002 06:54 Go to previous messageGo to next message
renan
Messages: 4
Registered: July 2002
Junior Member
dear mahesh,
once again, thank you for your reply!!.. we already change the db_block_size parameter in initora, but it caused us the incompatibility error with the control files.
i understand your point about re-creating the database to re-define the control files,.. but - is there no other work around to this problem? our company is currently on a 24/7 production status that's why it will be very difficult for us to create a new database.
thanks for your help!

brgds,
renan 08/07
Re: how to change the initial db_blk_size in control files? [message #52706 is a reply to message #52697] Wed, 07 August 2002 09:59 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
May be you did not get what Mahesh said...

recreate the database means create from scratch...

Good luck.
Previous Topic: Install oracle 8.1.7 on solaris 2.8
Next Topic: Default values for SQLPLUSW.EXE
Goto Forum:
  


Current Time: Thu Sep 19 18:18:05 CDT 2024