Using Database Performance Data
Possible causes of database performance problems include a poor design of the data model or a poorly written database application program. Programs should first be tested heavily in a development environment before going into production. However, resolving design and programming problems are beyond the scope of this book. You may want to consult documentation from the database vendors, such as Oracle's Oracle Server Concepts, to get more information on these topics.
Additional causes of performance problems can be an inappropriate system configuration or an ineffective use of database resources. To identify these types of situations, you need to collect performance statistics, using the metrics and tools discussed ...
Get UNIX® Fault Management: A Guide for System Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
