Here is everything you need to know to be able to get your set of Execution Plans and do some basic analysis on them
http://download.oracle.com/docs/cd/B...33/ex_plan.htm