- Creating Tests
Description:
How does Oracle work ? You're never going to be able to answer that
question, but if you create a sensible strategy for testing you'll have
fewer nasty surprises as you implement new features or design new systems.
In this presentation we cover a few topics that you need to consider when
setting up a framework for testing. First, how to generate large amounts of
data quickly and repeatably; then how to ensure that the data content and
pattern is a reasonable match to the system you want to emulate (and
creating patterns is not very difficult). We'll examine a couple of cases
to show that you can be caught out by such simple errors as creating
indexes at the wrong point in your testing, and the differences between
using CTAS (create table as select) and pl/sql loops (especially run
concurrently) to generate data.
Although it takes a lot of effort to create realistic models of production
activity, we'll also look at simple ways of modelling some aspects of
concurrency, and show how concurrency can make a massive difference to what
goes on inside the database - time permitting we will take a look at a few
dumps of internal structures (disk and memory) to highlight some of the
effects of concurrency.
Go to top