Init parameterProcesses & sessions

RESOURCE_LIMIT

What it controls

Whether profile resource limits such as idle time and CPU per call are enforced.

Know this before you change it

Password limits in profiles are enforced whatever this is set to.

Default: TRUE

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'resource_limit';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'resource_limit' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET resource_limit = TRUE SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET resource_limit SCOPE = SPFILE SID = '*';

Related scripts

• Password profile settingsPassword rules for each profile: lifetime, reuse, failed attempts and the verify function. Shows why an account locked or expired.

Open in the parameter referenceOracle's reference

More in Processes & sessions

• PROCESSESThe most operating system processes that can connect to the instance, including background processes.
• SESSIONSThe most sessions the instance allows.
• OPEN_CURSORSThe most cursors one session can have open at once.
• SESSION_CACHED_CURSORSHow many closed cursors each session keeps cached, which saves repeated soft parses.
• JOB_QUEUE_PROCESSESThe most job slave processes for Scheduler and DBMS_JOB jobs.
• DDL_LOCK_TIMEOUTSeconds a DDL statement waits for a lock before failing with ORA-00054.