Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: any intro statspack docs online?

RE: any intro statspack docs online?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 May 2003 08:52:12 -0800
Message-ID: <F001.005A0157.20030522085212@fatcity.com>


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
--

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
---------------------------------------------------------------------
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). Received on Thu May 22 2003 - 11:52:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US