"ORACLE" Spa Performance Analyzer

The main role of spa: The main test is the impact of changes in the system environment including operating system changes, database upgrades, etc. on SQL performance. Minimize the impact of changes in the system environment on the business.

Analysis process: 1, get SQL access to tunning SET=>2, prepare test environment and transfer tunning SET=>3, implement system Change =>4, create spa task=>5, spa analysis before and after the change of system change report = >6, based on the comparison results of the SQL statement optimization =>7, in order to verify the optimization results re-analysis report and system changes before the comparison

EM Create tunning Set

Set up test system

There are many ways to prepare for the test environment phase, with Rman's duplicate command, transport table space, and data pump, which Oracle recommends using Rman to restore previous backups to the test environment.

There are four main ways to create a spa task:

1. Parameter Change mode

2, Optimizer statistical analysis method

3, Integrated machine simulation

4, using GUID guidance method

Spa Task in EM

"ORACLE" Spa Performance Analyzer