Re: Maybe stupid question about exp/imp

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 15 Apr 2003 12:47:42 GMT
Message-ID: <Xns935EE7B6219EBTokenthis@210.49.20.254>

Following up on Niall Litchfield, 15 Apr 2003:

> can all happen when a database is EXPorted/IMPorted. It is important not
> to confuse the reason for the performance increase with the process one
> has just performed.

How true. One of the most common reasons for the old "after exp/imp speed is up" for example was elimination of un-noticed chaining. But every1 thought it was the exp/imp. Oh well..

> do EXP COMPRESS=Y and reimport. It must be the changed number of extents
> that accounts for the improvement right?

Absolutely! :D

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Apr 15 2003 - 07:47:42 CDT