OraFAQ Forum: Performance Tuning » impact of this parameter bloom_filter

Home » RDBMS Server » Performance Tuning » impact of this parameter bloom_filter_enabled =false (oracle 10.2.0.2 solaris 10 64 bit)

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

impact of this parameter bloom_filter_enabled =false [message #318711]

Wed, 07 May 2008 13:01

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

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318713 is a reply to message #318711]

Wed, 07 May 2008 13:08

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318719 is a reply to message #318713]

Wed, 07 May 2008 13:38

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

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318824 is a reply to message #318719]

Thu, 08 May 2008 02:17

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

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318839 is a reply to message #318824]

Thu, 08 May 2008 03:12

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318862 is a reply to message #318839]

Thu, 08 May 2008 05:08

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.

Report message to a moderator

Re: impact of this parameter bloom_filter_enabled =false [message #318869 is a reply to message #318862]

Thu, 08 May 2008 05:30

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It was in http://www.orafaq.com/forum/m/317368/102589/#msg_317368

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 19:59:38 CDT 2024