optimizer_mode,multiple db_block_size [message #65080] |
Tue, 20 April 2004 03:14 |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
I if i put optimizer_mode = choose or other value
how it will effect the perfomance of the database
is there any perfomance gain by setting this parameter
then how can we set multiple block size parameters to different tablespace in
one db then how it will effect the perfomance.what is the perfomance gain if we put the
block size large
thanks in advance
rajesh
|
|
|