Script to kill Inactive forms sessions
Posted by Navdeep Saini on May 22, 2007
Lots of time, due to user training issues, users leave their forms sessions open and do not end thier sessions. This can cause lots of issues as sometime even querying in a forms sessions places a lock (I know of Order Entry forms which used to behave like that) and as DBAs you will end up clearing blocking sessions in the database.
Oracle apps has timeout profiles (e.g. ICX Session Timeout) options and confirguration options (Apache timeouts etc) , but most of them do not end the database session. Following script checks the forms sessions in the database and kill the database and their corresponding forms (f60webmx) sessions, which were “INACTIVE” and idle (LAST_CALL_ET) for more than 1 hour.
This works for all types of configurations, whether single node or multi-node. For multi-node the requirement is to enable remsh (remote shell), otherwise change the script to use ssh (for more secure option). It also create log and appends to it and send e-mail if there are any sessions that needs to be killed.
hume said
hai .. i’m humaedi , thank’s for your script. because i am studying ORACLE and get trouble.
Navdeep Saini said
Hi Humaedi
Thanks for reading my blog and I am glad that you find my script useful.
Thanks again
Nav
Kumar said
Hi Navdeep,
Very nice script,Will be very useful for junior’s like me.
Good Work.
Thanks,
Kumar
Navdeep Saini said
Kumar
I am glad that you find my script useful.
regards
Nav
Ken said
hi,
I can`t find your scripts.May you send me?My email is wangxuezhi@sf-express.com.
Thanks.
Ken
Arun said
Hi NAVDEEP,
Quite Superb….
Keep it up………
Kman said
Good Job Navdeep!!!
Vinayak Sawal said
Thanks for all your good work
which really help us.
Keep up the good work.!
John said
Nice script, Navdeep. Do you have a similar script to identify inactive forms sessions in a RAC environment?
Siham ELALGA said
Thanks for all your good work,
In my application with forms6i,whith each form opning, I open a new session , so i want to exit all forms after one hour (but if the last form in application is inactive for 1 hour)and return to the login form in which the user enter his password and login .
Can you help me PLZ because it is a big pb for me.
Thanks
matmosis said
hi
this script is only for LINUX systems??
is there one for Windows? i have Oracle 8i on Windows 2000 machine
thanx a lot
Mat
Mehboob said
Hi Nav,
Thanks for the contribution to the Oracle Apps, i am also working on Oracle Since last 4 Yrs and visiting all the blogs related to apps….. These blogs are increasing my knowledge thanks for these blogs…
vasu said
hai
i want know about forms locking sessions
how we can remove those sessions
Ted said
Thanks for the script — very helpful. I’m glad there are people, such as yourself, who like to share knowledge.
Navdeep Saini said
Thanks Ted !!
regards
Nav
goolloog said
I here the newcomer. Not absolutely I will understand with topic. Explain, please. http://kopitop.ru/map.html
DKumar said
I am looking for a script that identifies the inactive forms session but not kill it and sends out an email to our DL and when we are comfortable we can kill it. I need this ASAP.
Thanks
Dkumar
Year One Online said
This is very up-to-date information. I’ll share it on Digg.
p.s. Year One is already on the Internet and you can watch it for free.
ranbir said
nice work! would like you to post more scenario regarding recovery and backup. nice to go thru this blog of urs. ssa!
Prasant said
Hi Navdeep,
Thanks for such a nice Scripts , I was face Form Runway session ,now I think I can identified those Inactive Forms as well as Inactive User too. Once again thanks buddy !!!
With Regards
Prasant