Books for you

For more details about the vast topic of Oracle performance,
refer to the tuning books mentioned in Appendix B.
A Final Note on Performance Basics
Performance has real-world business implications. Whenever you attempt to address
performance problems, you must make sure to carefully monitor the areas that you
are attempting to improve, both before and after your changes. Important baseline
data gathered by the AWR includes application, database, operating system, disk I/O,
and network statistics.
160 | Chapter 7: Oracle Performance
You should use a systematic approach to both discovering the source of a performance
problem and implementing the appropriate solution. This approach calls for
establishing baselines for resource usage and response time before making any
changes, and only making a small group of changes before reexamining the performance
in the changed environment. It might be tempting to simply try to fix a
problem without taking a measured approach, but this tactic will usually lead to
additional problems down the road.


Pages:
336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360