RE: v$session question

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Fri, 30 Jan 2009 07:56:32 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF023CA1E4_at_EXCNYSM0A1AJ.nysemail.nyenet>

Ram,  

On Unix, you need to kill the unix session first before killing the Oracle session. Kill the      

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com> wrote:  

On Thu, Jan 29, 2009 at 5:31 PM, Ram Raman <veeeraman_at_gmail.com> 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_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.  

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  

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 30 2009 - 06:56:32 CST