Home » Other » Client Tools » SPA comparison report (Oracle 11g)
SPA comparison report [message #589829] Thu, 11 July 2013 04:43 Go to next message
OracleDBA_beginner
Messages: 5
Registered: July 2013
Junior Member
I ran SPA for SQL workload of around 94 SQLs.

In comparison report that is generated by SPA, there is a metrics "Top 94 SQL Sorted by Absolute Value of Change Impact on the Workload".

In this metrics there is a column "Impact on Workload". This column hold a value in percentage.

Can you please tell me how this is calculated by SPA. What formula is used by SPA to calculate "Impact on Workload".

Thanks in advance,
Vips

Report message to a moderator

Re: SPA comparison report [message #589831 is a reply to message #589829] Thu, 11 July 2013 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is SPA?

Regards
Michel

Report message to a moderator

Re: SPA comparison report [message #589833 is a reply to message #589831] Thu, 11 July 2013 05:16 Go to previous message
OracleDBA_beginner
Messages: 5
Registered: July 2013
Junior Member
SQL Performance Analyzer.
To test the impact of improvement/regression of SQL performance due to upgrade from Oracle 10g to Oracle 11g.

http://www.oracle.com/technetwork/database/manageability/owp-spa-9i-10g-128292.pdf

Regards,
Vips

Report message to a moderator

Previous Topic: Change seperator line of compute SUM or Count
Next Topic: ORA-01034:Oracle not available
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 11:17:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.