Multidimensional Visualization of Oracle Performance Using Barry007

TL;DR

This paper introduces Barry007, a multidimensional visualization tool that enhances Oracle database performance analysis by revealing detailed session-level data and anomalies beyond traditional 2D performance displays.

Contribution

The paper demonstrates the application of Barry007 for multidimensional visualization of Oracle performance data, providing deeper insights into session-level performance and anomalies.

Findings

Barry007 reveals detailed session-level performance trends.

Multidimensional visualization uncovers performance anomalies.

Enhanced analysis over traditional 2D tools.

Abstract

Most generic performance tools display only system-level performance data using 2-dimensional plots or diagrams and this limits the informational detail that can be displayed. Moreover, a modern relational database system, like Oracle, can concurrently serve thousands of client processes with different workload characteristics, so that generic performance-data displays inevitably hide important information. Drawing on our previous work, this paper demonstrates the application of Barry007 multidimensional visualization to the analysis of Oracle end-user, session-level, performance data, showing both collective trends and individual performance anomalies.