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>


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
---------- ------------ ------------- ------------- ---------------------------- -------------------------------------------------------

      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;
      5428 2965         b6qv8f7zwqz0d b6qv8f7zwqz0d SQL*Net message from client  begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); 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-l
Received on Fri Aug 08 2008 - 14:03:59 CDT

Original text of this message