Home » RDBMS Server » Server Administration » Non standard block size ?? at 1 db/instance
Non standard block size ?? at 1 db/instance [message #171108] Mon, 08 May 2006 07:52 Go to next message
mghong
Messages: 27
Registered: February 2006
Location: KL
Junior Member
I reading my ocp book , it mention that when we need to use multi-block size on an instance because we might need to do transportal tablespace ?

But if i don't know in future whethe will i need to migrate 2 different instance together but i already got 2 instance..how can i change the existing single block into multi-block to handle it ??

Will i gain performance issue if i create multi-block in 1 instance ??

Report message to a moderator

Re: Non standard block size ?? at 1 db/instance [message #171112 is a reply to message #171108] Mon, 08 May 2006 08:07 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Mutltiple block sizes are meant for transportable tablespaces.
It does not have any improvements in performance (to be very accurate, it may have negative impact).
A google search took me here
http://www.oracle-base.com/articles/9i/MultipleBlockSizes.php

Report message to a moderator

Previous Topic: network drive
Next Topic: Buffered Commit
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:54:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.