Performance Tuning

Interesting Links:

11gR2 RAC – run ADDM report
http://www.oracle-class.com/?p=2014

Systematic Latch Contention Troubleshooting in Oracle By Tanel Poder
http://tech.e2sn.com/oracle/troubleshooting/latch-contention-troubleshooting
http://www.cernatis.com/index.php?option=com_content&view=article&id=92
http://orapsdba.wordpress.com/2011/06/21/another-latchcache-buffer-chains-troubleshooting

Solaris Dynamic Tracing Guide
How to Use Oracle® Solaris DTrace from Oracle Solaris and OpenSolaris System
Solaris Dynamic Tracing Guide
DTrace User Guide
DTrace Topics Guide

MOS Article:

How To Understand AWR Report / Statspack Report [ID 842884.1]

How Btree Indexes Are Maintained [ID 30405.1]

Various Aspects of Fragmentation [ID 186826.1]

How to Tune Log File Sync? [ID 857576.1]

Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) [ID 1064487.1]

Tracing Parallel Execution with _px_trace. Part I [ID 444164.1]

How to Use _PX_TRACE to Check Whether Parallelism is Used [ID 400886.1]

How to Tell if the IO of the Database is Slow [ID 1275596.1]

OS Watcher User Guide [ID 301137.1]

Advertisements

4 thoughts on “Performance Tuning”

  1. Hi Shrikant,

    some questions for i need a help.

    1. if 100 queries are running, all the queris are performing sorts how will you improve the performance?

  2. Very nice post. I absolutely appreciate this website. Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s