v$session question

From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 29 Jan 2009 16:31:08 -0600
Message-ID: <effc058d0901291431h70e88b5eoaf200203ff09b30e_at_mail.gmail.com>

Listers,

When I kill a session and the status shows as "KILLED" in v$session, I assumed that the rollback is taking place. I am not sure what is happening here:

SYS_at_PROD> select sid,saddr, serial#, client_info, to_char(logon_time,'DD-MON-YY HH:MIam'), status   2 from v$session
  3 where client_info like '%USER%'

SYS_at_PROD> /

more..

       SID SADDR SERIAL# CLIENT_INFO
---------- ---------------- ----------

---

TO_CHAR(LOGON_TIME,'DD-MON-YY
STATUS

---

---

       942 C0000000B99775F8 30069 USER,USER,A147946,,psqed.exe, 29-JAN-09 02:48pm
KILLED       1013 C0000000BC9B5C58 4411 USER,USER,A147946,,PSIDE.EXE, 29-JAN-09 03:19pm
KILLED

SYS_at_PROD>
SYS_at_PROD>
SYS_at_PROD> select addr, START_TIME, SES_ADDR , USED_UBLK, USED_UREC

  2 from v$transaction
  3 where ses_addr in ('C0000000B99775F8','C0000000BC9B5C58');

no rows selected

SYS_at_PROD> select count(*) from v$transaction   2
SYS_at_PROD> /
more..

  COUNT(*)

---

         0

SYS_at_PROD>

Thanks.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 29 2009 - 16:31:08 CST