Re: Reserve some connections for SYS

  • From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
  • To: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • Date: Wed, 16 Jul 2014 14:23:29 +0530

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*

Other related posts: