9iAS

[fraze]

I've never really come across 9iAS so apologies if this is a simple question. We've got a load of f60webm processes on our UNIX box, some are spinning and consuming lots of CPU's. Are the processes caused by people requesting Forms from the form server process (f60svrm)?
Could anyone give a simple explanantion on how these processes are spawned?

[fraze]

The problem we have is 5 of these process using a lot of CPU, is this normal behaviour?

CPU TTY     PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
 8   ?      726 oracle   241 20 24228K 16636K run   2267:02 93.11 92.94 f60webm
 6   ?    15925 oracle   241 20 24228K 16636K run   2498:55 92.60 92.43 f60webm
10   ?    17403 oracle   241 20 26676K 19984K run   2450:24 92.50 92.34 f60webm
 0   ?     2735 oracle   241 20 24228K 16636K run   2441:36 92.49 92.33 f60webm
 7   ?    16088 oracle   241 20 26676K 19084K run   2436:26 92.35 92.19 f60webm

[fraze]

Not to worry - found a Metalink Doc titled "How to Troubleshoot Spinning / Runaway Web Deployed Forms Runtime Processes? " - was originally searching for f60web instead of f60webm. Isn't Metalink Search great!?

[fraze]

Does anyone know how to tie one of these processes to a DB session. I've tried v$session and v$process with the PID of one of the runaway processes and have found nothing. I've also run truss on the runaway processes and they don't appear to be doing anything (although I'm not 100% sure about this!)

$ tusc -p 2735
( Attached to process 2735 ("f60webm webfile=5,2421,PID387") [32-bit] )
[2735] In user-mode ............................................................................... [running]

Any help would be greatly appreciated!

PS I've discovered that we're running Forms6i, not 9i and its connecting to an 8174 DB (both AS and DB are on the same UNIX box!)