Re: Long Query chokes in 7.3 but not in 7.1

From: Greg Gershowitz >>
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, <<

What does the explain plan show? Have you updated the statistics or are you rule based? What is the full version of Oracle and of the Os that you are running on?

If the entire database is hanging and not just the session doing the query then you may have some type of resource problem. Take a look at the v$syswait and v$sysstat for the instance to see if anything stands out as a problem you can fix via init.ora parameters, otherwise it would probably be bug related.  

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sat Aug 29 1998 - 11:23:56 CDT