Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


hash_join_enabled=true parameter not found.

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
There is a initialization parameter

"hash_join_enabled=true" which i am trying to modify but I am not able to locate it in the first place using the oracle enterprise manager.

I have found "open_cursors" and others.

But not the one I mention. Can I create this parameter using the enterprise manager. If anyone has some clue?

Question by:Osloiite
  • 2
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 37018068
Did you check the 10g docs?

That parameter is obsolete in 10g.  Why do you need to set it?

It is hidden but I wouldn't set it unless told to do so by Support.
LVL 74

Expert Comment

ID: 37018098
as noted in previous question,  "hash_area_size" is probably what you are looking for.

If you don't get hash joins it's very likely you haven't allocated enough hash space

Author Comment

ID: 37022980
Hi all

When I alter the hash_join_enabled = true to set it to true, it gives an error illegal alter system.

Any clues how to solve the problem?

@slighttwv :in 10g hash join enabled parameter exists as I checked in an online support forum

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37023953
PLEASE do not close questions that 'do not work' and open duplicates.

Even though you closed this out, did you check the DOCS not a forum:


Initialization Parameters Obsolete in Oracle Database 10g Release 1 (10.1)

 An attempt to start a database using one or more obsolete initialization parameters will succeed, but a warning is returned and recorded in the alert log.


I mentioned that it is not HIDDEN.  This means is starts with an underscore and SHOULD ONLY BE SET when told to do so by SUPPORT.  I won't provide the syntax to set it here.  If Support told you to set it, they would provide the syntax.

Again, why are you wanting to set this?  Just because someone told you to isn't a good enough reason.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question