链接远程的数据库

sqlplus qowar/qowar@4.20


设置数据库的idle


ALTER SYSTEM SET RESOURCE_LIMIT=TRUE1;


select resource_name,profile from dba_profiles

SELECT * FROM DBA_PROFILES;

select resource_name,limit from dba_profiles where profile='IDLETIME_PROFILE' and idle_time

show parameter resource;


create profile idletime_profile limit idle_time 3

alter profile idletime_profile limit idle_time 1

alter user qowar profile DEFAULT


select username,profile from dba_users where username='QOWAR';



select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;