Application report
ORA-02396: Exceeded Maximum Idle Time, please connect again
Guessing It is estimated that the connection in the connection pool has been broken by Oracle, but the application will not judge the status of the session when the application is removed. If the DBA modifies the IDLE_TIME default value in DBA_PROFILE, it will limit the connection.
But sometimes it is very innocent, there are many processes of the process, but don't quit normal, solve
The way is to cancel the limit for a while, then restrict some problems, from Metalink
Investing, this is an 8i bug modification idle_time does not appear in infinite problems.
SQL> ALTER PROFILE DEFAULT LIMIT Idle_Time Unlimited
SQL> SELECT * FROM DBA_PROFILES;
SQL> SELECT * FROM DBA_PROFILES;
