Re: 600 Gb migration from Sun to Aix in 8 hrs

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 22 Nov 2005 00:03:02 +0100
Message-ID: <43825227$0$10956$ba620e4c@news.skynet.be>

"Kris" <krishnaprasadn_at_gmail.com> wrote in message news:1132594695.027155.258340_at_o13g2000cwo.googlegroups.com...
> We have successfully migrated 600 Gb database for a banking client from
> SUN to AIX in 7 hrs.we had several pilot runs before the final ball.
>
> we used following parameters during export
>
> db_file_multiblock_read_count=20480
> db_file_multiblock_io_count=128
>
> and for import
> parallel_max_servers=60
> parallel_automatic_tuning=TRUE
>
>
> AIX box had just 7 cpu's.
> export ON the basis of table size run parallely in 7 diff sessions.(3
> hrs)
> import without indexes (for big tables) in 7 diff session.(4 hrs)
> index creation for big tables (2 hrs)
>

Mmm ... I did some tests on AIX 5L recently (with storage on Symmetrix) and couldn't find any performance improvements with DMRC > 32. So i'm really puzzled by that great number.
Other question : how did you calculate the table and index statistics after the import ?

Matthias Received on Mon Nov 21 2005 - 17:03:02 CST