Pre-completed work by Oracle DBA prior to business system stress testing

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

Before a business system stress test, an Oracle DBA is required to do the work ahead of time:

1. If the Oracle database software is not installed by the DBA, the DBA will review the specification of the database software installation in accordance with the installation documentation of the Oracle database software.

2. Deploy the OSW and configure the boot auto-start script so that OSW can automatically pull up when the OS is restarted

For OSW to start with the OS, see my article:

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

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

3. Adjust the necessary DB parameters: including the following parameters
3.1 Modify the AWR sampling period, such as 10 minutes to sample:

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

3.2 If the archive path size is appropriate for the expected archive generation during the stress test, coordinate the resources to resolve the problem if the archive path is not in sufficient space.

4.--Start the stress test---

5. According to Awr,ash, ADDM report, OSW Report analysis of the problem

Pre-completed work by Oracle DBA prior to business system stress testing