Hi Williams,
Thnq for responding.
1) I need to tune the sql statemnet that have the queries using high
load %.
2) 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.
[EMAIL PROTECTED]
-----Original Message-----
[mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
