Home -> Usenet -> comp.databases.oracle -> Re: ** DeadUser Disconnection problem in ORACLE Forms4.5 **

Re: ** DeadUser Disconnection problem in ORACLE Forms4.5 **

From: Jennifer Brickner <brickner_at_vistachrome.com>
Date: 1996/07/08
Message-ID: <31E16AA8.5602_at_vistachrome.com>#1/1 








Dear Paul:



Have you tried limiting idle time in a user profile.  This works for me.
ALTER/CREATE PROFILE XXX LIMIT IDLE_TIME 30;

alter user MRPOP Profile XXX;


or 


spool userp.sql;


set pagesize 0;


select 'alter user '||user_name||' Profile XXX;' from all_users;
spool off;


_at_userp.sql


this does not affect long queries or reports



Regards,


Jennifer
Received on Mon Jul 08 1996 - 00:00:00 CEST












Original text of this message