RESOURCE_LIMIT

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SYSTEM
Range of values	true | false

RESOURCE_LIMIT determines whether resource limits are enforced in database profiles.

Values:

• TRUE

Enables the enforcement of resource limits

• FALSE

Disables the enforcement of resource limits

Note:

1. See Oracle Database Administrator's Guide and Oracle Database SQL Language Reference for more information on setting resource limits for profiles.

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) = 'RESOURCE_LIMIT';

Oracle initializatoin parameters