First it seems like you want to understand the report. The report does have some comments on the top of the page, what to expect. However, if you can buy the book that Dennis suggested, you will get additional information on how to interpret the report.
The book also provides many scripts that generate reports as well as comments in the report. I found the book and especially the scripts real worth while. As far as writing you own query, you could use the scripts provided with Statspack and the book as a baseline and get your own canned reports. I have used scripts that I have collected over many years. Statspack collects relevant data, organizes data in a nice way and stores the data for you. The scripts and information in the book give you additional stuff that is not covered in the book. I hope this helps you in making the decision. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Reddy - I assume that you mean that you ran the statsrep.sql and > printed the > report. Is your question about interpreting this report? There is a > good > series of articles at > http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html > > Or is your question how to write your own queries? If that is the > question, > I would recommend that you invest in the book "Oracle > High-Performance > Tuning with STATSPACK" by Don Burleson, available at your local > bookstore. > Don offers some articles on-line at > http://www.dba-oracle.com/articles.htm > > Let me know if that is the information that you want. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Tuesday, March 26, 2002 3:00 PM > To: Multiple recipients of list ORACLE-L > > > Hello ALL, > I have set up the statspack on Oracle 8.1.7 and just now I also got > the > REPORT , but poor me unable to understand that . Can anybody help me > out in > this ... Well I know www.oraperf.com will do it for me by sending a > report , > but I want to do it myself by writing some queries ... would anybody > help me > with some white paper. > > Thanks In advance, > Madhu > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reddy, Madhusudana > 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). ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards� http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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).
