Re: Migrate from 7.3.4 to 8.0.5

I just migrated an 18 Gb db to Oracle 8.0.5 from 7.3.4 on Solaris 2.5.1, E5000 Server, using the migration utility. Everything is the same,including optimizer mode (rule), but all SQL is about 3 times slower. I did table scans on a few large tables and it takes about thrice the time it took before it was a 7.3.4 database.

Any ideas what I may be missing. Oracle support seems to have a beginner staff....somebody kept on telling me today I had too many extents (20) so my timings were off.

Help would be appreciated very very much.

Thanks,

Raman Batra, rrbatra_at_feist.com

rpdata_at_cyberus.ca wrote:

>
> I've done it using export/import and the migration utility... Both
> work ok, but if you're DB is not too too big, export/import is much
> simpler and it's a good opportunity to re-create your DB and defrag..
>
> Good luck..
> Robert Prendin
> RP Data Solutions
>
> PS: If you're on HPUX 10.20 send me an email, I ran into a few issues
> with the migration utility.. such as TEMP tablespace and a file on the
> CD was missing or the case was incorrect which Oracle has a cute
> workaround for(again)...
>
> ..
> On Fri, 4 Jun 1999 07:43:56 +0800, chenjp_at_email.com (ChenJP) wrote:
>
> >Hi, for a higher performance ,
> >our company want to migrate our Oracle 7.3.4 server to 8.0.5.
> >So , can u tell me some info about this migration.
> >Or where I can find related information.
> >Thanks a lot.
> >
> >chenjp_at_email.com
>
> #----------------------------------
> # RP Data Solutions Inc.
> # Oracle Database Support Services
> # Ottawa Canada +1(613)791-0599
> #----------------------------------
Received on Thu Jun 03 1999 - 23:32:54 CDT