Skip to Main Content

SQL & PL/SQL

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!

Blocking sessions to kill

HeisonlineApr 28 2021

Dear Experts ,

We have situation :
Application used to update customer details .
Other applications sending customers data to update in our application through xmls.
With this if user working on customer no say XXX to update his details and same time xmls received for same customer to update details from online application .
With this case it causes blocking and online applications not getting responses within time frame and it create issue to get response from online applications.

We would like to know how we can kill the blocking sessions automatically when blocking sessions occurs .
Currently we are killing those blocking manually , situation becomes difficult when it comes outside business hrs and during the weekends.

Can you please help to any automatic way we can implement to kill the blocking session and process remain uninterrupted?
We applied automatic killing the blocking session , but sometimes it kill unwanted blocking session which are temporary and which should not suppose to kill .

We highly respect your suggestions and feedback or any hint for implementation .

Thank you.

Comments
Post Details
Added on Apr 28 2021
2 comments
723 views