Hello,
"select for update" IS useful, IMHO.
If a session locks a record with "select for update", another session using "select for update nowait" on the same record, gets the ORA-00054 error.