Tags: bigger, database, db_bloack_size, db_block_size, db_block_sizethanks, mysql, oracle, sql
How to change db_block_size?
1,971 words with 7 Comments; publish: Tue, 12 Feb 2008 22:13:00 GMT; (25046.88, « »)
Hi all,
the DB_BLOACK_SIZE in our oracle 9i is too small( 4k).
I want to change it to 8k or bigger.
How to change db_block_size?
Thanks for your help
http://oracle.itags.org/q_oracle_100421.html
All Comments
Leave a comment...
- 7 Comments
- You can create a new database with a larger blocksize or create a new Tablespace with a 8K Blocksize. But you also have to setup a 8K Buffer Pool for this new TS.
It's not possible to do something like
alter database set blocksize=8K
The best solution would be to export your schemas create a new DB and import the data.
Dim
#1; Fri, 22 Feb 2008 12:55:00 GMT
- Is it possible to do that by re-creating control files?#2; Fri, 22 Feb 2008 12:56:00 GMT
- > Is it possible to do that by re-creating control files?
Possible to do what? Change the block size?
NO!
Your database has thousands and thousands of blocks in memory and on disk that were created as 4K in physical size. You can't just flip a switch and change them.
#3; Fri, 22 Feb 2008 12:57:00 GMT
- Hi,
I think is not a good idea to change db_block_size, better to create a new one and import data.
Take a look .oracle.itags.org. URL below -
http://forums.oracle.com/forums/message.jspa?messageID=1191146
Regards,
Marcello.
#4; Fri, 22 Feb 2008 12:58:00 GMT
- Hi，
The size of db_block_size don't been changed,but you can set db_block_size for 8K at the other tablespaces. of course ,considering performance you must set db_nK_cache_size.
if so, you must export the data of database to use EXP command,then using IMP command to import the data into the database. but you notice that the tablespaces of exporting is 4K blocksize, so you can first create the tablespaces ,then importing data. or using the parameter INDEXFILE when importing data
#5; Fri, 22 Feb 2008 12:59:00 GMT
- u can't change after the database creation. can change the parameter db_file_multiblock_read_count to 8K instead#6; Fri, 22 Feb 2008 13:00:00 GMT
- >> can change the parameter db_file_multiblock_read_count to 8K instead
Fnord. Do you know what this parameter means?
Regards, APC
#7; Fri, 22 Feb 2008 13:01:00 GMT