Performance problems occur when a task takes longer to perform than the time allowed and uses excessive resources. If the database seems to be running very slow or a command seems to take a long time to respond, an experienced DBA can try to diagnose this runtime problem and fix it.
Performance tuning is a complex process requiring collaborative efforts from DBA and Application team. Thus, to make the tuning exercise efficient and minimize the effort required, the performance issues should be clearly defined. The more precise and detailed you can answer below questions, the easier and faster the tuning process will be for a DBA. Read more »