Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

Every effort has been made to provide you with a list of all the material we used as references for this book. Any omission from this list is purely unintentional.

Chapter 1

• Kolk, A., S. Yamaguchi, and J. Viscusi. ‚“Yet Another Performance Profiling Method (Or YAPP-Method). ‚½ http://oraperf.veritas.com or http://www.miracleas.dk.

• Vaidyanatha, G., K. Deshpande, and J. Kostalec, Jr. Oracle Performance Tuning 101 . Oracle Press/Osborne, 2001. http://www.osborne.com.

Chapter 2

• Millsap, C. ‚“How to Activate Extended SQL Trace, ‚½ White Paper, Hotsos Enterprises, Ltd., 2003. http://www.hotsos.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1 (10.1), http://tahiti.oracle.com.

• Oracle Corporation, Oracle9 i Documentation, Release 2 (9.2), http://tahiti.oracle.com.

• Shallahamer, C. ‚“Direct Contention Identification Using Oracle ‚ s Session Wait Tables, ‚½ White Paper, OraPub Inc., 1996. http://www.orapub.com.

• Vaidyanatha, G., K. Deshpande, and J. Kostalec, Jr. Oracle Performance Tuning 101 . Oracle Press/Osborne, 2001. http://www.osborne.com.

Chapter 3

• Adams, S. ‚“Oracle Performance Tuning Tips. ‚½ http://www.ixora.com.au/tips.

• Holt, J. ‚“Why Are Oracle ‚ s Read Events ‚Named Backwards? ‚ ‚½ White Paper, Hotsos, 2000. http://www.hotsos.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1(10.1), http://tahiti.oracle.com.

• Oracle Corporation, Oracle9 i Documentation, Release 2 (9.2), http://tahiti.oracle.com.

• Vaidyanatha, G., K. Deshpande, and J. Kostalec, Jr. Oracle Performance Tuning 101 . Oracle Press/Osborne, 2001. http://www.osborne.com.

• Oracle Corporation, Oracle8 i Database Documentation, Release 2, http://tahiti.oracle.com.

Chapter 4

• Shee, R. ‚“10046 Alternatives, ‚½ proceedings of International Oracle User Group Conference, 2003. http://www.ioug.org.

Chapter 5

• Shee, R. ‚“If Your Memory Serves You Right, ‚½ proceedings of International Oracle User Group Conference, 2004. http://www.ioug.org.

• Oracle Corporation, Metalink note #131530.1, http:// metalink .oracle.com.

• Oracle Corporation, Oracle8 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle9 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1(10.1), http://tahiti.oracle.com.

Chapter 6

• Oracle Corporation, Metalink notes #30804.1, #62143.1, #131557.1, #34405.1. http://metalink.oracle.com.

• Oracle Corporation, Oracle8 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle9 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1(10.1), http://tahiti.oracle.com.

• Adams, S. Oracle8 i Internal Services for Waits, Latches, Locks, and Memory O ‚ Reilly & Associates, Inc., 1999. http://www.oreilly.com/.

Chapter 7

• Adams, S. ‚“Over Committed. ‚½ http://www.ixora.com.au/newsletter/2001_09.htm.

• Morle, J. ‚“Solid State Disks in an Oracle Environment. ‚½ http://www.oaktable.net/fullArticle.jsp?id=5.

• Oracle Corporation, Oracle8 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle9 i Database Documentation, Release 2, http://tahiti.oracle.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1(10.1), http://tahiti.oracle.com.

Chapter 8

• Pfister, G. In Search of Clusters , Prentice Hall, 1998. http://www.prenhall.com.

• Oracle Corporation, Metalink forum and support notes, http://metalink.oracle.com.

• Adams, S. ‚“Cache Layer Block Types. ‚½ http://www.ixora.com.au/notes/cache_block_types.htm.

Chapter 9

• Hailey, K. ‚“Performance Tuning in Oracle 10 g , ‚½ proceedings of the Hotsos Symposium, 2004. http://www.hotsos.com.

• Oracle Corporation, Oracle Database 10 g Documentation, Release 1 (10.1), http://tahiti.oracle.com.

• Wood, G., K. Hailey. ‚“The Self-Managing Database: Automatic Performance Diagnostics, ‚½ White Paper, Oracle Corporation, 2003. http://otn.oracle.com/products/manageability/database/pdf/twp03/TWP_manage_automatic_performance_diagnosis.pdf.

Appendix A

• Gazi Unal, D. ‚“iOraDumpReader. ‚½ http://www.ubtools.com.

• Oracle Corporation, Metalink forum and support notes, http://metalink.oracle.com.

Appendix B

• Oracle Corporation, Oracle Database 10 g Documentation, http://otn.oracle.com.

Appendix C

• Gazi Unal, D. ‚“Microstate Response-Time Performance Profiling (MRPP). ‚½ http://www.ubtools.com.

• Oracle Corporation, Metalink forum and support notes, http://metalink.oracle.com.

Appendix D

• Hailey, K. ‚“SGA Access. ‚½ http://oraperf. sourceforge .net/.

• Gopalakrishnan, K. ‚“Oracle9 i Memory Structures (X$views), ‚½ Oracle Internals Magazine , September 2002.