| When you want to re-tune your database?
It is one of the most important responsibilities of a DBA to tune database after certain changes have made by application/users. Though you may need to tune certain things depending on the user’s feedback but there few things that can you do before anybody start compiling about the performance.
The following is a list of changes to your system that may affect performance of your database.
- When you migrating to a new or upgrade Operating System
- Applying an OS or database level patch
- Upgrading/Migrating a database
- Adding a new application/features
- Running a new batch job
- Adding a significant number of new users
Oracle recommends, that you should gather database performance report before making any changes. Gathering Statspack is one of the best database performance reports. I will recommend gathering Statspack report on monthly basis to know the performance of your databases.
| 
