ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Use the statspack to generate the accurate explain plan

Use the statspack to generate the accurate explain plan

原创 Linux操作系统 作者:oracle_ace 时间:2009-02-11 11:05:59 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Oracle LOB issue
请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    284
  • 访问量
    795251