Originally posted by manodba
Is there any tool/procedure that would capture and save SQL execution plans?
Plans are stored in the plan_table. As long as it's not defined as a temporary table, it is there for posterity until someone deletes it.

As for looking at plans, you can use 1) sqlplus and format it yourself, 2) dbms_xplan 3) myriad GUI tools