The cool dragonfly book thoroughly describes the case of optimizer failure you mention. I generally advise the book to all database programmers whether they use Oracle or not.
Comment on Re: Where the advice to use DBI bind parameters can go wrong (long)