Re: Patch

Posted by ErmanArslansOracleBlog on Dec 01, 2014; 9:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Patch-tp136p137.html

use adctrl.

AD Controller Menu
—————————————————

1.    Show worker status
2.    Tell worker to restart a failed job
3.    Tell worker to quit
4.    Tell manager that a worker failed its job
5.    Tell manager that a worker acknowledges quit
6.    Restart a worker on the current machine
7.    Exit

See the worker status.
Are they running or not if running there should be a work assigned to it. check it.

If it is a sql, find the session associated with the worker, and see what is that session doing in the database level.