we should follow the below steps.
- Check alert log, for any errors
- Check for archive log destination/file system full
- Check for database locks
- Check server performance (CPU/IO)
- Check network performance
- Check if statistics is up to date
- If new SQL, then tune SQL (maybe take trace)
- Check if any parameters have been modified recently
- Check if any new updates/changes as been done from the Application team
No comments:
Post a Comment