3

How can I test what the current setting for the IDLE_TIME setting is within my oracle database?

java123999
  • 6,974
  • 36
  • 77
  • 121
  • 2
    Are you looking for `select * from user_resource_limits where resource_name='IDLE_TIME';`? – atokpas Feb 03 '17 at 10:27
  • "Check" and "test" are not the same thing. Do you want to "check" or to "test"? –  Feb 03 '17 at 15:27

2 Answers2

2

If you're talking about IDLE_TIME in the user profiles, then it depends on the username.

select dbms_metadata.get_ddl('PROFILE', u.profile)
from   dba_users u
where  u.username = :v_username;

You can use the ALTER PROFILE statement to change it if you have the privileges.

sandman
  • 2,050
  • 9
  • 17
0

Each profile has an IDLE_TIME, so it is not clear what you mean by "the" IDLE_TIME.

On my system:

select *
from   DBA_PROFILES
where  resource_name = 'IDLE_TIME'
;


PROFILE              RESOURCE_NAME   RESOURCE_TYPE   LIMIT           COMMON
-------------------- --------------- --------------- --------------- ------
DEFAULT              IDLE_TIME       KERNEL          UNLIMITED       NO
ORA_STIG_PROFILE     IDLE_TIME       KERNEL          15              NO

2 rows selected.