Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maybe stupid question about exp/imp

Re: Maybe stupid question about exp/imp

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 15 Apr 2003 10:06:37 GMT
Message-ID: <Xns935ECC66CBB1BTokenthis@210.49.20.254>


Following up on Jan Gelbrich, 15 Apr 2003:

> can exp/imp be one way of database tuning at all ?

It can, but not in current versions of the database. Unless you have a VERY atypical case.

> Recently I heard some roumors saying that, after re-importing,
> there might be a slightly better overall performance, "for some reason".

Those are either greatly exagerated or related to some very old version of Oracle. Don't listen to them.

> What I found was about speeding up the exp / imp process itself,

That's fair enough.

> but not about any performance effects to the database
> *after* having done it ... but I am not sure.

I'd be sure if I were you. ;)

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Tue Apr 15 2003 - 05:06:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US