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

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.