Re: Long Query chokes in 7.3 but not in 7.1

From: David Schweisguth <davids_at_tracy.pangeasystems.com>
Date: 28 Aug 1998 15:30:22 GMT
Message-ID: <6s6iee$nje$1@pornstorm.geo.net>

Greg Gershowitz (gregg_at_charlotte.computex.com) wrote:
: We've run into a problem where we have an SQL query that's pretty long,
: and joins about 7 or 8 tables. Most of the where clause are things like
: a.value = 'CONSTANT' and b.value='CONSTANT'. [...]
: On Oracle 7.3, Oracle hangs, and we have to shutdown abort the database
: to get control back.

7.3.what? There are versions of 7.3 (as there were versions of 7.1 and 7.2 and no doubt every release) which have serious bugs. 0.0.0.1 can make all the difference. At any rate, this is the sort of thing technical support was made for.

Dave Schweisguth                              Work: davids_at_pangeasystems.com
Pangea Systems                                Home: dschweisguth_at_earthlink.net

Received on Fri Aug 28 1998 - 10:30:22 CDT