Before the business system stress test, Oracle dba must complete the work in advance. oracledba

Before the business system stress test, Oracle dba must complete the work in advance. oracledba

This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661

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.

For osw startup with OS startup, please refer to my article:

Http://blog.csdn.net/msdnchina/article/details/38054569: linux

Aix: http://blog.csdn.net/msdnchina/article/details/38054483

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 awr, ash, addm report, and osw report