How to release excessive connections on the Oracle server

How to release the Oracle server with too many connections will crash. After the client network cable with too many connections is pulled out, the user's connections will still be retained on the remote Oracle, and the user's connections will not be released for a long time, you can solve this problem by checking the internet. CREATE a PROFILE: SQL> CREATE PROFILE kil1_le LIMIT IDLE_TIME 3; Profile created. new PROFILE content: SQL> col limit for a10 SQL> select * from dba_profiles where profile = 'kiltaille '; PROFILE RESOURCE_NAME resource limit -------- submit --- ---- kilw.le kernel default kilw.kernel DEFAULT kilw.le kernel default kilw.le CONNECT_TIME KERNEL DEFAULT kilstmle PRIVATE_SGA kernel default kilstmle primary password default profile RESOURCE_NAME resource limit -------- ----------- --- ---- kilstmle primary PASSWORD DEFAULT 16 rows selected. test User: SQL> select username, profile from dba_users where username = 'eygl'; USERNAME PROFILE ---------- ------- EYGLE DEFAULT modify the PROFILE of the EYGLE user to use the new PROFILE: SQL> alter user eygle profile kilw.le; User altered. SQL> select username, profile from dba_users where username = 'eygl'; USERNAME PROFILE ---------- ------- EYGLE kilw.le for connection test: [oracle @ test126 admin] $ sqlplus eygle/eygle @ eygle SQL * Plus: Release 10.2.0.1.0-Production on Fri Oct 13 08:07:13 2006 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production With the Partitioning and Data Mining options SQL> select username, profile from dba_users where username = 'eygl '; username profile ---------- EYGLE kilw.le when the IDLE exceeds the limit time, the connection will be disconnected: SQL> select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss ') from dual; TO_CHAR (SYSDATE, 'yy ------- 2006-10-13 08:08:41 SQL> select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss') from dual; select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss') from dual * ERROR at line 1: ORA-02396: exceeded maximum idle time, please connect again