Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Advise for kicking out forms users to avoid db row locks

juliojgsSep 6 2023

Hi, we have a forms 12.2.1.4 app running, standalone launcher style.

Sometimes, users leave their sessions with a row locked. It is not frequent, but this can cause some processes to be waiting for that lock to be released.

How can we establish a time limit and kick out the locking forms user? Is there a keepalive parameter? What happens to the database session?

Users are happy with a once in a day login, but the locking can be annoying, so we have to balance pros and cons.

Thanks.

This post has been answered by Michael Ferrante-Oracle on Sep 13 2023
Jump to Answer
Comments
Post Details
Added on Sep 6 2023
10 comments
629 views