--Open parameters, create profiles sql> show parameter resource_limit;
NAME TYPE VALUE------------------------------------------------------------- ----------------Resource_limit boolean falsesql> sql> alter system set Resource_ Limit=true;
System altered.
Sql> Show parameter resource_limit;
NAME TYPE VALUE------------------------------------------------------------- ----------------Resource_limit Boolean TRUE
Sql> Create profile Test_profile limit Idle_time 1;
Profile created.
sql> alter user Scott profile Test_profile;
User altered.--Test Login
[Email protected] ~]$ Sqlplus scott/redhat
Sql*plus:release 11.2.0.4.0 Production on Tuesday March 6 17:02:38 2018
Copyright (c) 1982, Oracle. All rights reserved.
Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit productionwith The partitioning, Real appli Cation Clusters, Automatic Storage Management, Olap,data Mining and Real application testing options
Sql> SELECT * from dual;
D-x
sql>/select * from Dual*error to line 1:ora-02396: Maximum idle time exceeded, please reconnect
--Delete Test profile sql> Select Username,profile from dba_users where profile= ' test_profile ';
USERNAME profile------------------------------------------------------------SCOTT Test_profile
Sql> drop profile test_profile cascade;
Profile dropped.
"ORACLE" Database is idle for 1 minutes automatically disconnected
