Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 Mon Jun 02 1997 - 00:00:00 CDT