Re: v$session question

From: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 29 Jan 2009 17:54:16 -0500
Message-ID: <910046b40901291454ldda3b30y2e517982c5f13dc9_at_mail.gmail.com>

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 Thu Jan 29 2009 - 16:54:16 CST