This example, tested on an Oracle 9 database, shows the largest permitted value for the max_enabled_roles parameter:
SQL> alter system set max_enabled_roles = 150 scope = spfile
2 /
alter system set max_enabled_roles = 150 scope = spfile
*
ERROR at line 1:
ORA-00068: invalid value 150 for parameter max_enabled_roles, must be between 1 and 148
SQL> alter system set max_enabled_roles = 148 scope = spfile
2 /
System altered.
SQL>
No comments:
Post a Comment