Commercial Oracle performance tool

OraBooster

AvailabilityReleased · Available now

OraBooster.
Oracle performance diagnostics and tuning.

Go from a CPU spike to the SQL behind it, and on to its execution plan, in a few clicks. Nothing is installed on the monitored database. Connect with a DBA-privileged account and start working.

Closed-source commercial software

OraBooster is a commercial product, not open source.

OraBooster · ASH ExplorerLIVEAVERAGE ACTIVE SESSIONSCPU14:20 – 14:35TOP SQL · SELECTED RANGE5x8093g70xhrt62%3r51tcp39wj2121%7s0ddsgj4knm69%363pwb40bd0nb5%Runtime PlanNOWAWRCONCEPT VIEWRANGE → TOP SQL → PLAN

See what changes

From a CPU spike
to the SQL behind it, in a few clicks.

  1. 01

    Real-Time Gauge

    Drag across the period where CPU usage was high.

  2. 02

    ASH Explorer

    One right-click takes you there, showing that period’s top SQL, sessions and wait events.

  3. 03

    Runtime Plan Viewer

    From the SQL_ID, compare the current and earlier execution plans.

  4. 04

    SQL Runner

    Review the estimated plan with bind variable values already filled in, then tune.

Instead of opening menus one at a time, you carry the selected time range and SQL to the next screen.

An illustrative flow showing how menus link together. Available menus and features depend on the version and configuration of the target database.

Inside OraBooster

OraBooster,
as it actually looks.

Actual captures of the multi-instance dashboard, ASH Explorer, session, execution plan and SQL tuning screens.

OraBooster / OverviewActual capture · Earlier version
Actual OraBooster screen: a dashboard gathering OS utilization and average active session charts for several instances
OraBooster / ASH ExplorerActual capture · Earlier version
Actual OraBooster screen: selecting a range on the active session history chart shows its top SQL, wait events and sessions
OraBooster / Session MonitorActual capture · Earlier version
Actual OraBooster screen: the session list and the execution plan of the selected session
OraBooster / Runtime Plan ViewerActual capture · Earlier version
Actual OraBooster screen: the current and earlier execution plans side by side
OraBooster / SQL RunnerActual capture · Earlier version
Actual OraBooster screen: the SQL editor, bind variables and the estimated execution plan

These screens were captured from an earlier version. The current version may look different. Some connection details are masked.

A commercial Oracle performance diagnostics and tuning tool

Useful capabilities
for everyday work.

See the server’s condition on one screen

OS CPU usage is shown alongside wait events and Time Model metrics. Check whether CPU is short and which waits have grown, all in one view.

Find the problem session quickly

Filter sessions by state, user or program, and read the execution plan of the SQL a selected session is running, right there. You can also find a session by its OS PID.

Pick a time range, see the SQL behind it

ASH and AWR data are drawn as charts. Drag across a busy period to see its top SQL, sessions and wait events.

Compare how an execution plan changed

Enter a SQL_ID to view the current plan next to earlier plans kept in AWR. Check whether a statement that suddenly slowed down changed its plan.

A workspace for SQL tuning

Refine SQL while viewing the estimated plan together with table and index details. The time and blocks each step of the actual plan consumed are charted as well.

Reports and routine checks

Create and save ASH, AWR and ADDM reports from the screen. Locks and transactions, tablespace usage and the alert log are in the same tool.

No installation on the database

Nothing is installed on the target database.
Connect and start.

No objects on the target database

OraBooster creates no tables, packages or other objects in the database it monitors.

No server agent or logging server

There is nothing to install on the database server, and no separate server is needed to keep analysis data.

Connect with a DBA-privileged account

Sign in as SYS, SYSTEM or another account with DBA privileges and monitoring starts right away.

The Oracle connectivity module and the .NET runtime are included in the installer, so no separate Oracle Client is needed on the PC.

Supported environments

From 11gR2
to the latest 26ai.

Target database
Oracle Database 11gR2 (11.2.0.4) through the latest 26ai
Where it installs
Windows 11, Windows 10 and Windows Server 2016 or later (x64 only). The .NET 10 runtime is included in the installer.
Account
SYS, SYSTEM or an account with DBA privileges

Evaluation copy

Download the evaluation copy
and see for yourself.

Where to download
Get the installer for the latest version (OraBooster_setup_<version>_x64.exe) from the orabooster-download repository on GitHub.
Evaluation period
The program runs as an evaluation copy for six months from the day you first run it, with every feature available.
Installation
Install with administrator rights on 64-bit Windows. No separate .NET or Oracle Client installation is needed.

The download page is on GitHub. To use a purchased license, register it from the registration menu in the program. github.com/orascope/orabooster-download/tags

OraBooster adoption

What we review
after you get in touch.

  1. 01

    Discuss your environment

    Tell us the Oracle versions and number of instances to monitor, and the performance problems you most want to solve.

  2. 02

    Review an evaluation copy

    Download the evaluation copy and check connectivity and key features in your own environment. Every feature is available for six months.

  3. 03

    Discuss licensing

    Use the findings to discuss the number of instances and scope of support.

Use cases

Put it to work.

Finding the cause during an incident

Select the period when CPU usage or active sessions surged and see the SQL and wait events from that moment.

Tuning SQL that slowed down

Compare plans to see whether one changed, then refine the SQL in SQL Runner while viewing its execution plan.

Routine checks and reporting

Prepare review material with AWR and ADDM reports and performance charts for a chosen period.

How it connects

See how it
fits together.

OraBooster is installed on a PC and connects to Oracle Database with a DBA-privileged account. It reads the performance views and ASH and AWR data that Oracle provides, and installs no objects or agents on the target database.

Explore the system diagram
OraBooster is installed on a PC and connects to Oracle Database with a DBA-privileged account. It reads the performance views and ASH and AWR data that Oracle provides, and installs no objects or agents on the target database.
A conceptual view of the main connections.

FAQ

A few things
worth knowing.

Is OraBooster open source too?

No. OraBooster is a commercial product developed by ORASCOPE. Its source code is closed and it is provided under a commercial license.

Where can I get the evaluation copy?

Download the installer for the latest version from the orabooster-download repository on GitHub. It runs as an evaluation copy with every feature available for six months from the first run. The link is in the evaluation copy section of this page.

What must be installed on the monitored database?

Nothing. OraBooster creates no objects in the target database and installs no agent on the server. Connect with a DBA-privileged account and it is ready to use.

Which Oracle versions are supported?

Oracle Database 11gR2 (11.2.0.4) through the latest 26ai. CDB and PDB structures introduced in 12c are shown separately on screen.

Do I need to install Oracle Client?

No. The Oracle connectivity module is included in the program. Connect using a TNSNAMES.ORA file, or with just an IP address, port and service name.

Which PCs can it be installed on?

64-bit Windows 11, Windows 10 and Windows Server 2016 or later. The .NET 10 runtime is included in the installer, so there is nothing else to prepare.

What should I check before using ASH and AWR features?

OraBooster reads the ASH, AWR and ADDM data that Oracle provides. Please confirm that the Oracle license terms of the target database allow those features to be used.

What should I share when asking about adoption?

Tell us the Oracle versions and number of instances to monitor, the number of users, and the performance problems you most want to solve. We will review the license configuration together.

OraBooster

Let’s look at your
Oracle performance.

Tell us your Oracle versions, the number of instances and the problem you want to solve.

Discuss adoption
Product architecture overviewDownload SVG ↓