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: 7880
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: Sun Sep 20 22:23:54 CDT 2020