Re: SQL*Net message from Client vs SQL*Net message from Client [idle]
Date: Fri, 3 May 2013 00:26:07 -0500
Message-ID: <CAJOkrQZrn5_WAZ_M29y7HNNaMCaetXOZPsdQ-khwkjCZSU35Qg_at_mail.gmail.com>
Chris,
For a[n exhaustively] detailed explanation, see http://method-r.com/downloads/doc_view/175-method-r-software-white-paper-1-a-first-look-at-using-method-r-workbench-software?tmpl=component&format=raw
Cary Millsap
Method R Corporation
http://method-r.com
On Tue, Apr 16, 2013 at 8:29 AM, <Christopher.Taylor2_at_parallon.net> wrote:
> Have to admit, I think this is the first time I've seen this.
> Anyone know what the [key] differences are (and if it could be impacted by
> the row lock enqueues that occurred?)
>
>
>
> Session Flat Profile
> Event Name % Time Seconds Calls - Time per Call -
> Avg Min Max
> SQL*Net message from client 56.5% 2,924.1636s 32,254 0.0907s
> 0.0001s 5.3796s
> enq: TX - row lock contention 24.7% 1,279.4271s 2,617 0.4889s
> 0.2627s 0.4952s
> SQL*Net message from client [idle] 14.5% 749.2731s 71,415
> 0.0105s 0.0001s 4.3144s
>
>
>
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 03 2013 - 07:26:07 CEST