Oracle 7.3 - Oracle 23ai 20+ years of experience Version (Released: )

Most intuitive Oracle database tools

KeepTool for database administrators

Our focus in database administration is on system-side support for database applications. Our tools cover the management of users, roles, tablespaces, privileges, database objects, and access control lists (ACLs), as well as performance tuning, system security, session monitoring, and pluggable database management.

KeepTool is an ideal companion for performing database administration tasks that come along with either application development or application maintenance. We will point out a few features where KeepTool can help you to perform administrative tasks in less time and more productively.

KeepTool Hora icon

User and privilege management

You can use Hora to create and modify database users and assign roles, object privileges and system privileges. A similar page allows you to create and modify database roles. You can drill down the hierarchy of granted roles and view privileges granted to a particular level of the hierarchy, or include privileges inherited by grants to subordinate roles. You can also reverse-engineer a DDL script for an entire database schema or parts of it. Optionally, data can also be inserted into the script. Right-click on users to create expdp/impdp command templates.

Managing Oracle user privileges, roles, object privileges and system privileges using KeepTool Hora
KeepTool Hora icon

Tablespace management

Hora allows you to create and modify tablespaces and datafiles. You can monitor size and free space as well as quota and space usage of database users. Hora helps you move tables or indexes to another tablespace, including post-processing such as rebuilding indexes.

Managing Oracle tablespaces
KeepTool Hora icon

Session monitoring

The Session Overview page displays a list of all database sessions. Each session is displayed in a different color depending on its status:

  • A green session is currently active
  • A red session is currently blocking another session
  • A yellow session is waiting for something, such as a blocking session or a resource
  • A grey session is currently inactive
Top Oracle sessions monitor, finding blockers
KeepTool Hora icon

Container database management

Hora helps you manage pluggable databases. View a list of containers and use the context menu to start, stop, and clone them.

For each container, Hora displays a history of lifecycle events.

Oracle pluggable/container database management (PDB, CDB)
KeepTool Hora icon

Performance optimization

KeepTool bundles a number of features that can help you optimize your database performance. First, you can open the Explain Plan dialog for the current statement directly from the SQL Editor. Drag-and-drop optimizer hints from the Code Templates pane into the statement and re-open the Explain Plan dialog to see how the changes perform.

Use the built-in PL/SQL profiler tool to monitor PL/SQL execution performance.
For users who have licensed Oracle’s AWR cartridge, KeepTool can generate an AWR report. The SQL History Viewer shows the top activity within each hour, including appropriate statistics such as execution time and number of executions.

AWR - advanced workload repository