| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Killed session doesnt release resources
Sometimes the only way to get Oracle's PMON to wake up is to kill the OS process that the session was attached to. You can find the PID with the following query:
SELECT RAWTOHEX(ADDR), SPID FROM V$PROCESS
WHERE ADDR IN
(SELECT ADDR FROM V$PROCESS
WHERE PROGRAM NOT LIKE '%(S%'
AND PROGRAM NOT LIKE '%(D%'
AND PROGRAM NOT LIKE '%(P%'
AND PROGRAM != 'PSEUDO'
MINUS SELECT PADDR FROM V$SESSION
WHERE STATUS NOT IN ('KILLED','SNIPED'));
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Database Admin [mailto:dba_at_magma.co.in]
Sent: Thursday, March 04, 2004 3:15 AM
To: oracle-l_at_freelists.org
Subject: Killed session doesnt release resources
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |