ITPub博客

首页 > 数据库 > Oracle > SQL Performance Analyzer

SQL Performance Analyzer

原创 Oracle 作者:zhaojienju 时间:2007-11-06 10:35:52 0 删除 编辑

http://www.oracle.com/technology/obe/11gr1_db/manage/spa/spa_guide.htm

1. Set up the env, create database objects and loads the data
Then run some sql on the just created data
Create a SQL Tuning Set for the workload you just ran
2. "Guided Workflow"
2.1 "Create SQL Performance Analyzer Task based on SQL Tuning Set"
2.2 "Replay SQL Tuning Set in initial Env"
2.3 Do some change
2.4 "Replay SQL Tuning Set in Changed Env"
2.5 "Compare"
2.6 "View Report"
2.7 Run "Schedule SQL Tuning Advisor"
2.8 "Compare Replay Trial Against Tuned SQL"

But after I ran the SQL Tuning Advisor, the performance seems degrade....

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11903161/viewspace-980947/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Database Replay 11g
下一篇: Result Cache
请登录后发表评论 登录
全部评论

注册时间:2010-10-05

  • 博文量
    80
  • 访问量
    192580