Re: Regression Testing

"Gary McLane" <mclan001_at_mc.duke.edu> a écrit dans le message de news:c8g5mo$de7$1_at_gargoyle.oit.duke.edu...
> Hi,
>
> Is anyone aware of regression testing tools for the Oracle RDBMS?
>
> My understanding is that Oracle does regression testing before releasing a
> major upgrade to the RDBMS, but not for patch releases.
>
> I am interested in an inexpensive software package that I can use for
> regression testing Oracle patch releases.
>
> Thanks,
>

Regression testing database software must be a HUGE feat, there must be thousands of tests to do. Even if you had the tools to do so in your enviroment, you would have to know actually which test to perform.

Regression testing is sometimes done at a very detailed level (Eg: physical structure of the written data, etc...)

I presume you would like to be confident that your code will run well before appying a patch to your prod environment ?

In this case, what you have to do is install the patch in a TEST environment (You do it, don't you ?) and test your code there before approving the move in production, that's basic deployment methodology.

If you do that and are very paranoid, you can also wait for others to "test" a new patch before appying it and see what happens to other customers. If you don't have time to wait, I dont see where you'll find the time to "regression test" oracle either.

And remember, in the oracle user agreement, it is written that oracle is not designed to run a nuclear facility :-) Received on Wed May 19 2004 - 14:49:51 CDT