Re: "Last Call Time" in Enterprise Manager

On 28 Feb., 14:51, Steve Howard <stevedhow...@xxxxxxxxx> wrote:
On Feb 28, 7:43 am, Robert Klemme <shortcut...@xxxxxxxxxxxxxx> wrote:

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?

I honestly don't know, but my first guess would be that it's the same
as the LAST_CALL_ET column in GV$SESSION?

Thanks! You mean:

LAST_CALL_ET NUMBER

If the session STATUS is currently ACTIVE, then the value represents
the elapsed time in seconds since the session has become active.

If the session STATUS is currently INACTIVE, then the value represents
the elapsed time in seconds since the session has become inactive.

Could be - and it would explain the unusual high values. I'd say the
naming then is a bit misleading...

Btw, I just notice I forgot version info: 10.2.0.2.0 on HP-UX B.11.11
U (64).

Kind regards

robert
.

Relevant Pages

  • NHRA: Reading: Whit Bazemore Saturday summary
    ... despite a few mechanical problems in the pits. ... Bazemore posted a 5.152-second elapsed time at 282.01 mph in the first ... session on Friday, then surpassed that with his best qualifying pass Friday ...
    (rec.autos.sport.info)
  • Re: long running select min(timestamp) query
    ... tell if oracle IS busy with a crapped out session, ... Oracle used an INDEX FULL SCAN to find the ... and Buffers = 3), rather than having to scan all of the blocks in the ... other than the elapsed time decreasing. ...
    (comp.databases.oracle.server)
  • Re: timer function
    ... Why don't you just store the DateTime directly in to Session? ... //get the elapsed time ... > Dim dtm As DateTime ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to count time of the session
    ... > Marcos wrote: ... >> I need to count the time of during of session of users. ... You can compute and report the elapsed time in the "footer" section (or ...
    (alt.php)
  • Re: [PHP] Re: a question on session ID and security
    ... hash key" to the client when it doesn't need it? ... But by doing that you're exposing how your app validates the authentication key, leaving it open to being transferred to another machine. ... tutorial on PHP session security is helpful. ...
    (php.general)