Oracle Application Express (MOSC)

MOSC Banner

How Could i avoid multiple database sessions from the same app user in a specific app page?

Lets say for example that there is a button and when the user click it then a session with a query is created in the database. If the user dont wait until the query is finished and click again the button this will create one more database session(exactly the same) and sometimes stuck. Also this is causing a general performance issue in the database.

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