Home » RDBMS Server » Performance Tuning » Hidden Parameters .
Hidden Parameters . [message #65906] Thu, 27 January 2005 13:52 Go to next message
Narayan Venkat
Messages: 2
Registered: January 2005
Junior Member
I just want to check with some Oracle Experts, the following 4 hidden parameters are applicable to Oracle 8i CBO?

optimizer_mode = first_rows_10;
hash_join_enabled = false;
"_optimizer_sortmerge_join_enabled" = false;
"_optimizer_join_sel_sanity_check" = true;

Any help

- Narayan
Re: Hidden Parameters . [message #65907 is a reply to message #65906] Thu, 27 January 2005 21:23 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Don't use undocumented parameters at will. See here

hth
Previous Topic: DML suddenly taking a long time
Next Topic: Error 942 happened during loading of queue
Goto Forum:
  


Current Time: Tue Feb 27 07:50:51 CST 2024