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?
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
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!?:rolleyes:
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!)
Any help would be greatly appreciated!
$ tusc -p 2735
( Attached to process 2735 ("f60webm webfile=5,2421,PID387") [32-bit] )
 In user-mode ............................................................................... [running]
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!)