Re: Oracle7 performance problem

From: Mike Bray <mrb_at_earth.wustl.edu>
Date: 19 Feb 1994 21:36:56 GMT
Message-ID: <2k60po$kn3_at_bigfoot.wustl.edu>

In article <1994Feb13.180048.1_at_corp02.d51.lilly.com>, <jl34778_at_corp02.d51.lilly.com> wrote:
>In article <1994Feb11.171022.29656_at_newshost.lanl.gov>, ronk_at_beta.lanl.gov (Ronald John Krantz) writes:
>> We are seeing a significant performance drop while running a specific
>> application on Oracle7 as compared to Oracle v6. A SQL select statement
>> that requires 10 seconds on v6 requires well over 3 minutes on Oracle7.
>
>The optimizer changed drastically in ORACLE7. We noticed a couple of situations
>where the same statement would optimize differently under the two versions.

I didn't see what version you are running. There are optimizer bugs in 7.0.12 - 7.0.15 is supposed to fix them - I'm about to install the 7.0.15 upgrade to see.

Mike Bray
mrb_at_earth.wustl.edu Received on Sat Feb 19 1994 - 22:36:56 CET

This message: [ Message body ]
Next message: Tony Scott: "Re: How to unload Oracle in ASCII flat fil"
Previous message: Roland McGrath: "Databses Security Procedure Information Wanted"
Maybe in reply to: Ronald John Krantz: "Oracle7 performance problem"
Next in thread: Chi-Cheong Weng: "Re: sybase vs oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message