Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: maximum # of connections per dispatcher
My dispatchers are not super-busy.
NAME PROTOCOL STATUS %TIME BUSYOWNED
Elapsed: 00:00:00.03
PADDR TYPE QUEUED WAIT TOTALQ AVG WAIT
---------------- ---------- ---------- ---------- ---------- ----------
00 COMMON 0 11947471 214999099 .055569865 000000010E0FD0E0 DISPATCHER 0 4749324 54667371 .086876759 000000010E0FD600 DISPATCHER 1 4671018 53634362 .087090026 000000010E0FE040 DISPATCHER 0 4780058 55772407 .085706504 000000010E0FDB20 DISPATCHER 0 4754535 54948025 .08652786
Thanks for the links. Connection pooling seems appealing, although, honestly, over the years of using MTS I've found it to be so buggy that I'd be reluctant using any more 'features' of it.
I don't fully understand how it works, it seems to be 'sharing' the socket somehow between sessions? Let's say I have 4 connections and 16 sessions enabled.. What happens if all 16 sessions want to execute something? In what wait will that result (if any).
Thanks. Received on Wed Apr 05 2006 - 23:33:16 CDT