DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 11

Thread: ora-06580 Hash Join out of memory

Threaded View

  1. 09-20-2004, 10:23 AM #3
    ngdh
    ngdh is offline Sort of academic DBA
    Join Date
    May 2002
    Location
    Western Australia
    Posts
    233
    Hi Tamil

    Thanks for the response

    IIRC (at home you see) both are default values.

    i.e. according to the doco, hash_area_size = 2 * sort_area_size therefore 2 Mb and hash_area_multiblock_io_count is system calculated (as per Oracle recommendation).

    Nick

    Woops typo, but then whats 1.8 Gb between friends
    Last edited by ngdh; 09-20-2004 at 10:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width