I guess the FOR UPDATE NOWAIT clause when don't want to wait to get a lock on resource, but I don't understand how another process gained the lock on resource when one process already took it.
SELECT * From serial_item_inv where serial_number := sqli_serial_number and serial_type := sqli_serial_type and sim_status = ‘V’ For update nowait;
This is working fine, but when the number of process increases its fails.
Please i need it's solution in 1 days, any one.