Re: Oracle Dispatcher problems

In article <GSkX6.3656$Q8.102042_at_juliett.dax.net>, "Ottar says...
>
>I have a PHP/Apache installation on my Win 2k desktop connected to an Oracle
>database.
>The database has the dispatcher running as seen below.
>To log in to Oracle I use OCIPLogon ($user, $pwd, $host).
>Still, I get a db-reconnect for every time I access my PHP script.
>

can you clarify what it is you expect? every time you log in, a session will be created -- you'll connect and disconnect. If you are using MTS, you won't see new backgrounds spawned on the server -- the shared servers will be there but you will see connects/disconnects for every login/logout you do.

What is it you expect to see?

>I am not convinced the dispatcher is running properly/used correctly.
>
>How do I check and fix this ?
>
>
>Thanks
>Ottar
>
>
>---------------------------
>SQL> select * from v$dispatcher;
>NAME
>----
>NETWORK
>----------------------------------------------------------------------------
>------------------------
>PADDR STATUS ACC MESSAGES BYTES BREAKS OWNED
>CREATED IDLE BUSY
>-------- ---------------- --- --------- --------- --------- --------- ------
>--- --------- ---------
>LISTENER CONF_INDX
>--------- ---------
>D000
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=W2K-ORASRV-1.achilles.no)(PORT=102
>7))(PRESENTATION=oracle.
>aurora.server.SGiopServer)(S
>02C0FC30 WAIT YES 0 0 0 0
>0 124787 0
> 0 0
>D001
>(ADDRESS=(PROTOCOL=tcp)(HOST=W2K-ORASRV-1.achilles.no)(PORT=1029))
>02C0FF50 WAIT YES 281 48048 0 3
>3 124609 148
> 0 1
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp