RE: How to make a session active with wait event of 'sql*net message FROM client'?

From: Roberts, David (GSD - UK) <"Roberts,>
Date: Fri, 19 Jun 2009 12:33:06 +0100
Message-ID: <257FBD236721014D851163D8B68CAB1E049C3A31_at_UK-EX012.groupinfra.com>

If I understand correctly, the scenario can be duplicated by simply going into SQL*Plus on one session and entering the following:

SQL> set pause on
SQL> select * from all_catalog;

In another session, we can check the status:

SQL> select status from v$session
  2 where sid = 98;

STATUS

---

ACTIVE SQL> select * from v$session_event
  2 where sid = 98;

SID EVENT                         T_WAITS T_TIMEOUTS TIME_WAITED

AVERAGE_WAIT MAX_WAIT
--- ----------------------------- ------- ---------- -----------
------------ --------

 98 log file sync                       1          0           0
0        0
 98 SQL*Net message to client          22          0           0
0        0
 98 SQL*Net message from client        21          0       30389
1447.0952    26161
 98 SQL*Net break/reset to client       2          0           4
2        4

SQL> /

SID EVENT                         T_WAITS T_TIMEOUTS TIME_WAITED

AVERAGE_WAIT MAX_WAIT
--- ----------------------------- ------- ---------- -----------

---

 98 log file sync                       1          0           0
0        0
 98 SQL*Net message to client          24          0           0
0        0
 98 SQL*Net message from client        23          0       31176
1355.4783    26161
 98 SQL*Net break/reset to client       2          0           4
2        4

Is this what you were describing?

David Roberts
Senior Developer

---

Logica - Releasing your potential
2 Trinity Park
Bickenhill lane
Birmingham
B37 7ES
United Kingdom

T:  +44 12 1787 0021 (direct)
M: +44 79 2193 2223 (out of hours support)
E:  david.h.roberts_at_logica.com

www.logica.com  

Logica UK Limited
Registered in England and Wales (registered number 947968) Registered office: 250 Brook Drive, Green Park, Reading RG2 6UA, United Kingdom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fmhabash Sent: 17 June 2009 21:18
To: Oracle-L Group
Subject: How to make a session active with wait event of 'sql*net message FROM client'?

Hi all, am trying to duplicate a real-life situation where a db had several sessions with status of active and wait event of sq*net message FROM client.
So far, am not able to do that. I tried a session with uncommitted DML or waiting on a substitution variable, but both show as inactive.

How can this status/event combination be reproduced?  

---

Thank You.

--
http://www.freelists.org/webpage/oracle-l




Please help Logica to respect the environment by not printing this email  / Pour contribuer comme Logica au respect de l'environnement, merci de ne pas imprimer ce mail /  Bitte drucken Sie diese Nachricht nicht aus und helfen Sie so Logica dabei die Umwelt zu schuetzen  /  Por favor ajude a Logica a respeitar o ambiente nao imprimindo este correio electronico.



This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 19 2009 - 06:33:06 CDT