Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 42
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 Go to previous messageGo to next message
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
skumar.dba
Messages: 42
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 Go to previous messageGo to next message
santoshorcl
Messages: 7
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 Go to previous messageGo to next message
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
santoshorcl
Messages: 7
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 Go to previous message
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 01:25:54 CDT 2008

Total time taken to generate the page: 19.20469 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.