It's still there as "undocumented" parameter: _hash_join_enabled Igor ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx Sent: Tuesday, September 26, 2006 10:57 AM To: Oracle-L Freelists Subject: Important question about 10G Hi, Do you guys know if the system parameter: HASH_JOIN_ENABLED is no longer available on 10g? Thanks, Isabel Bedoya Gómez Gestión de Tecnología Tel. 2307500 ext: 4077