"ORACLE" Spa Performance Analyzer

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.