9iAS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 9iAS

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360

    9iAS

    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?

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    The problem we have is 5 of these process using a lot of CPU, is this normal behaviour?
    Code:
    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

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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!?

  4. #4
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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!)
    Code:
    $ 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!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width