As I mentioned a few weeks ago, IMHO, singling out events to ignore in a system-wide or even session-wide data collection is the wrong thing to do. But you must ignore some events if you first make what I consider to be errors in how you collect your data. If you collect data for only the problem program during only the problem duration, then you should ignore *none* of the events that you see. If you collect the data this way, then *everything* you see will be a component of end-user response time.
Any other data collection method is misleading (and time-wasting) in many cases; one example of such a case is the rather longish example I described. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: 2003 Hotsos Symposium on Oracle® System Performance, February 9–12 Dallas Hotsos Clinic, July 9–11 New York City Hotsos Clinic, July 23–25 Chicago -----Original Message----- Williams Sent: Friday, June 14, 2002 11:38 AM To: Multiple recipients of list ORACLE-L I am trying to break the response time of my system into the wait and service times. I am able to determine the service time by the "CPU used by this session" line in the statspack report. The wait time I am having trouble with. I am working from the 'Yet Another Performance Profiling Method' document. The document lists a number of events that should not be included in the calculation because they are caused by background process waits. I am tuning an 8.1.6 databases and want to be sure I am only counting the appropriate events in this calculation. How can I get the list of events to include for my version of the database (the doc is quite old)? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik 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: Cary Millsap 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).
