SQL Performance Analyzer
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博客 ” ，链接：https://blog.itpub.net/11903161/viewspace-980947/ ，如需转载，请注明出处，否则将追究法律责任。
