Oracle sql statement tuning

optimizer modes:rule-based,cost-based
optimizer :throughput,response time
optimizer_features_enable=8.1.5
package:dbms_spm(sql plan management)
v$sql_plan
plan_table :explain plan for select * from t; select * from table(dbms_xplan.display);
tkprof 1.trc output.txt