How to identify Forms sessions in v$session?
I didn't find any appropriate community to post this thread.
We are running Apps 11.5.10.2 on 11.1.0.7 DB with multiple app/form tiers.
We are having problem of runaway old inactive forms sessions taking up 80-90% of the CPU on the forms server. This is on IBM AIX platform. So, I want to write a script to find out the process id of such old inactive forms sessions from v$session table and then generate kill -9 <processid> command and execute it. But, the problem is that there is no way you can tell if it is a forms session in v$session table. program column is empty for forms sessions.