Just somewhere to keep my notes while I'm playing.

Wednesday, July 16, 2008

Oracle Idle Timeout

You can find what your Oracle Idle Timeout is set to by:


SQL> select * from dba_profiles
2 where RESOURCE_NAME = 'IDLE_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT IDLE_TIME KERNEL 4320
SQL>


For details of profiles, see: here

No comments: