Re: How much memory takes roles, MAX_ENABLED

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 8 Mar 2004 17:07:40 -0400
Message-ID: <001701c40551$6a4e6930$2501a8c0@dazasoftware.com>

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_at_oriole.com> To: <oracle-l_at_freelists.org> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 08 2004 - 15:08:41 CST

Re: How much memory takes roles, MAX_ENABLED_ROLES