2396 Mar-02396: Exceeded Maximum iDLE Time, please connect again
0INSERT INTO AGENT_TASK (Task_ID, TYPE, CREATED_TIME, RELATION_OBJECT_ID) VALUES (Task_Id.NextVal, 1, Sysdate, 7364794)
If 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, why is there in 9.2.0.4?
SQL> ALTER PROFILE DEFAULT LIMIT IDLE_TIME Unlimited
Waiting for a while
SQL> ALTER PROFILE DEFAULT LIMIT IDLE_TIME 16;
SQL> SELECT * FROM DBA_PROFILES;
SQL> SELECT * FROM DBA_PROFILES;