Re: Oracle webagent spawning multiple processes

In article <01bc6f94$a86cb230$a49433cf_at_gr03>, "Wilson Zhang" <wzhang_at_kbg.com> writes:

[Quoted] > > 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?
>
> This is a webserver concept. Web server doesn't maintain state. Every
> time the web server talks to Oracle, it will call one of the WRB
> process(thread) to create a new connection with Oracle.
>

Wilson, Thanks for the info.
[Quoted] I did a Yahoo-search for web agent to find an FAQ section where it says that [Quoted] OWA (Oracle Web Agent) is CGI-BIN program which does spawn a process for each request [Quoted] while WRB doesn't. Can anybody expand on this? How does WRB manage to reuse the [Quoted] connection? And how to setup WRB? I suppose you need Webserver 2.1 or greater!?

> >
> > 3) If there is a config issue where can we change this?
> >
>
> I've noticed the speed issue in my installation also. But it seemed more
> of a Oracle tuning issue. After I tuned Oracle server, the botttleneck is
> gone.
>

[Quoted] We do know that more indexes would help the performance. But, at this time what is [Quoted] really slow is a display of a static screen. The content of the display come from [Quoted] a PL/SQL block with sequence of htp.print() statements. This should be very fast [Quoted] since no Oracle query is involved, just a connection to Oracle and executing the pl/sql [Quoted] Thanks for the help and any furthur details on tuning/setup issue. /sandeep Received on Mon Jun 02 1997 - 00:00:00 CEST