Use the statspack to generate the accurate explain plan

Get the snapshot with level=>6
-------------------------------------------
exec statspack.snap(i_snap_level => 6);

exec statspack.snap(i_snap_level => 6);

Generate the report
------------------------------
@?/rdbms/admin/spreport.sql

To find out the "old hash value" of the problem sql statement.

Then run the following script. to generate the report according to the specific Hash Value as input

@?/rdbms/admin/sprepsql.sql

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12361284/viewspace-548648/，如需轉載，請註明出處，否則將追究法律責任。