Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    50

    Unanswered: oracle hash join settings

    I've read that you can adjust the hash join area size in the init.ora file.

    Is there a way to edit this file from the enterprise manager?

    In our current situation we can connect to the DB using the enterprise manager, but are unable to get to the server itself.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I don't believe that hash_area_size is a dynamic parameter that you can
    change ... without bumping the database.

    If you are using Oracle9i and above, then you can modify the spfile

    alter system set hash_area_size = 123456 scope=spfile;

    you can however modify it on the session level ...

    alter session set hash_area_size = 123456 ;

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •