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

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 21 Nov 2005 20:17:35 -0800
Message-ID: <1132633055.383869.40130@g49g2000cwa.googlegroups.com>

bdbafh_at_gmail.com wrote:

> 1 select pname, pval1
> 2 from sys.aux_stats$
> 3 where pval1 is not null
> 4* order by 1
> SQL> /
>
> PNAME PVAL1
> ------------------------------ ----------
> CPUSPEED 587
> CPUSPEEDNW 1051.42512
> FLAGS 1
> IOSEEKTIM 10
> IOTFRSPEED 4096
> MAXTHR 3555328

?????????????????????????????????????


> MBRC                                    7

?????????????????????????????????????


> MREADTIM                           10.513

> SREADTIM                            4.536

>
> 9 rows selected.
>
> 10.1.0.4 std ed. 32 bit
> w2k adv svr sp4
> HP DL530G2
> dual xeon mp 2.4 GHz
> datafiles exclusively on an 8 drive RAID 10 volume, stripe size 256 KB
>

I don't get it. Why "7"? And why is it different from the set MBRC in init.ora? Received on Mon Nov 21 2005 - 22:17:35 CST