our database 11g, operating system : linux redhat5 datawareshousing database
our database size 4GB, temporary tablespace size 16GB, we have enough pga_aggregate_target space.
We got error message
ORA-01652:unable to extend temp segment by 128 in tablespace TEMP , to resolve it we have set the parameter hash_join_enabled=false
reference:-
3874749
we cannot tune the query, all queries are dynamic automated queries.
i know, hash_join_enabled is deprecated from oracle 10g onwards.
my question is,
is there any performance problem/issue setting the parameter hash_join_enabled=false for the database for future queries?
looking forward to your valueable inputs.
Regards,
Rajesh Kumar