Issue Alter session for user

[connolp]

I need to disable Hash Joins with an alter session command when users log in to BO, how can this be done? Any input would be welcomed. Cheers Pete.

 

[jimbopalmer]

I think there is a hint not to use Hash Joins, I use hints in front of all my BO objects so I get cost based optimizer in a rule based system. Something like /*+ no_hash */

 

[connolp]

Thanks Jim, the problem with this approach is that our end-users are not very IT literate & I would rather do it behind the scenes to hide any additional complexity. The RunInit or ConnectInit parameters sound useful but I can't see a decent explanation in any of my documentation.

 

[jimbopalmer]

Sorry I may have been unclear, I added the hint to each object as I defined it, so the users never have to deal with it. I love everyone til they prove otherwise, sadly some prove otherwise SO quickly