Huh. In the Oracle 8.1 documentation (Oracle8i Reference - Release 2 (8.1.6)
- Part Number A76961-01) I see a default value for MAX_ENABLED_ROLES of 20.
However in the 8.1.7 database I'm running on my PC max_enabled_roles is not
mentioned in the init.ora, and the value I see from v$parameter is 30.
> -----Original Message-----
> From: Donald Bricker [mailto:Don.Bricker_at_epa.state.il.us]
>
> Does the max_enabled_roles initialization parameter have to be set for
> an instance?
>
> If it is not set is the limit the default of 20 or do you have
> unlimited enabled roles. I have looked through the docs and I
> only find
> the upper limit for max_enabled_roles is 148.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 06 2003 - 15:53:57 CST
