Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Performance Monitoring and the Tools You Use

In This Chapter
Evaluating the Current Configuration
Creating a Performance History
The Importance of a Performance History
Tools That Create a Performance History
Operating-System Tools
Database Server Tools
Monitoring Database Server Resources
Monitoring Resources That Impact CPU Utilization
Monitoring Memory Utilization
Monitoring Disk I/O Utilization
Using onstat -g to Monitor I/O Utilization
Using ISA to Monitor I/O Utilization
Using the oncheck Utility to Monitor I/O Utilization
Monitoring Transactions
The onlog Utility
Using the onstat Utility to Monitor Transactions
Using ISA to Monitor Transactions
Monitoring Sessions and Queries
Monitoring Memory Usage for Each Session
Using SET EXPLAIN
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]