Swingbench Update including Oracle Database 23ai Drivers

I know it’s been a while since we’ve had a swingbench update. Thats mainly because of work commitments and “life”. Thats not to say there hasn’t been work going on. We’ve been using swingbench as a very small part of the testing that went on, and is still going on, against Oracle Database 23ai. As as a result I’ve been adding functionality to support that testing and fixing issues as we encounter them. Which means I’m pleased to have found some time to package up the changes and release a new build using the latest Oracle Database 23ai jdbc drivers. This doesn’t make this version of swingbench an Oracle Database 23ai only utility. It can be used with any version of the Oracle Database that the 23ai jdbc drivers support i.e. Oracle Database 19c, Oracle Database 21c etc. In fact Oracle recommends that you always try and run with the latest version of their drivers regardless of the version of the target database (within reason).

I, and a few other developers, have made a few other fixes as well including a brand new JSON workload that support the new JSON Relational Duality functionality in Oracle Database 23ai (thank you Loic).

So the full list of changes is as follows

• Added a number of new benchmarks and associated wizards
  • Sharded Order Entry
  • Movie Wizard
  • Application Continuity Order Entry
  • JSON Social Network
  • Order Entry True Cache
• CPU and I/O stats use metrics reported directly from the database. No need for Secure Shell
• CPU Chart in the Swingbench GUI shows 0 to 100
• Drivers updated to Oracle Database 23ai
• More validation checks with wizards
• Additional command line parameter checks (runtime)
• Numerous fixes

You can download it here or from github

• 2024 1
• 2023 5
• 2022 8