Leave a comment

January 31, 2013 by rfid

nice one

Alex Zeng's Blog

I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I’d like to summary and share what I learned.

This chapter, Understanding Performance Optimization Methods by Charles Hooper and Randolf Geist, has tons of userful information. I think it can be rewrote to a book. I will just list the some useful information:

The following SQL statement shows currently blocked sessions as well as the blocking sessions:

Monitoring CPU Utilization

Metalink Doc ID 164768.1, “Diagnosing High CPU Utilization”

Metalink Doc ID 301137.1 describes a set of logging scripts named OS Watcher for the Unix and Linux platforms that logs the output of the ps, top, mpstat, iostat, netstat, traceroute, and vmstat utilities on scheduled time intervals.

Metalink Doc ID 433472.1 describes a similar OS Watcher script for the Windows platform that queries the Windows performance data by using the LOGMAN Windows utility.
Oracle Cluster Health…

View original post 1,200 more words