I need some assistance ASAP. Our nightly batch process seems to have hung up for some strange reason (ok no biggie my boss says kill it and start it again). The problem is I have killed the processes both in oracle (sid, serial#) and also in unix. Now I can't see the processes in unix but in oracle they have a status of killed but are still holding the resources. My thinking is telling me the pmon is not waking up or not doing it's job. How can one manually tell a process to wake up. Any help will be greatly appreciated.
OS Solaris 7
Oracle 8.0.6.3
Thanks. Ivan
