Home » RDBMS Server » Performance Tuning » impact of this parameter bloom_filter_enabled =false (oracle 10.2.0.2 solaris 10 64 bit)
impact of this parameter bloom_filter_enabled =false [message #318711] Wed, 07 May 2008 13:01 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Hi,

i got a problem in my database ORA-600 error in the past, then i was contact to ORACLE PEOPLE regarding this problem. they suggest me to set this parameter to false

_bloom_filter_enabled =false

i want to know what was the impact of this parameter.
is it good or bad.
how do i analyze it.

can any one help me or send some document on this parameter for investigation?

Thsnks
kumar
Re: impact of this parameter bloom_filter_enabled =false [message #318713 is a reply to message #318711] Wed, 07 May 2008 13:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i want to know what was the impact of this parameter.

Why didn't and don't you ask this question to these ORACLE PEOPLE?

Quote:
can any one help me or send some document on this parameter for investigation?

There is no documentation on hidden parameters (sometimes on Metalink but if you raised a SR you already know it).

Regards
Michel
Re: impact of this parameter bloom_filter_enabled =false [message #318719 is a reply to message #318713] Wed, 07 May 2008 13:38 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Thanks Michel,

thank you very much for quick response. i updated SR with this question. i hope that some one might be faced this problem. so i want to share their experience in this case.


Thanks,
Kumar
Re: impact of this parameter bloom_filter_enabled =false [message #318824 is a reply to message #318719] Thu, 08 May 2008 02:17 Go to previous messageGo to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Hi Kumar,
It is for some PQ operations.
for more info please see

http://en.wikipedia.org/wiki/Bloom_filter
Re: impact of this parameter bloom_filter_enabled =false [message #318839 is a reply to message #318824] Thu, 08 May 2008 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Kumar already knows this link, it has been posted to him a couple of days ago.
And this does not answer the question of its impact on database/instance.

Regards
Michel
Re: impact of this parameter bloom_filter_enabled =false [message #318862 is a reply to message #318839] Thu, 08 May 2008 05:08 Go to previous messageGo to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Kumar,
If u posts entire ORA-00600 error then only I am able to tell u what is impact of setting this parameter in your case because there are several situations when this parameter is suggested.

Michel,
I didn't find any post regarding this topic hence I suggest to read this web site. Actually Oracle using this logic to work with database in parallel mode. my intention was make him aware with bloom_filter is what.
Re: impact of this parameter bloom_filter_enabled =false [message #318869 is a reply to message #318862] Thu, 08 May 2008 05:30 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It was in http://www.orafaq.com/forum/m/317368/102589/#msg_317368

Regards
Michel
Previous Topic: Importance of index unique scan (cost=0)
Next Topic: why oracle choose NL in this case?
Goto Forum:
  


Current Time: Tue Dec 03 15:21:10 CST 2024