Oracle Troubleshooting

Hangs & process/instance troubleshooting

Metalink Notes:

175982.1 – ORA-600 Error Lookup Categories
This is an extremely useful reference of Oracle kernel module names (kernel function name prefixes) which allows to diagnose where in kernel code a process crashed or is hung or stuck.

61552.1 – Diagnosing Database Hanging Issues
110888.1 – How to Trace Unix System Calls
1812.1 – TECH: Getting a Stack Trace from a CORE file
175006.1 – Steps to generate HANGANALYZE trace files
121779.1 – Taking Systemstate Dumps when You cannot Connect to Oracle
215858.1 – Interpreting HANGANALYZE trace files to diagnose hanging and performance problems
135714.1 – Script to Collect RAC Diagnostic Information (racdiag.sql)
459694.1 – Procwatcher: Script to Monitor and Examine Oracle and CRS Processes

Oracle Performance Tuning

Tim Gorman’s StatsPack Delta Views (and other useful scripts)

Oracle Network Troubleshooting

Metalink Notes:

779226.1 – Troubleshooting Oracle Net
156485.1 – Examining Oracle Net, Net8, SQL*Net Trace Files

Tools:

Wireshark – Network Protocol Analyzer

Oracle Server Configuration Good Practices

Manageability

Unleashing Oracle Services: A Comprehensive Review of “Services” in Oracle Databases (by Jeremy Schneider)

Oracle Application Development & Design Good Practices

Understanding Oracle – for developers

Making Friends with the Oracle Database (by Cary Millsap)

Optimizer statistics management

Managing Statistics for Optimal Query Performance (by Karen Morton)
Oracle Real World Performance team’s take on optimizer statistics (by Greg Rahn and the Real World Performance team)
CBO – A Configuration Roadmap (by Christian Antognini)

Note that if you read through above 3 documents you see that they all are making pretty much the same points, occasionally from different viewpoints.

Unix Commands

Rosetta Stone for Unix – LOTS of Unix commands (for many different Unixes)

Unix Performance

Solaris Metrics by Brendan Gregg – Click on the “Disk Utilization By Process” link for some useful tools and internals info for Solaris IO performance troubleshooting
Understanding Linux Virtual Memory – by RedHat