Harriet_Kim_1764

How to Determine your Oracle DB's I/O benchmark

Discussion created by Harriet_Kim_1764 on Oct 3, 2016
Latest reply on Jan 17, 2017 by Michael_Rothrauff_7681
If you look in your CP or WP logs, you will see something like this:

U0003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '19652524'/'53'
U0003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470

This tells you the CPU and database performance.

More information can be found in this technical article:  Performance problems and an explanation of U0003533

Question:
What is the exact operation statement being done that determines the Oracle DB performance numbers so that a DBA can run it against their database to do a performance analysis?

Answer:
The AE does an

INSERT INTO DIVDB and SELECT from DIVDB.

After 1 second, we check how often this was done.

With v12 sp1 this is changed and we do exactly 1000 INSERT and SELECT and provide the information how long this took.

DIVDB is a dummy table and documentation on the DB schema can be found here.

Outcomes