Thanks for the question, Fadi.
Asked: March 20, 2019 - 11:22 am UTC
Last updated: March 21, 2019 - 4:26 pm UTC
Version: 12c
Viewed 1000+ times
You Asked
Dear Mr. Tom,
i have an issue according the IDLE_TIME parameter..
I used to open more than one session to the database (different scheam's on same Database)...
and our dba set IDLE_TIME as 15 minutes,
and even if the session is not idle (i'm working and execute statements)
i always get the ORA-02396 error....
could you please clarify this situation...
Thanks,
and Chris said...
I used to open more than one session to the database (different scheam's on same Database)
The profile applies per session. Are you doing work in every connected session you have every 15 minutes?
If you're sure you're getting timeouts more frequently than every 15 minutes, please supply a test case showing us this
Is this answer out of date? If it is, please let us know via a Comment