| SQL PERFORMANCE ANALYZER [message #400125] |
Sun, 26 April 2009 05:48  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi,
I was reading documentation on Oracle 11g where I was a little confused about
1) Database Replay
2) SQL PERFORMANCE ANALYZER
What I read was both are used to test the efficiency of the database before and after any change and the change may include
database upgrade,migrations , operating system changes and any other database change.
Can somebody clear my confusion this please.
|
|
|
|
| Re: SQL PERFORMANCE ANALYZER [message #400134 is a reply to message #400125] |
Sun, 26 April 2009 08:09  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/intro.htm#CEGGGAIC
Nothing to get confused.
Just read the first few lines in each topic.
Database Replay as the name implies will capture the workload and replay / recreate the scenario in another database.
SQL Performance analyzer will allow you to induce (and test) changes to the sql/environment in controlled manner without affecting the whole database.
Say, in a live production system, you want to see how changing a certain init parameter( restrictions apply), you can compare
the output/plans/stats before and after the using SQL Performance Analyzer.
In terms of usage, there could be some overlap (and there are many other tools in Oracle that could do the same).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
