Home » RDBMS Server » Performance Tuning » optimizer_mode,multiple db_block_size
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
Previous Topic: Performance Problem with Stored procedure
Next Topic: How to guage query run time
Goto Forum:
  


Current Time: Fri Apr 19 17:25:17 CDT 2024