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 -----------------------------------------------------------------