如何检查ORACLE中当前设置的IDLE_TIME? [英] How to check what current IDLE_TIME is set at in ORACLE?

问题描述

我如何测试oracle数据库中IDLE_TIME设置的当前设置?

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

推荐答案

如果您在用户个人资料中谈论IDLE_TIME，则取决于用户名.

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;

如果有特权，可以使用ALTER PROFILE语句进行更改.

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

这篇关于如何检查ORACLE中当前设置的IDLE_TIME?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！