Home » RDBMS Server » Performance Tuning » Non Standard Block size
Non Standard Block size [message #271853] Wed, 03 October 2007 03:00 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
If I wanna some tables in nonstandard block size like 16 K, then what Should I do?
1.allocate memory to db_16k_cache_size
2.create tablespace of 16K
3.move table with alter table move statement

what else should I do? oracle 10gR2 in solries.
Re: Non Standard Block size [message #271857 is a reply to message #271853] Wed, 03 October 2007 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing, this is fine. You (likely) have to bounce the database after the first step.

Regards
Michel
Re: Non Standard Block size [message #272650 is a reply to message #271857] Fri, 05 October 2007 15:33 Go to previous messageGo to next message
OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico
Junior Member
R You sure?

The first step instructs the DB to reserve only the amount of memory specified to handle blocks of 16k of size.

Guess it's the first object with distinct blocksize, then steps (2) and (3) must be done.

Regards

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:39] by Moderator

Report message to a moderator

Re: Non Standard Block size [message #272678 is a reply to message #272650] Sat, 06 October 2007 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot create a tablespace with XK block size if you don't previously a cache with same block size otherwise you get an error:
ORA-29339: "tablespace block size %s does not match configured block sizes"
 *Cause:  The block size of the tablespace to be plugged in or
          created does not match the block sizes configured in the
          database.
 *Action:Configure the appropriate cache for the block size of this
         tablespace using one of the various (db_2k_cache_size,
         db_4k_cache_size, db_8k_cache_size, db_16k_cache_size,
         db_32K_cache_size) parameters.

SQL> select value from v$parameter where name='db_16k_cache_size';
VALUE
------------------------------------------------------------
0

1 row selected.

SQL> create tablespace t datafile 'C:\T.DBF' size 10m blocksize 16k;
create tablespace t datafile 'C:\T.DBF' size 10m blocksize 16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes

Regards
Michel
Re: Non Standard Block size [message #273245 is a reply to message #272678] Tue, 09 October 2007 12:49 Go to previous messageGo to next message
OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico
Junior Member
I agree with you... I've had a semantic 'worm-hole': I understood that just with step 1 is enough, and you're telling us: "after step 1, maybe bounce, then do step 2 and 3".

Regards

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:38] by Moderator

Report message to a moderator

Re: Non Standard Block size [message #273246 is a reply to message #273245] Tue, 09 October 2007 13:00 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is that.
So, we agree.

Regards
Michel
Previous Topic: Takes long time on sorting.
Next Topic: Performance Not Improved with Hint
Goto Forum:
  


Current Time: Mon Dec 05 14:38:41 CST 2016

Total time taken to generate the page: 0.09678 seconds