SQL*Net message from client with not null sql_id
From: Ajay Thotangare <ajayoraclel_at_yahoo.com>
Date: Fri, 8 Aug 2008 12:03:59 -0700 (PDT)
Message-ID: <197241.8948.qm@web57508.mail.re1.yahoo.com>
5443 1058 b6qv8f7zwqz0d b6qv8f7zwqz0d SQL*Net message from client begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end;
Is this normal ?
my DB is 10.2.0.3 on HP-UX
appreciate your inputs on this
--Ajay
Date: Fri, 8 Aug 2008 12:03:59 -0700 (PDT)
Message-ID: <197241.8948.qm@web57508.mail.re1.yahoo.com>
Hi List,
I need help on understanding the below scenerio.
When I query from V$session for particular set of users. I see they are waiting on event "SQL*Net message from client". Which means session is waiting for some work but at the same time it also shows sql_id and prev_sql_id in v$session. How is this possible ? Is the session really waiting or doing some work.
I check the sql_text and it shows as below
SID SPID SQL_ID PREV_SQL_ID EVENT SQL_TEXT ---------- ------------ ------------- ------------- ---------------------------- -------------------------------------------------------5428 2965 b6qv8f7zwqz0d b6qv8f7zwqz0d SQL*Net message from client begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end;
2669 2679 4vngfzppsahts 4vngfzppsahts SQL*Net message from client begin :1 := JAVA_XA.xa_prepare_new (:2,:3,:4); end;
2711 25730 b6qv8f7zwqz0d b6qv8f7zwqz0d SQL*Net message from client begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end;
5426 18006 4vngfzppsahts 4vngfzppsahts SQL*Net message from client begin :1 := JAVA_XA.xa_prepare_new (:2,:3,:4); end;
5443 1058 b6qv8f7zwqz0d b6qv8f7zwqz0d SQL*Net message from client begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end;
Is this normal ?
my DB is 10.2.0.3 on HP-UX
appreciate your inputs on this
--Ajay
to your favorites. Make Yahoo! your homepage.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 08 2008 - 14:03:59 CDT