Oracle 11.2.0.4.0 - Windows 2012 R2 Server
I have a issue whilst using Idle_time (Resource Limits). I've enabled Resource Limits by issuing the below command and restart the database
alter system set resource_limit = true scope=both; & set IDLE_TIME to 10 mins
I've logged in as myself and checked that IDLE_TIME is set to 10 minutes.
SQL> select * FROM USER_RESOURCE_LIMITS;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME 10
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
9 rows selected.
SQL>
This issue I have is when I am connecting in using my own account (and its idle for 20 mins) is that PMON service is not snipping my session?
I've checked (using SYS) and my session is still in an Idle state and as I said, after 20 mins doing nothing, I can contiune to run select statements...
My understanding is that after 10 mins, Oracle (PMON) should disconnect my session.. Am I missing some additional setup?