Re: Sql problems.

From: Casper Thrane <ct_at_benau.dk> >>
The following sql script worked fine on Oracle Server 7.3.2 on a digital Unix. ... Now we have upgraded to Oracle Server 7.3.3, and it doesn't work anymore. <<

Try looking at the explain plan output. Oracle is probably choosing a bad access plan. We have had the same kind of problem when we went from 7.1.6 to 7.2.3. Several queries went to lunch on us. You might just want to re-analyze the obejcts in tables and indexes involved in the query and re-try the query. If may be that changes to the optimizer are going to require a hint be coded in the query to make it work right (like it used to work). This is what we had to do to a half dozen couple of queries out of many hundreds that exist on our system.

Good luck, expect a few more to show problem queries to show up in the weekly, and monthy only jobs. Tunning never ends.

Mark Powell -- Oracle 7 Certified DBA
- The only advise that counts is the advise that you follow so follow your own advise - Received on Tue Dec 09 1997 - 00:00:00 CST