Tuning development and production systems
Oracle’s top down approach for development systems
1. Tune data design
2. Tune application design
3. Tune memory allocation
4. Tune I/O and physical structures
5. Tune resource contention
6. Tune for underlying platform (OS)
1. Define problem clearly and formulate a tuning goal
2. Examine host system and gather statistics
3. Compare common problems with Oracle’s documentation
4. Get a conceptual picture of what went wrong from gathers statistics
5. Identify changes to be done and implement those changes
6. Check whether tuning objective has been met or not, repeat steps until tuning is complete.
No comments:
Post a Comment