SQL> show parameter resource_
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
resource_limit boolean FALSE
SQL> alter system set resource_limit=true;
System altered.
SQL> alter profile default limit IDLE_TIME 1;
Profile altered.
<새 세션연결>
sqlplus system/oracle
3분후
SQL> select status from v$Instance;
select status from v$Instance
*
ERROR at line 1:
ORA-02396: exceeded maximum idle time, please connect again