RE: v$session question

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: