Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Response time analysis and TKPROF
Well ,
Depending on what you want:
1) The only way to see 'response times' on SQL statements is to use 10046, but
that adds overhead. There are third party tools out there that will do for you
without the
10046 trace.
2) v$sesstat will show the service component (cpu) on the session level, not on the SQL statement level.
3) v$session_wait is close to useless ;-) It will tell you what a session is waiting on right now or what the last wait of a session was. That is not enough. You need v$session_event
Again that is on the session level and not on the SQL statement level. See my comments at 1) about that.
If you response times on the SQL statement level, you need to use 10046 or a third party tool. On session level use v$sesstat and v$session_event. On instance level use v$sysstat and v$system_event. Read more on how to do that in the YAPP paper.
Anjo.
Greg Moore wrote:
> > But this is all on the server side, so in Oracle ......
>
> to get what I apparently want it would be most accurate to use v$sesstat and
> v$session_wait ?
>
> - Greg
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
> INET: sqlgreg_at_pacbell.net
>
> 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: Anjo Kolk INET: anjo_at_oraperf.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).Received on Sun May 05 2002 - 05:13:18 CDT