Re: limiting number of sessions in multitenant PDB

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, "woody.mckay@xxxxxxxxx >> Woody McKay" <woody.mckay@xxxxxxxxx>
  • Date: Mon, 6 Mar 2017 08:25:47 -0700

My point of view (not necessarily that of my employer) is that process is something at the CDB/container level, since container seems more of a resource supervisor.

The sessions parameter seems more PDB oriented in that it tells the container what is expected, and the container translates that to resources.

To answer your question directly, quotng the docs: NO, Process is not PDB modifiable

- PROCESSES parm: http://docs.oracle.com/database/122/REFRN/PROCESSES.htm#REFRN10175
- SESSIONS parm: http://docs.oracle.com/database/122/REFRN/SESSIONS.htm#REFRN10197

/Hans

On 2017-03-06 7:38 AM, Woody McKay wrote:

In 13.2, is processes modifiable at the PDB level? Sessions is derived fro processes, right?

On Fri, Mar 3, 2017 at 4:10 PM Franck Pachot <franck@xxxxxxxxxx <mailto:franck@xxxxxxxxxx>> wrote:

    Hi,
    The session parameter is PDB modifiable. It limits the number of
    sessions in the PDB.
    If you want to limit the concurrent sessions running in CPU then
    in 12.2 you can set cpu_count.
    Regards,
    Franck.


--
Sincerely,

WoodyMcKay


Other related posts: