Stats pack reports..

excellent explanation..

http://www.akadia.com/services/ora_statspack_survival_guide.html


and how to get sqlplan of a sql statement..

SELECT p.plan_table_output
FROM v$session s,table(dbms_xplan.display_cursor(s.sql_id, s.sql_child_number)) p where s.sid = &1