Oracle Forms (MOSC)

MOSC Banner

Post-Database-Commit taking too long (response time)

edited Oct 30, 2009 3:55AM in Oracle Forms (MOSC) 3 commentsAnswered
  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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center