How to identify and kill unwanted oracle process on windows.
957865Aug 24 2012 — edited Aug 31 2012Hi Experts,
we have third party application which uses oracle database (version 10.2.0.5) on WINDOWS. Our no of process used keeps increasing by 15-20 everyday.
However number of sessions remain constant 32-35 . So in couple of days we reach our limit of max processes and DB needs to be restarted to release processes.
How to identify unwanted process ?? is it safe to kill process(windows threads) which have V$PROCESS.ADDR not equal to V$SESSION.PADDR using orakill or some other third party utility or should I use another way ??
No of sessions remains constant and currently we don't have control over application.
thanks