var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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 ;