Connection and latency test tool - adbping (Doc ID 2863450.1)

Last updated on MAY 17, 2023

Applies to:

Goal

In Oracle Autonomous Database on shared infrastructure, it is a common requirement for end customers and internal operations to quickly determine the latency while connecting to a particular service. A typical use case for such a test would be when a customer query or a workload is running with an unusually high latency and the user needs to ensure if the database service used by the workload, is healthy and is not having inherent latency issues impacting the workload / queries.

adbping is an easy to use command line tool that can easily help end users determine the connection and SQL execution latency to benchmark the performance outside of their business workload. Tool is feature rich, allowing users to run the benchmark test with multitude of options including multi client support, multi threaded, configurable connection characteristics like pool size and other options. As of writing this content, we have the command line tool support on macOS and Linux.X64. Upcoming releases of the tool will have support for Windows as well.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.