Re: How to watch another connection

From: waltervdv <marcus.kuehl_at_t-online.de>
Date: Sat, 21 Jul 2001 21:32:55 GMT
Message-ID: <b2677297.0107120334.3766a306@posting.google.com>

Thank You !

I've tried it :

I posted the following statement in toad (Session DBH(7,4736)):

    delete IK_HO_KONTO_KEY;

It worked for about 5 minutes.

The statement, that was shown by the skript was completly diffrent:

SQL> @show_activity

USERNAME                              SID    SERIAL# PROCESS   STATUS
------------------------------ ---------- ---------- --------- ----------
DBH                                     7       4736 238:237   ACTIVE
SYSTEM                                  8        957 238:237   INACTIVE
SYSTEM                                  9      17840 262:230   INACTIVE
SYSTEM                                 10      64339 263:258   ACTIVE
--------------------

SYSTEM(10,64339) ospid = 263:258 program = Donnerstag 09:16 Donnerstag 09:16 last et = 3 SELECT USERNAME || '(' || SID || ',' || SERIAL# || ') ospid = ' || PROCESS || ' program = ' || PROGRAM USERNAME,TO_CHAR(LOGON_TIME,' Day HH24:MI') LOGON_TIME,TO_CHAR(SYSDATE,' Day HH24:MI') CURRENT_TIME,SQL_ADDRESS,LAST_CALL_ET FROM V$SESSI

---

DBH(7,4736) ospid = 238:237 program =
Donnerstag 08:37 Donnerstag 09:16 last et = 147 select count(1) from "DBH"."IK_HO_MERKMALE_UNIKAT" where "MAKLER_NR" = :1

USERNAME MODULE ACTION CLIENT_INFO

--------------- --------------- --------------- ------------------------------
DBH(7,4736)     T·O·A·D·
SYSTEM(8,957)   T·O·A·D·

SYSTEM(9,17840) T·O·A·D·
SYSTEM(10,64339 01@

)               show_activity.s
                ql

Any ideas abbout that ??

Thank You

Marcus

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9ii08u01apq_at_drn.newsguy.com>...
> In article <b2677297.0107110741.140461b8_at_posting.google.com>,
> marcus.kuehl_at_t-online.de says...
> >
> >Hallo !
> >
> >I have got the folowing problem:
> >
> >I want to get the SQL-Statement, another connection is currently
> >working on. I tried to do this with the following
> >statement:
> >
> >select
> > SID
> >, USERNAME
> >, LOCKWAIT
> >, SQL_ADDRESS
> >, SQL_HASH_VALUE
> >, SQL_TEXT
> >from v$session a
> >, V$SQLTEXT b
> >where sid = xxx
> >and b.ADDRESS = a.SQL_ADDRESS
> >and b.HASH_VALUE = a.SQL_HASH_VALUE
> >order by b.PIECE
> >
> >But the statement I get doesn't seem to be the right one !
> >
> >Can anybody help me ?
> >
> >Thank You
> >
> >Marcus
>
> see
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:767025833873
>
> I have a script there that does this
Received on Sat Jul 21 2001 - 16:32:55 CDT