OraFAQ Forum: Performance Tuning » Hidden Parameters .

Home » RDBMS Server » Performance Tuning » Hidden Parameters .

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hidden Parameters . [message #65906]

Thu, 27 January 2005 13:52

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 07 15:03:43 CDT 2025