RE: v$session question
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <veeeraman@xxxxxxxxx>, "Paul Drake" <bdbafh@xxxxxxxxx>
- Date: Fri, 30 Jan 2009 07:56:32 -0500
Ram,
On Unix, you need to kill the unix session first before killing the
Oracle session. Kill the
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman
Sent: Thursday, January 29, 2009 8:52 PM
To: Paul Drake
Cc: ORACLE-L
Subject: Re: v$session question
Thanks Paul.
It is HP-UX 11i. Oracle is 10.202.
I used the 'Alter system kill session' command from SQL PLus.
orakill.exe? Is it for Windows?
On Thu, Jan 29, 2009 at 4:54 PM, Paul Drake <bdbafh@xxxxxxxxx> wrote:
On Thu, Jan 29, 2009 at 5:31 PM, Ram Raman <veeeraman@xxxxxxxxx> wrote:
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.
Ram,
Perhaps you're awaiting PMON to come along and pronounce:
"Bring out your dead!"
Might this be running on a Microsoft operating system?
What method are you using to mark the sessions as killed?
(e.g. 'ALTER SYSTEM KILL SESSION ...')
The supplied utility orakill.exe might be a better way to go.
Hth.
Paul
Other related posts:
