Re: "Last Call Time" in Enterprise Manager
- From: bdbafh <bdbafh@xxxxxxxxx>
- Date: Thu, 28 Feb 2008 04:45:49 -0800 (PST)
On Feb 28, 7:43 am, Robert Klemme <shortcut...@xxxxxxxxxxxxxx> 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
.
- References:
- "Last Call Time" in Enterprise Manager
- From: Robert Klemme
- "Last Call Time" in Enterprise Manager
- Prev by Date: "Last Call Time" in Enterprise Manager
- Next by Date: Re: How to Improve Materialized View Refresh & Query Performance ?
- Previous by thread: "Last Call Time" in Enterprise Manager
- Next by thread: Re: "Last Call Time" in Enterprise Manager
- Index(es):
Relevant Pages
|
