Hi,
I tried this also,doesnt help much usually killing the Unix server process
helps.
Deep
> Database Admin wrote:
>
>> Hi,
>> I am facing a problem in my
>>
>> Dual Processor ,4 Gb RAM ,HP-UX 11.11,Oracle 9.2.0 Box.Whenever a
>> session is killed it doesnt release the resources a long time.The
>> other problem I face is if someone uses a heavy Report (Oracle Report
>> Developer Executable) and then sits idle even then it doesnt release
>> the resource. Any inputs??.
>> Deep
>>
>>
>> ----------------------------------------------------------------
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> ---------------------------------------------------------------- To
>> unsubscribe send email to: oracle-l-request_at_freelists.org
>> put 'unsubscribe' in the subject line.
>> --
>> Archives are at http://www.freelists.org/archives/oracle-l/
>> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>> -----------------------------------------------------------------
>
> I've generally had good luck using the immediate clause.
>
> alter system kill session '&sid,&serial' immediate;
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sun Mar 07 2004 - 23:34:23 CST
