Re: odbc drive affect performance

From: Steve <smontgomerie_at_hotmail.com>
Date: 13 Aug 2002 07:55:14 -0700
Message-ID: <156709aa.0208130655.4b10c54@posting.google.com>

got it figured out... it appears that nvision is cooking with RBO and that CBO causes queries to go to outer space.

Oracle has mentioned that 81770 odbc driver does have performance enhancements but I don't think that was our issue.

Interested in hearing any n/vision love/hate stories or further words of wisdom on this.

tks

steve

smontgomerie_at_hotmail.com (Steve) wrote in message news:<156709aa.0208121350.219424b7_at_posting.google.com>...
> Hello,
> We are in a PeopleSoft env running 8173 Oracle on HP 10.2
>
> We just upgraded from 8160
>
> PeopleSoft is fine except for n/vision app which generates queries
> on the fly. The queries are taking forever after the upgrade and
> explain plans have changed from pre-upgrade. We did not upgrade the
> odbc drivers that the n-vision app is using.
>
> This appears to be an n/vision speific issue as all other
> apps/processes etc are running fine.
>
> Would the odbc driver cause the optimizer to go to lunch and choose
> different (worse) plans? I tend to think not but others here are
> asking me to explore this possibility.
>
> Any other thoughts on n/vision and oracle are also appreciated.
>
> tks
>
> steve
Received on Tue Aug 13 2002 - 09:55:14 CDT