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: