How to limit the time of session lock?

Hi All,
As we all know when a user manipulates data (records), he/she lockes these records untill closing it's transaction (by COMMIT or ROLLBACK)=2E I'm aware of the 'SELECT=2E=2E=2E FOR UPDATE NOWAIT' to catch an exception when a record is locked to prevent hanging of the user's session=2E
My question is bigger: Is there any way to tell "Oracle", that when a session (any session, on any table) is waiting for the closure of another session transaction, limit this waiting time by X seconds=2E If this time had past, close the session (disssconect)? An init parameter maybe?

Popular White Paper On This Topic

Use any of the following:
1. Enable the RESOURCE_LIMIT =TRUE initialization parameter.
Create a profile that limits CPU_PER_SESSION (to a logical figure in 1/100 of a second) & CONNECTION_TIME (in minutes).
If the above doesn't work use the following plan directive
2. Set the resource plan directive parameter MAX_ESTIMATED_EXEC_TIME.
Most of these operations will require DBA privileges.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.