1

Topic: Queue of sessions of the user (not to exceed a limit in sessions)

Whether probably in Oracle 12.1 to fulfill such adjustment, that:
1) Kol-in simultaneous sessions of the certain user it has been restricted (for example, 10)
2) At connection attempt of following sessions above this threshold (11th and further) session opened (was not the failure), but its request would get to queue (it was executed after end of operation of one of 10 resolved).
If yes - as?
The question is connected to necessity to regulate loading from the specific exterior technical process pulling a DBMS.

2

Re: Queue of sessions of the user (not to exceed a limit in sessions)

Whether

Alexus12 wrote:

probably in Oracle 12.1 to fulfill such adjustment, that:
1) Kol-in simultaneous sessions of the certain user it has been restricted (for example, 10)
2) At connection attempt of following sessions above this threshold (11th and further) session opened (was not the failure), but its request would get to queue (it was executed after end of operation of one of 10 resolved).
If yes - as?
The question is connected to necessity to regulate loading from the specific exterior technical process pulling a DBMS.

1) create profile-> SESSIONS_PER_USER/IDLE_TIME + resource_limit=true, but at connection attempt, receive .
2) it is possible to try to be played with Resource Plans + trigger after logon + DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS, but restrictions works only for CPU, for a disk it is required exadata

3

Re: Queue of sessions of the user (not to exceed a limit in sessions)

https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc002.htm#BABFCIEE wrote:

Database Resident Connection Pooling
When the first request is received from a client, the Connection Broker picks an available pooled server and hands off the client connection to the pooled server.
If no pooled servers are available, the Connection Broker creates one. If the pool has reached its maximum size, the client request is placed on the wait queue until a pooled server is available.

4

Re: Queue of sessions of the user (not to exceed a limit in sessions)

I will probably tell nonsense, since never the administrator. I know purely in the theory.
And it is impossible simply on separate port  to adjust SHARED SERVER and to give it few flows for performance of commands?
The limit at session as is wanted by a topic a starter will not be, but it will be fulfilled no more N SQL commands (sessions) simultaneously.
Well and to read docks on Resource Manager'.
IMHO

5

Re: Queue of sessions of the user (not to exceed a limit in sessions)

Leonid Kudryavtsev;
Not always it is possible to use pool

6

Re: Queue of sessions of the user (not to exceed a limit in sessions)

Active Session Pool