Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 0EE9019605C4 for ; Fri, 3 Mar 2017 22:11:46 +0100 (CET) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Fri, 3 Mar 2017 22:11:45 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A745B6D662; Fri, 3 Mar 2017 16:11:44 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UqOjtopLHdtn; Fri, 3 Mar 2017 16:11:44 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74CC66DCAE; Fri, 3 Mar 2017 16:11:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 03 Mar 2017 16:10:10 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8C4256DC49 for ; Fri, 3 Mar 2017 16:10:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ClxDHwKcBVeW for ; Fri, 3 Mar 2017 16:10:10 -0500 (EST) Received: from relay2-d.mail.gandi.net (relay2-d.mail.gandi.net [217.70.183.194]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 26ADB6DC3A for ; Fri, 3 Mar 2017 16:10:09 -0500 (EST) Received: from mfilter27-d.gandi.net (mfilter27-d.gandi.net [217.70.178.155]) by relay2-d.mail.gandi.net (Postfix) with ESMTP id CA7F9C5A49 for ; Fri, 3 Mar 2017 22:10:08 +0100 (CET) Received: from relay2-d.mail.gandi.net ([IPv6:::ffff:217.70.183.194]) by mfilter27-d.gandi.net (mfilter27-d.gandi.net [::ffff:10.0.15.180]) (amavisd-new, port 10024) with ESMTP id ZpjKGvnQ-68X for ; Fri, 3 Mar 2017 22:10:07 +0100 (CET) X-Originating-IP: 209.85.217.176 Received: from mail-ua0-f176.google.com (mail-ua0-f176.google.com [209.85.217.176]) (Authenticated sender: mailbox@pachot.net) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 41CB7C5A43 for ; Fri, 3 Mar 2017 22:10:07 +0100 (CET) Received: by mail-ua0-f176.google.com with SMTP id q7so93852029uaf.2 for ; Fri, 03 Mar 2017 13:10:07 -0800 (PST) X-Gm-Message-State: AMke39m8XaiErrdcHzkDtH/LWm2PdfEsnFfE9IvzOPeU+IG7MhS3vAcw0EGumeVQzmjEoIFMQT65RFsrt9F9cA== X-Received: by 10.159.32.195 with SMTP id 61mr1656695uaa.147.1488575406103; Fri, 03 Mar 2017 13:10:06 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Franck Pachot Date: Fri, 03 Mar 2017 21:09:54 +0000 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: limiting number of sessions in multitenant PDB To: woody.mckay@gmail.com, ORACLE-L Content-Type: multipart/alternative; boundary=94eb2c0b77104d6a6e0549d9f80a X-archive-position: 67801 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: franck@pachot.net Precedence: normal Reply-To: franck@pachot.net List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --94eb2c0b77104d6a6e0549d9f80a Content-Type: text/plain; charset=UTF-8 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. On Fri, Mar 3, 2017 at 9:38 PM Woody McKay wrote: > I'm looking at the new 12.2 multitenant on Linux 64x. > > So many new features and settings pushed down from CBD to PDB. > > Does anyone have the best solution for limiting the number of user > sessions per PDB? > > PDB level profile, resource management or lock down? > > Looking to put 96 customer SIDs into 96 PDB's and want to keep high > isolation. > > > Thoughts??? > > > -- > Sincerely, > > WoodyMcKay > --94eb2c0b77104d6a6e0549d9f80a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
The session parameter is PDB modifiable. It limits= the number of sessions in the PDB.
If you want to limit the conc= urrent sessions running in CPU then in 12.2 you can set cpu_count.
Regards,
Franck.

On Fri, Mar 3, 2017 at 9:38 PM Woody McKay <woody.mckay@gmail.com> wrote:
I'm lo= oking at the new 12.2 multitenant on Linux 64x.
So many new features an= d settings pushed down from CBD to PDB.

Does anyone have the best= solution for limiting the number of user sessions per PDB?

PDB l= evel profile, resource management or lock down?

Looking to put 96= customer SIDs into 96 PDB's and want to keep high isolation.


Thoughts???


--
Sincerely,

WoodyMcKa= y
--94eb2c0b77104d6a6e0549d9f80a-- -- http://www.freelists.org/webpage/oracle-l