Oracle Forms (MOSC)

MOSC Banner

How to identify Forms sessions in v$session?

edited Sep 3, 2010 1:42AM in Oracle Forms (MOSC) 2 commentsAnswered
Hello,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center