The Oracle SQL Optimizers
http://www.remote-dba.net/t_tuning_sql_optimizers.htm

Oracle SQL hints

http://www.adp-gmbh.ch/ora/sql/hints/index.html