Top 10 Mistakes Found in Customer Systems.
- BAD Connection Management
- Bad use of cursors and shared pool
- Bad SQL
- Use of Nonstandard initialization parameters.
- Getting Database I/O wrong
- Redo log setup problems
- Serialization of Data blocks in the buffer cache
- Long full-Table scans
- High amount of recursive SQL
- Deployment and migration errors
Common Symptoms :-
- Issues
- Slow response times
- Intermittent "hangs"
- High CPU use
- High Disk I/O
- Instance failure
- Classes of Symptoms
- Errors
- Wait Events
No comments:
Post a Comment