Search code examples
oracle-databaseoracle11gentitymanager

How to check what current IDLE_TIME is set at in ORACLE?

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

Solution

  • 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.