RE: How to make a session active with wait event of 'sql*net message FROM client'?
- From: "Roberts, David (GSD - UK)" <david.h.roberts@xxxxxxxxxx>
- To: <fmhabash@xxxxxxxxx>, "Oracle-L Group" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Jun 2009 12:33:06 +0100
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@xxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
