RE: Reserve some connections for SYS
Date: Wed, 16 Jul 2014 16:55:34 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB602055AF0_at_HKJUMXMB103B.zone1.scb.net>
Well, yes. You’d have to configure the limit in the PROFILEs. If you have multiple users you’d have to be careful about setting the limits.
Hemant K Chitale
From: sumit Tyagi [mailto:dba.tyagisumit_at_gmail.com]
Sent: Wednesday, July 16, 2014 4:53 PM
To: Chitale, Hemant K
Cc: ORACLE-L
Subject: Re: Reserve some connections for SYS
Dear Hemant,
Can't we do it like below .
Total Limit = ( Allow a specific numb of processes for each user in Profile) + remaining connections will work for SYS
On Wed, Jul 16, 2014 at 2:07 PM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:
No, you cannot reserve process table entries for SYS.
You’d have to have a pre-connected session as SYS in a terminal. You could protect that terminal by having it running in VNC behind a password.
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sumit Tyagi
Sent: Wednesday, July 16, 2014 4:23 PM
To: Oracle L
Subject: Fwd: Reserve some connections for SYS
Can we reserve some connections / processes only for SYS.
- Forwarded message ---------- From: "sumit Tyagi" <dba.tyagisumit_at_gmail.com> Date: Jul 16, 2014 1:51 PM Subject: Reserve some connections for SYS To: "Oracle L" <oracle-l_at_freelists.org>
Hi all,
Can we some connections only for sys. Like below example:
Max limit processes = 500
For all other users use processes upto limit say 498 and give rest 2 for sysdba .
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
--
--
BR
Sumit Tyagi
+91-7829543355
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 16 2014 - 10:55:34 CEST