Friday, October 17, 2008

LICENSE_MAX_USERS

Property

Description

Parameter type

Integer

Default value

0

Modifiable

ALTER SYSTEM

Range of values

0 to number of user licenses

Basic

No

Real Application Clusters

Oracle recommends that multiple instances have the same value.

LICENSE_MAX_USERS specifies the maximum number of users you can create in the database. When you reach this limit, you cannot create more users. You can, however, increase the limit.

Do not enable both concurrent usage (session) licensing and user licensing. Set either LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.

Note:

1. Related:    
               Parameter: LICENSE_SESSIONS_WARNING
               Parameter: LICENSE_MAX_SESSIONS
               View: V$LICENSE

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LICENSE_MAX_USERS’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

license_max_users

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

maximum number of named users

that can be created in the database

Oracle initializatoin parameters

No comments:

Post a Comment