Skip to Main Content

APEX

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!

SESSION_PER_USER limit gets exceeded

Rshankar-OracleMay 13 2008 — edited Apr 19 2010
I have an applicatiion which queries from bugDB using a Dblink. There are an items in page which are entered/selected, that go as input into a query associated with the resion. When I submit, query get executed and records are displayed. When I do this selection/execution a few times SESSION_PER_USER limit get execeeded message is displayed.

I think every time a query is getting executed there is a database session which gets created and this gets execeeded. I have to wait for some time, before presumably a background process clears the connection. I tried logging out or closing browser. It did not help much.

I am not sure of the solution!
Is there a way everytime II exceucte a query, I close the session including the database conenction in the background and then restart a new session. Experts please help out!

Regards
ravi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2010
Added on May 13 2008
10 comments
6,230 views