Oracle-L: RE: any intro statspack docs online?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 May 2003 11:17:38 -0800
Message-ID: <F001.005A0604.20030522111738@fatcity.com>

Raj - Totally agree. Don's book is on my bookshelf. But the poster said he didn't want to read that book. And it sounded to me like he really needed to understand how to use the wait statistics to diagnose a problem.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Thursday, May 22, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L

In addition to Dennis's note ... I am surprised no mention of Don Burleson yet ... he wrote a book on Statspack. He also has some really nice utilities that take advantage of statspack data.

http://www.dba-oracle.com/ <http://www.dba-oracle.com/>

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
Sent: Thursday, May 22, 2003 12:52 PM
To: Multiple recipients of list ORACLE-L

I think that you have two issues:
1. STATSPACK itself, how to install it and the value of it. It sounds like you've mastered that aspect.
2. Understanding what STATSPACK is telling you. This isn't strictly a STATSPACK issue. You mention the wait events. I would phrase the questions: How can I come to understand the Oracle wait events and how to help them diagnose performance problems and tune my applications and database?

For the latter, probably the best introduction is the first couple of chapters of Oracle Performance Tuning 101 by Kirti Deshpande who contributes

to this list. Another recently published book is Oracle Performance Tuning by Christopher Lawson.

There are plenty of Web sites with lots of useful free materials, try: www.hotsos.com
www.oraperf.com
I'm probably missing some important resources, so maybe someone else will post what I've missed.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 22, 2003 10:42 AM
To: Multiple recipients of list ORACLE-L

Ive read the otn stuff and the niemic articles from Oracle mag.

anything else? any articles that give a brief intro that includes installation? Id prefer not to dig into the Burleson book. Im really looking

for something brief.

Not too familiar with tuning wait events, but I 'think' we have some contention problems, and before I create an elaborate routine, Id like to get some metrics.

any quick start guide?
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------