Urgent plz+ how to release locks when instance crashes
i have a database service connected to Oracle 9i and it is connected to database using jdbc drivers.
now if due to instance failure, that service and stops and then i restart the web server and run a program for recovery. This recovery program rollbacks all transactions after last commit in transaction that was going on at time of failure.
Database is intact and not restarted. If we restart it, PMON itself will release locks. But here, how to release locks and do rollback..coz memory would have effect of queries executed before failure + locks held ...since database is not restarted in this case.
What should be done?
kill what? how to find which process to kill?
Quote:
Originally Posted by dbasan
Kill the process if its held a exclusive lock.
kill what? how to find which process to kill?