Re: How much memory takes roles, MAX_ENABLED_ROLES
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Mar 2004 17:07:40 -0400
Thanks Stephane Faroult,
I don't udnerstand how Oracle admin roles
I have the impression there is a formula like
#roles*user*xbytes;
To determine the role memory usage.
Or it is only a way to control
the number of roles your database has.
To avoid as you say, have too much and lose the track of them.
----- Original Message -----
From: "Stephane Faroult" <sfaroult@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, March 08, 2004 3:41 PM
Subject: Re: How much memory takes roles, is important to limit their
number?
> Juan Cachito Reyes Pacheco wrote:
> >
> > Hi, somebody know why there is parameter MAX_ENABLED_ROLES
> > The first impression I got, is because they take too much memory, so is
> > better limit them.
> > Is there a way to measure the amount of memory they take.
> > ( or "optimize" them??? if this really means something)
> > Thank you :)
> >
>
> As far as memory consumption goes, roles wouldn't be my first worry. I
> agree with you that a huge number of roles is not a good thing, but not
> for the same reason. More basically, you very quickly begin to lose
> track of whom is allowed to do what when you have too many roles.
> One caveat though (got caught once, a long time ago - don't know if it's
> still true, probably), if you have one single admin account which is
> used for everything including creating roles, don't forget that a role
> is given (and by default enabled) to its creator, so your admin account
> may quickly bump into the limit.
>
> --
> Regards,
>
> Stephane Faroult
> Oriole Limited
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
