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

Report message to a moderator

- 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 20:28:41 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.