Post-Database-Commit taking too long (response time)
We have an alert message in 2 triggers in an Oracle form; one in the Post-Forms-Commit and the other in the Post-Database-Commit. When users make a change on this form and press Save, the alert in Post-Forms-Commit is displayed almost immediately but the Post-Database-Commit alert is only displayed several seconds later.
Furthermore, by querying the changed row and column in a separate SQL session, it can be seen that the change is committed to the database almost instantaneously. In other words, whilst the form is busy after the Post-Forms-Commit alert has been acknowledged, the SQL in another session shows that the change has already been committed.
0