Re: "Last Call Time" in Enterprise Manager

On Feb 28, 7:43 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> Hi,
>
> on the session details page there is an entry "last call time" in
> category "application" (top right). I was not able to find a
> definition of this measure in Oracle documentation or the web. Our
> current theory is, that this is the complete time from receiving a
> request (end of "SQL*Net message from client" wait) until all data was
> sent back to the user (start of next "SQL*Net message from client"
> wait). Unfortunately we cannot employ tracing at the moment so we
> cannot verify this theory at the moment. Can someone shed some light
> on this?
>
> Bonus question: as it seems to be a known fact that some of the
> metrics that EM presents cannot be trusted (at least not all the
> time), is this value trustworthy according to your experience?
>
> Thanks!
>
> Kind regards
>
> robert

How about enabling a 10046 trace for the session in question and gleaning the SQL statement from the tracefile (tkprof)?

You'll see that its accessing v$session.last_call_et which is in seconds.

-bdbafh Received on Thu Feb 28 2008 - 06:45:49 CST