hash_join_enabled=true parameter not found.

Posted on 2011-10-24
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
    LVL 76

    Accepted Solution

    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 73

    Expert Comment

    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

    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 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now