Re: limiting number of sessions in multitenant PDB

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_at_pachot.net
> <mailto:franck_at_pachot.net>> 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

--
http://www.freelists.org/webpage/oracle-l