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,

Gary

"Gary McLane" <mclan001@mc.duke.edu> a écrit dans le message de
news:c8g5mo$de7$1@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 :-)

Hello,

Thank you for replying to my post.

What you say below is obvious, but I need to determine if a tool actually
exists. You never know; if someone builds one, others may buy it. I realize
that such a tool probably does not exist (at least not outside of Oracle),
but my job is to find out if one does exist.

Gary McLane

"G Dahler" <yellow-shark@spamex.com> wrote in message
news:BTOqc.65461$325.1272117@news20.bellglobal.com ...
>
> "Gary McLane" <mclan001@mc.duke.edu> a écrit dans le message de
> news:c8g5mo$de7$1@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 :-)
>
>
>

"Gary McLane" <mclan001@mc.duke.edu> wrote in message
news:c8gh6g$emi$1@gargoyle.oit.duke.edu...
> Hello,
>
> Thank you for replying to my post.
>
> What you say below is obvious, but I need to determine if a tool actually
> exists. You never know; if someone builds one, others may buy it. I
realize
> that such a tool probably does not exist (at least not outside of Oracle),
> but my job is to find out if one does exist.
>
> Gary McLane
>
> "G Dahler" <yellow-shark@spamex.com> wrote in message
> news:BTOqc.65461$325.1272117@news20.bellglobal.com ...
> >
> > "Gary McLane" <mclan001@mc.duke.edu> a écrit dans le message de
> > news:c8g5mo$de7$1@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 :-)
> >
> >
> >
>
>
Gary,
There are many QA tools that will do regression tests. (Mercury, etc) The
problem is designing all the regression tests. Oracle uses a grid
environment to do its internal QA testing and so it may in fact do more
regression tests now. I doubt there is anyone who sells the regression
tests, just the tools.

What we do is have development, test, and production environments. For any
patch we put it into Development first, do a complete set of application
regression tests. Then we do the same in the test environment. Finally,
after much testing we put it into production. That is a more reasonable
approach than trying to do regression tests on the database or the OS. (MS
doesn't do complete regression tests either on some patches. I don't know
about Sun, Linux, HP, IBM,etc)
Jim

Jim,

Thanks for replying to my post.

I suspect you are correct about regression tests and tools. The approach you
use in your environment sounds good. We do something like that too, but
maybe not as intensive. We're looking to strengthen our testing procedures,
and your approach sounds like a great way to go.

Again, thanks for replying to my post.

Regards,

Gary McLane



"Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
news:mPSqc.26005$gr.2300941@attbi_s52...
>
> "Gary McLane" <mclan001@mc.duke.edu> wrote in message
> news:c8gh6g$emi$1@gargoyle.oit.duke.edu...
> > Hello,
> >
> > Thank you for replying to my post.
> >
> > What you say below is obvious, but I need to determine if a tool
actually
> > exists. You never know; if someone builds one, others may buy it. I
> realize
> > that such a tool probably does not exist (at least not outside of
Oracle),
> > but my job is to find out if one does exist.
> >
> > Gary McLane
> >
> > "G Dahler" <yellow-shark@spamex.com> wrote in message
> > news:BTOqc.65461$325.1272117@news20.bellglobal.com ...
> > >
> > > "Gary McLane" <mclan001@mc.duke.edu> a écrit dans le message de
> > > news:c8g5mo$de7$1@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 :-)
> > >
> > >
> > >
> >
> >
> Gary,
> There are many QA tools that will do regression tests. (Mercury, etc) The
> problem is designing all the regression tests. Oracle uses a grid
> environment to do its internal QA testing and so it may in fact do more
> regression tests now. I doubt there is anyone who sells the regression
> tests, just the tools.
>
> What we do is have development, test, and production environments. For
any
> patch we put it into Development first, do a complete set of application
> regression tests. Then we do the same in the test environment. Finally,
> after much testing we put it into production. That is a more reasonable
> approach than trying to do regression tests on the database or the OS. (MS
> doesn't do complete regression tests either on some patches. I don't know
> about Sun, Linux, HP, IBM,etc)
> Jim
>
>

Gary McLane wrote:

> 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,
>
> Gary

While not directly answering your final question, the following is an
interesting related read ...

http://otn.oracle.com/oramag/oracle/...making10g.html

/Hans