Home » RDBMS Server » Server Administration » which initializaion parameter cant be change
icon7.gif  which initializaion parameter cant be change [message #552818] Sun, 29 April 2012 00:09 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
which initializaion parameter cant be change after creating the database?
Re: which initializaion parameter cant be change [message #552820 is a reply to message #552818] Sun, 29 April 2012 00:46 Go to previous messageGo to next message
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.
Re: which initializaion parameter cant be change [message #552822 is a reply to message #552818] Sun, 29 April 2012 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All parameters are described in Database Reference.
Please read it and post the answer to your question.

Regards
Michel
Re: which initializaion parameter cant be change [message #552826 is a reply to message #552820] Sun, 29 April 2012 01:43 Go to previous messageGo to next message
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
Re: which initializaion parameter cant be change [message #552833 is a reply to message #552826] Sun, 29 April 2012 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
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
icon7.gif  Re: which initializaion parameter cant be change [message #552843 is a reply to message #552833] Sun, 29 April 2012 07:50 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks michel to give your important time.
Previous Topic: log switch and instance monitoring
Next Topic: check free extents in a tablespace
Goto Forum:
  


Current Time: Wed Apr 14 17:30:26 CDT 2021