Re: Problems with query - end of communication

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 01 Mar 2001 20:10:09 -0800
Message-ID: <3A9F1D21.4FB351D7@exesolutions.com>

> I have an 'End of Communication Channel' when I make a query on a table with
> more than one condition in the where clause. When there is only one
> condition, everything is alright. Does anybody heard about this problem ?

This problem is, from my experience, caused by timing out the network connection or the transaction. If your network is fast I'd look at the size of the rollback segments, at the number of extents being created due to very small extent sizes in your rollback and/or temp space and also at whether your tables have indexes supporting your WHERE clause.

Daniel A. Morgan Received on Thu Mar 01 2001 - 22:10:09 CST