OraFAQ Forum: Server Administration » which initializaion parameter cant be change

Home » RDBMS Server » Server Administration » which initializaion parameter cant be change

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which initializaion parameter cant be change [message #552818]

Sun, 29 April 2012 00:09

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

which initializaion parameter cant be change after creating the database?

Report message to a moderator

Re: which initializaion parameter cant be change [message #552820 is a reply to message #552818]

Sun, 29 April 2012 00:46

harshkejriwal
Messages: 8
Registered: April 2012

Junior Member

Hi Pritesh,

priteshranjan.preet wrote on Sun, 29 April 2012 09:09

which initializaion parameter cant be change after creating the database?

The block size of the database cannot be changed after database creation. The database name can be changed after re-creating the control file with a new name, and the CONTROL_FILES parameter can be changed if the files are copied to a new location.

These all parameters pass in a file called as init.ora file.

Report message to a moderator

Re: which initializaion parameter cant be change [message #552822 is a reply to message #552818]

Sun, 29 April 2012 00:57

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

All parameters are described in Database Reference.
Please read it and post the answer to your question.

Regards
Michel

Report message to a moderator

Re: which initializaion parameter cant be change [message #552826 is a reply to message #552820]

Sun, 29 April 2012 01:43

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

but the oracle support multiple block size in the same database.the standard block size is used for the system tablespace and we can specify the standard block size by settin the initialization parameter db_block_size.legitimate value are from 2k to 32k and default 8k. and the cache size of nonstandard block size buffers are specified by the

db_2k_cache_size
db_4k_cache_size
db_8k_cache_size
db_16k_cache_size
db_32k_cache_size.

i m trying to do it but it cant work why? please clear it

SQL> show parameter db_block_size;

NAME TYPE VALUE
------------------------------------ ----------- -----------------
db_block_size integer 8192

SQL> alter system set db_block_size = 8194 scope= spfile;
alter system set db_block_size = 8194 scope= spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_block_size" cannot be updated in SPFILE

thanks & regards
pritesh ranjan

Report message to a moderator

Re: which initializaion parameter cant be change [message #552833 is a reply to message #552826]

Sun, 29 April 2012 03:02

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is what has been said: you cannot change db_block_size parameter and this is clearly in the documentation maybe you SHOULD read it:

Quote:

The value for DB_BLOCK_SIZE in effect at the time you create the database determines the size of the blocks. The value must remain set to its initial value.

The usage of non standard block size is also described in the documentation.
Database Concepts
Administrator's Guide
Database SQL Reference

Regards
Michel

Report message to a moderator

Re: which initializaion parameter cant be change [message #552843 is a reply to message #552833]

Sun, 29 April 2012 07:50

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

thanks michel to give your important time.

Report message to a moderator

Previous Topic:	log switch and instance monitoring
Next Topic:	check free extents in a tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 03:52:09 CST 2025