RE: statspack interpretations

From: Tatireddy, Shrinivas (MED, Keane) <Shrinivas.Tatireddy_at_med.ge.com>
Date: Thu, 06 Dec 2001 21:37:47 -0800
Message-ID: <F001.003D7216.20011206212519@fatcity.com>

Hi Williams,

                Thnq for responding.

I need to tune the sql statemnet that have the queries using high load %.
and need to look into the other issues too. like instance details etc.

One of the list member Raj sent the documents. I am looking into them. I think they will help for me.

If not , I will go for the books that you suggested.

Thanx and Regards,

Srinivas

-----Original Message-----
Sent: Thursday, December 06, 2001 3:29 PM To: Multiple recipients of list ORACLE-L

Srinivas -

I assume that you have the Oracle Magazine articles. If not, they are available on-line.
I'm confused (easily done). You say that you are tuning SQL statements that statspack has identified and you want more information on statspack report interpretation. To me that is two separate issues.
How statspack identifies the top SQL statement offenders is pretty straightforward. There are good books on SQL statement tuning. I don't have a favorite at the moment, perhaps someone will
I haven't seen many resources on interpreting the rest of the statspack report.
Take a look at Don Burleson's book "Oracle High-Performance Tuning with Statspack". He offers many scripts to present Statspack results in different forms. His main thesis is that Statspack should be run over a period of time and the results reviewed to see what are the critical performance periods for your system. I didn't find his tuning advice as strong, but then I haven't found anyone that discusses server tuning well. There is a new movement to go from examining ratios (like the statspack report) to examining waits.

Hope this helps.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Wednesday, December 05, 2001 9:20 PM To: Multiple recipients of list ORACLE-L

Hi lists,

I have a request to tune the sql statements that are generated in the statspack report. I have a puff document on statspack. But it is of only 7 pages and explains only how to install and run statspack.

Does anybody have any document / link for statspack report intepretations.

if yes, can you please forward.

Thnx and Regards,

Srinivas
--

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

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------