Testing Solutions for Enhanced Oracle Performance

The must-have performance testing solution for the Oracle Database Server 

Do you want to know the maximum number of users your Oracle Database can handle?
Do you want to know how your Oracle Database will perform with 100 active (SQL/PL*SQL) statements or more?
Do you want to know the impact on the performance after applying a patchset, initialization parameter change, adding SQL hints, query rewrites, storage modifications, etc., etc.  ?

Database2test™ gives you the answers to that kind of questions. Database2test is the load and stress test solution for predicting system behavior and performance for all editions of the Oracle Database Server.

With database2test you can obtain an accurate picture of end-to-end database performance and identify performance bottlenecks before go-live! Database2test is an indispensable tool for migration projects, performance tuning, continuous testing, and solving scalability and performance related problems.

Database2test has many features, the following list will give you an overview of the most important or outstanding features.
Please contact us or consult our online documentation for detailed information

  • Certified with Oracle Server 9i, 10g and 11g and higher (all editions)
  • Test single or multiple database instances
  • Oracle SQL and PL/SQL statements
  • Compound (multiple)SQL statements (incl. pause statement)
  • Transaction support
  • Statement parameterization (SQL and PL*SQL)
  • Bind variables to reduce hard parses
  • Support to log DBMS_OUTPUT messages
  • XML serialization of fetched row sets
  • Batch (non-gui) mode for job scheduling
  • Test goals: duration / number of statement executions
  • Online dashboard including four graphical monitors
  • Automatically generated (graphical) reports for the overall test and each individual script
  • Captured performance statistics during the test, among others:
    • Performance (active statements and passed statements)
    • Execution times (sec)
    • Execution time delay (msec)
    • Individual statement execution times (baseline, minimum and maximum in msec)
    • Generated load
    • Database connection setups
    • Database statements (active, passed, failed, pending and timed out)
  • Code free!