Re: ioexception: end of tns data channel

On 23 Aug 2004 03:37:44 -0700, josephcurwen_at_despammed.com (curwen) wrote:

>> Are you running Oracle in server shared mode ? - check how many circuits
>> is in use and how many is max setup on your server.
>
>parallel_server startup parametre = FALSE
>I have only one instance in production

The previous poster asked whether you are using multithreaded server, now known as shared server. In that case your mts_dispatcher init.ora parameter must be set to something meaningful and v$mts, and v$dispatcher will show whether you are actually using it. If you are using more or less stateless connections (ie your app continually connects and disconnects) using MTS is more or less mandatory, because when you don't disconnect gracefully, the dedicated server session on the database server will remain forever. We switched from dedicated to mts and memory usage fell from 1.6 G to about 1.0 G

--
Sybrand Bakker, Senior Oracle DBA