SQL*Net message from Client vs SQL*Net message from Client [idle]
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Apr 2013 08:29:41 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
