SQL*Net message from Client vs SQL*Net message from Client [idle]

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 16 Apr 2013 08:29:41 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879BEE9BB9_at_NADCWPMSGCMS10.hca.corpad.net>

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

Received on Tue Apr 16 2013 - 15:29:41 CEST