Re: Upgrade from 8.1.6 to 8.1.7 really slow

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 14 May 2002 22:41:09 +0100
Message-ID: <3ce18476$0$8514$cc9e4d1f@news.dial.pipex.com>

"Mark D Powell" <mark.powell_at_eds.com> wrote in message news:178d2795.0205140751.5d0a5b09_at_posting.google.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3cdfda5d$0$234$ed9e5944_at_reading.news.pipex.net>...
> > "Mark D Powell" <mark.powell_at_eds.com> wrote in message
> Niall, since dbms_stats does not calculate chained rows and analyze
> may not calculate some statistics that analyze does calculate your
> example does not actually prove anything since you omitted displaying
> the statistics generated. I will do that and prove (I think) your
> point that analyze does replace statistics generated by dbms_stats.

Um yes.

<memo to self>
if one is to try to demonstrate something. at the very least make sure you address the issue that you say you are demonstrating </memo to self>

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue May 14 2002 - 16:41:09 CDT