Re: v$session question

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