㈠ exceeded maximum idle time,please connect again 資料庫連接池怎麼修改
可以對其進行修改。例如創建一個名稱為idletime_profile的profile,並指定其中idle_time參數值是1,單位是分鍾。
SQL> create profile idletime_profile limit idle_time 1;
Profile created.
並將該profile賦給用戶bisal
SQL> alter user bisal profile idletime_profile;
User altered.
這樣當用bisal登錄到Oracle後,持續1分鍾不幹事,再次執行某個操作時就會報ORA-02396: exceeded maximum idle time, please connect again