Re: patching

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/patching-tp3027p3029.html

In these kinds of situations, you should check the Apps tier OS process, see what it is doing.
Also, it is important to check the db tier as well.
You should find the db session id of that worker and see what it is waiting for. (current wait event)..
Ther can some locks left, there can be a latch wait etc..
For a deeper diag, you should review the sql or command that the worker is executing. You should review the code in it and try the predict what can be the cause accordingly.