Imported DB runs SLOWER on faster machine

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 23 Jul 2002 17:32:36 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702685A64@lnewton.leeds.lfs.co.uk>

Niall,

have you rtried setting STATISTICS=NONE on the export ?

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Tuesday, July 23, 2002 3:47 PM Posted To: server
Conversation: Imported DB runs SLOWER on faster machine Subject: Re: Imported DB runs SLOWER on faster machine

I agree that Daniel is right. However by default you *do* get stats on import - just estimated stats. I know this because moving an 816 export to
an 817 instance *always* gives a dbms_stats error on import. Ignoring this
and reanalyzing works just fine. Received on Tue Jul 23 2002 - 11:32:36 CDT