Automic Workload Automation

Expand all | Collapse all

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

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

    Posted 10-03-2016 10:39 AM
    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.


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

    Posted 10-11-2016 03:47 AM

    Hi Kim,

    Sorry to be picky but this has nothing to do with the I/O´s of the database storage. It´s an overview of the transaction time within the startup of the AE. There is no commit at the end > no IO;







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

    Posted 10-11-2016 04:15 AM
    its an insert, select, rollback, so i can confirm no I/O, also its just as Harriet already said an dummy table so its only a general ballpark figure on the performance of the DB Driver and DB.


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

    Posted 10-12-2016 07:31 AM
    The information says "Reference values tested with Windows 2003". Is Windows 2003 still supported ??



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

    Posted 10-13-2016 09:55 AM
    Obviously not, but its not really important for these operations.
    The first value is just how often the System could increment 1 by 1 in one second.
    Both values are not too dependent on the OS.

    But you are right it looks a bit strange/funny in the log.


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

    Posted 10-14-2016 08:27 AM
    Thanks for posting this here Harriet_Kim_1764!

    I'm curious what other customers see in their logs for the DB threshold. We find that our numbers are consistently much lower than the threshold of "470." Generally we hover in the 200-250 range, but have seen it drop to less than 100 during periods of high use/instability. We are currently on Oracle 11.2.0.3 with upgrade to 12c coming shortly.





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

    Posted 10-14-2016 11:34 AM
    From a support perspective, I'd love to see the full bell curve of benchmarks. I've seen over 1500, and I've also seen 7 (I'll let you guess which system was actually having issues :) ). 

    From a very general perspective, it's a good way to see if the DB performance tweaking that DBA's perform has an impact. It, of course, isn't 100% correlation, but it is high enough that when I see that number jump up consistently I usually see less performance impact. 


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

    Posted 01-17-2017 12:04 PM
    In our V11 environment we pretty consistently see: U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '24194934'/'75'.  What have been the biggest gains in the DB performance numbers?  Take in mind this has been the case since the environment has been created.