Jobs that must be completed by Oracledba in advance before business system stress testing

Source: Internet
Author: User

Jobs that must be completed by Oracledba in advance before business system stress testing

Before the business system stress test, the Oracle dba must complete the following work in advance:


1. If Oracle database software is not installed by dba, ask dba to follow the Oracle database software installation documentation to check whether the database software installation specifications are met.

2. Deploy the osw and configure the Automatic startup script to automatically pull the osw when the OS is restarted.

3. Adjust necessary db parameters, including the following parameters:

3.1 modify the awr sampling period. For example, change the sampling period to 10 minutes:

Exec dbms_workload_repository.modify_snapshot_settings (interval => 10, retention => 10*24*60 );

3.2 check whether the archive path size is suitable for the expected archive generation during stress testing. If the archive path space is insufficient, coordinate resources to solve the problem.

4. -- start stress testing ---

5. analyze the problem based on the awr, ash, addm report, and osw report.

Related Article

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.