v$session question

From: Ram Raman <veeeraman@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 29 Jan 2009 16:31:08 -0600

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@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@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@PROD>
SYS@PROD>
SYS@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@PROD> select count(*) from v$transaction
  2
SYS@PROD> /
more..

  COUNT(*)
----------
         0

SYS@PROD>

Thanks.

Follow-Ups:

Re: v$session question
From: Paul Drake

RE: v$session question
From: Goulet, Richard

Re: v$session question
From: Jared Still

v$session question

Other related posts: