Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long Query chokes in 7.3 but not in 7.1
Do you have all the same indexes? Are the statistics current? Have you
done an explain plan in both instances to determine the differences? If the
problem isn't found by answering those questions, you might check
differences in values of initSID.ora parameters that might have an effect.
Greg Gershowitz wrote in message
<35E591AF.4F4371BC_at_charlotte.computex.com>...
>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'.
>
>We set up the exact same tables and data under Oracle 7.1 and Oracle
>7.3:
>
>On Oracle 7.1, the query works fine.
>
>On Oracle 7.3, Oracle hangs, and we have to shutdown abort the database
>to get control back. We changed the query to do some joins like a.value
>= b.value, etc.
>
>Any ideas? We haven't encountered this kind of problem before.
>
>--
>Greg Gershowitz
>mailto:gregg_at_charlotte.computex.com
>International CompuTex, Inc. http://www.computex.com
>(704)547-7383 x230 FAX: (704)548-1948
Received on Mon Aug 31 1998 - 16:22:00 CDT