Re: ioexception: end of tns data channel

> 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

> How many sessions you have from the application server and how many is
> enabled ?

one session open and closed cyclically from the App server. up to 20 from the web server
the CPU usage from the sessions is very low

> The java application may use very bad optimized query in one of
> statements, or some code stack in endless loop. (it's just my speculation).
>

I'm quite sure ther's no looping in the stack, the DDL code is very simple, basically the application is a data loader that makes insert on the DB reading from files and according to business rules

the connecton is opened from JDBC and in some case may remain opened for a long time (minutes)
what I mean is the data channel remain opened for a while I know it's a quite bad design, do you think it will be worth fixing up?

jc Received on Mon Aug 23 2004 - 05:37:44 CDT