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!

Parallel Hint - Does it cause ORA-02391 Exceeded simultaneous session_per_user limit

DaveyBFeb 22 2017 — edited Feb 22 2017

Hi All, Let's say I am able to have 5 connections from the same login onto the Oracle database (12).  Each connection can run its own query etc. If in one connection I use a parallel hint of 10 (let's say) will(could) that use one of my five connections? If I used an even larger degree of parallelism could I theoretically get the ORA-02391 Exceeded simultaneous session_per_user limit error?  If I try to log in after the query is ran?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2017
Added on Feb 22 2017
6 comments
713 views