Check List before DB is ready for Performance Test
1) Init Parameters properly configured or not.
2) sessions Monitoring script.
3) OS Watchers running or not.
4) AWR Snapshots configured or not.
5) CPU’s Count.
6) SGA Size
7) OEM (Grid)
8) Keep handy Monitoring Scripts (Check Load Test Monitoring in this Site)
9) Services configured properly or not if it’s RAC.
10) DB Control if Grid is not configured
11) Check Redo Log Size properly configured or not.
12) FRA Clean up/Archive Destination
13) Flashback retention.
14) Tail for alert logs for errors.
2) sessions Monitoring script.
3) OS Watchers running or not.
4) AWR Snapshots configured or not.
5) CPU’s Count.
6) SGA Size
7) OEM (Grid)
8) Keep handy Monitoring Scripts (Check Load Test Monitoring in this Site)
9) Services configured properly or not if it’s RAC.
10) DB Control if Grid is not configured
11) Check Redo Log Size properly configured or not.
12) FRA Clean up/Archive Destination
13) Flashback retention.
14) Tail for alert logs for errors.
Note: Please test scripts in Non Prod before trying in Production.
Loading...
Roja
Nice information
Harika
Good Article use full information
Nikitha
Good information