Idle processes in forms 6i 1

[smacattack]

When running a fat client using oracle 8i forms 6i is there anyway i can kill of the clients who have a idle time of more than 30 minutes. I need to get a better idea of concurrent users but finding users just leaving there P.C's logged into the system and not viewing or inputting any data.
The kill must be clean and leave no processes behind.
Any ideas!?

 

[Dagon]

You could create a profile in the database for the users and set the IDLE_TIME to 30 minutes.

 

[smacattack]

How do i create a profile?

 

[Dagon]

You have to set an INIT.ORA parameter called RESOURCE_LIMIT to TRUE before profiles will operate.

Then you can create a profile with syntax such as:

CREATE PROFILE clerk LIMIT
SESSIONS_PER_USER 2
CPU_PER_SESSION unlimited
CPU_PER_CALL 6000
LOGICAL_READS_PER_SESSION unlimited
LOGICAL_READS_PER_CALL 100
IDLE_TIME 30
CONNECT_TIME 480;

Then you do an &quot;alter <user> profile clerk&quot;;

 

[smacattack]

If i create the profile how can i globally put this profile into action without writing script to read all usernames and add profile to them?

 

[Dagon]

I don't know of any way to do this globally but is it really so hard to write a script ?

set feedback off
set heading off
set pagesize 0

spool alter_users.sql
select 'alter user '||username||' profile xxxx;'
from sys.dba_users
/
spool off