For instance - this join: "FROM GV$SESSION S, GV$SESS_IO si" in Toad takes 84 secs with NL join and 3secs with a hash join.
Could you send plan from sqlplus and toad respectively.
And then give real execution plan.
Please show here or on pm by mail.
Seems more than interesting