Sharding videos on Youtube

I've uploaded 3 videos on installing and configuring sharding in Oracle Database 12c Release 2. I use Virtual Box running Oracle Linux to create a sharded database and run a swingbench workload against it. In part 3 I then add a new shard online and monitor the database as the data is rebalanced across the cluster. You can see them below but I reccomend running them full screen because there's quite a lot going on.

Part 1

Part 2

Part 3


Yet another minor update to swingbench 2.6

This release fixes an annoying issue where some smaller dimension tables weren't populated in the TPC-DS benchmark. It also significantly increases the speed that result files are parsed with the "results2pdf" utility. You can download it from here. Let me know if you have any problems

Minor update to swingbench 2.6

I've just updated swingbench 2.6 (still in Beta). It features a few bug fixes and the following

  • Now ships with Oracle Database 12c Release 2 Drivers
  • A new option to reverse the order in which tables are build by the data generators i.e. small tables first or large tables first.

You can download it at the usual place

Swingbench 2.6 Beta is now available

To celebrate the release of Oracle Database 12c Release 2, I'm releasing swingbench 2.6 into the wild. New features include
  • New JSON benchmark
  • New TPC-DS Like benchmark
  • New Declarative approach to creating a user defined benchmark
  • New SQL Query Editor to create queriers for the user defined benchmark
  • New chart rendering engine
  • Starting swingbench without a named config file now shows a "Select Benchmark" dialogue
  • Many internal fixes
  • Normal stats collection estimates percentiles
  • The stats files also contain tps,cpu and io readings where available.
  • Support for remote connectivity to Oracle Cloud in connection dialogues
  • New "SBUtil" (Swingbench Utility) to validate benchmarks and scale them up (SH and OE Only at present)
  • New "results2pdf" utility to convert results files into pdfs
NOTE : Java 8 is now the only supported VM You can download it here

SwingBench 2.6

Video on SQLBuilder for swingbench 2.6

I've posted a video showing the new SQLBuilder functionality of swingbench 2.6 to YouTube. You can check it out here

I'll be uploading the code shortly to the usual place.