There is no way to automatically notify user2 that user1 has locked the object. It is up to the DBA to decipher this information.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.