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.
Other related posts:
