Erik, The doc may be old but the method still stands ;-) You can dice and slice the wait events in anyway you want. But basically what you are interested in is the wait events for the foreground (system wide), so you do some thing like this:
System wide: v$system_event - (v$session_event for the background processes). Then you should consider a couple of events like: SQL*net message from client pipe get etc. Session level The only thing to consider here is the wait events listed before. Now we have the big BUT: What about waits that are not accounted for ? Like OS waits (waiting for a memory page, waiting for CPU, etc). How can you see them ? And how do know where the problem is ? So you will get a level of detail that will contain errors/holes. And as long as the holes are not big enough, it doesn't matter. But what if you are really running out of CPU ? The hole will get bigger and your wait events don't really matter that much. I will make a list of idle events available through oraperf.com. That list is used by the report generator also. Anjo. Erik Williams wrote: > 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: Anjo Kolk 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).
