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
-------------------------------------------
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博客 ” ，链接：https://blog.itpub.net/12361284/viewspace-548648/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
