Re: v$session question

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: