Re: Dev vs Prod: What is wrong here

Mark C. Stock wrote:
> "meathammer" <googler_at_google.com> wrote in message
> news:pan.2006.06.22.19.27.10.594000_at_google.com...
> :I say this is just "wrong" but I can't exactly put up an argument how/why.
> :
> : Would you pls point out what is so wrong with this setup:
> :
> : Assuming the DB is identical...
> : -----------------------------
> : Prod env:
> :
> : 9iR2
> : 2-node RAC
> : HPUX
> : Big tables partitioned
> : --------------------------
> : Test/Dev env:
> :
> : 9iR2
> : Single-instance
> : Windows
> : no tables partitioned.
> :
> :
> :
>
> depends on what you're testing... certainly can't thourougly test
> performance and execution plans
>
> ++ mcs

What is wrong is that upgrade application testing will not be able to detect any RAC specific or Partitioned Table specific problems in your application. There are no guarentees that testing would find any such problems even if the problems existed if the quantity of data differs significantly between the two environments and you will also be unlikely to duplicate the application load while testing.

HTH -- Mark D Powell -- Received on Thu Jun 22 2006 - 14:44:01 CDT