Re: v$session question
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>
- Date: Thu, 29 Jan 2009 19:51:49 -0600
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:
