Proper testing of all changes to Oracle are critical
especially when you change global instance
parameters. Also see my notes on
System Testing areas and
Some beginners are lead to
believe that artificial test scripts on a PC
constitute Oracle testing, but this approach is not
recognized as valid Oracle pre-production testing in
most real-world Oracle databases. For the
Oracle professional, a valid Oracle system change
test involves these Oracle testing best practices.
Artificial test scripts and
meaningless and Oracle testing must be conducted
according to Oracle best practices, using 4
instances, DEV, TEST, QA and PROD. Note: Log a
service request on MOSC: if you
need to change any undocumented or hidden
Test the change in a DEV
instance - The DEV instance is the
developer" playpen where you can check your
Oracle test for basic functionality.
Test the change in a
TEST instance - The TEST instance is usually
refreshed from the PROD instance (i.e. using
Oracle Streams), and has production data and
application code. Small volume tests can
be conducted here to ensure validity.
Test the change in the
QA instance - The QA instance is an exact
replica of PROD and has volume-testing tools to
realistically simulate a real production load.
In the QA instance the Oracle testing involves
examining the Oracle performance statistics
using STATSPACK or AWR.
Final Oracle test in
PROD - At a pre-approved time, the tested
Oracle change is migrated to PROD, and
real-world performance characteristics are
gathered and compared to the before-change
In sum, Oracle best practices
mandate as-complete a real-world test as possible,
with real production loads and real production data.
Oracle testing does not include artificial
"test-case" scripts on a PC, which most IT managers
do not find relevant.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.