Home » SQL & PL/SQL » 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: 2
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
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: 59408
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is SPA?

Regards
Michel
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: 2
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
Previous Topic: Change seperator line of compute SUM or Count
Next Topic: ORA-01034:Oracle not available
Goto Forum:
  


Current Time: Tue Oct 21 12:36:29 CDT 2014

Total time taken to generate the page: 0.11496 seconds