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: [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).
