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@xxxxxx> 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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@xxxxxxxxx> > Date: Jul 16, 2014 1:51 PM > Subject: Reserve some connections for SYS > To: "Oracle L" <oracle-l@xxxxxxxxxxxxx> > > 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*