2.220 MAX_IDLE_TIME

MAX_IDLE_TIME specifies the maximum number of minutes that a session can be idle. After that point, the session is automatically terminated.

Property Description

Parameter type

Integer

Default value

0

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

0 to the maximum integer. The value of 0 indicates that there is no limit.

Basic

No

Oracle RAC

Different instances can use different values.

See Also:

"MAX_IDLE_BLOCKER_TIME" to learn how to set a lower idle time limit for sessions that are holding resources required by other sessions