Re: limiting number of sessions in multitenant PDB

Interesting

It does seem odd, now that I think about it, that sessions would be modifiable at the PDB level given that the process table is obviously instance wide. That allows a whole new class of misconfigurations due to inappropriately set PDB sessions parameters I would imagine. And alter system is, sadly, rather widely available in the wild.

On Mon, Mar 6, 2017 at 3:25 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

> 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> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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