Oracle webagent spawning multiple processes

Hi,
I am not too familiar with the Webserver, Webagent environment. I do know the Oracle7 pretty good. I walked into this setup where a reload of the internal Web page is VERY slow. And, if you RELOAD it still takes the same amount of time - so caching is not working. Btw, we are using Webserver V2.0

Looking deeper, we found that the page is being displayed by connecting to pl/sql block with bunch of htm.print statements. Since this is a static info it should be very fast to display since no query is involved.

We noticed that each time we RELOAD a new Oracle shadow process (in addition to the initial process) is created of the like

oraclesid1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

Questions:
1) what is this protocol beq? When I connect thru sqlplus or sqldba protocol is IPC

   based on how the listener is setup.
   The web listener is started as "wlctl start admin"

2) Why a new process is spawned/forked if the orig connection still exists? Why

   does the reload not use the same connection to the pl/sql block?

3) If there is a config issue where can we change this?

Any help is greatly appreciated.

Thanks much.
/sandeep Received on Sat May 31 1997 - 00:00:00 CEST