Re: unit testing oracle database - what's your experience?

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 17 Jul 2009 10:37:34 -0700 (PDT)
Message-ID: <d2ec7bdb-3881-487e-9144-3bfd756beb0d_at_v20g2000yqm.googlegroups.com>

On Jul 17, 10:45 am, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:

snip

> > what experiences have you made with unit testing an Oracle database?
> > What tools have you used?
> > Thank you for your answers,
>
> > Regards,
> > Berny
>
> Afair, Steven Feuerstein created PL/SQL unit testing framework years
> ago. It's now published as Quest Code Tester for Oracle, which is
> available here:http://www.toadworld.com/DOWNLOADS/ExclusiveToadWorldFreeware/tabid/7....
> There are freeware and commercial versions. Didn't try it myself
> though, so no comments.

Not quite familiar with exactly what that does but have listened to Steven demo similar things and certainly worth checking out.

Also in the kind of framework arena is Tom Kyte's test harness approach where you get a bunch of relevant oracle statistics before and after ... and see how much latching / consistent gets / etc various different approaches to solving a problem generates. Received on Fri Jul 17 2009 - 12:37:34 CDT