Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by orrlyfe

  1. orrlyfe

    Receiving Hash join ran out of memory error

    I really hate to be a pain, but I read over your previous posts and went to the init.ora file and could not find anything reffering to HASH. Which parameters do I need to change to alter the hash size permanantly?
  2. orrlyfe

    Receiving Hash join ran out of memory error

    How can I alter the hash size not by session but permanantly?
  3. orrlyfe

    Receiving Hash join ran out of memory error

    Here's the thing...I can select the view in sql*plus but when I try to look at the view in TOAD, I get that message. When I'm altering the session like I did previously, I am altering the my particular session?
  4. orrlyfe

    Receiving Hash join ran out of memory error

    This is now my hash parameters hash_area_size integer 3048576 hash_join_enabled boolean TRUE hash_multiblock_io_count integer 4 and I'm still getting the error message. Should I keep increasing the hash area size?
  5. orrlyfe

    Receiving Hash join ran out of memory error

    These are the hash parameters ... hash_area_size integer 131072 hash_join_enabled boolean TRUE hash_multiblock_io_count integer 4
  6. orrlyfe

    Receiving Hash join ran out of memory error

    Sem, I altered the database as suggested, but I get the same results..The following error has occurred: ORA-06580: Hash Join ran out of memory while keeping large rows in memory Details: ORA-06580: Hash Join ran out of memory while keeping large rows in memory any thoughts?
  7. orrlyfe

    Receiving Hash join ran out of memory error

    What is the syntax for this?
  8. orrlyfe

    Receiving Hash join ran out of memory error

    Hi, When I try to access a view, I receive the following error..."The following error has occurred: ORA-06580: Hash Join ran out of memory while keeping large rows in memory" I went out on the net and for research and found that I need to increase the hash size. How do I do this?
See more

Part and Inventory Search

Back
Top