There was a lock when 1 process by ERP and lock won't go away. I killed the session and re-ran the process, lock was back, then I killed/re-ran and lock kept coming back. This lock was on a master table and lock all the subsequence process- basically process just hang.
I killed the session and ran analyze table validate structure and since then LOCK never came back. Does that mean I have a table corruption yesterday? How to avoid table/index corrution in the future?