Simplify Oracle Database Administration

When it comes to database administration, KeepTool provides comprehensive system-side support for Oracle database applications. Our tools streamline the management of users, roles, tablespaces, privileges, database objects, and access control lists (ACLs). They also assist with performance tuning, system security, session monitoring, and pluggable database management.

Whether you’re working on application development or application maintenance, KeepTool is the ideal companion for routine and advanced DBA tasks. It helps you get the job done faster, more efficiently, and with greater confidence.

Below, we’ll highlight some key features that show how KeepTool can simplify administrative work while boosting your productivity.

Free Download
KeepTool Hora icon

User and Privilege Management for Oracle DBAs

Managing users, roles, and privileges is a core responsibility for Oracle database administrators. With Hora, these tasks become faster, clearer, and easier to maintain.

Key Capabilities

  • User and Role Management: Create and modify database users, assign roles, and manage both object and system privileges. A dedicated page also allows you to create and maintain database roles.

  • Privilege Hierarchy Exploration: Drill down into the hierarchy of granted roles to view privileges at any level. Easily distinguish between directly granted privileges and those inherited from subordinate roles.

  • Schema Reverse Engineering: Generate DDL scripts for an entire schema or selected parts of it. Optionally, include data inserts within the script for full reproducibility.

  • Integration with Oracle Utilities: Right-click on users to quickly create ready-to-use expdp and impdp command templates for data export and import.

Benefits for DBAs

With Hora’s user and privilege management, Oracle DBAs can:

  • Simplify the administration of complex user and role structures.

  • Gain transparency into privilege hierarchies to improve security and compliance.

  • Save time by generating scripts for schema deployment or migration.

  • Streamline export/import operations without manual scripting.

By combining usability, transparency, and automation, Hora makes user and privilege management a reliable tool for Oracle database administrators.

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

Tablespace Management for Oracle DBAs

Efficient tablespace management is essential for maintaining performance, stability, and scalability in Oracle databases. With Hora, DBAs can easily create, monitor, and adjust tablespaces while keeping full control over storage utilization.

Key Capabilities

  • Tablespace and Datafile Management: Create and modify tablespaces as well as manage associated datafiles.

  • Space Monitoring: Track total size, free space, and user quotas to prevent bottlenecks and ensure optimal allocation.

  • Detailed Usage Insights: Monitor space usage at the user level for proactive capacity planning.

  • Object Relocation: Move tables or indexes seamlessly to another tablespace. Hora also handles necessary post-processing tasks such as index rebuilding.

Benefits for DBAs

With Hora’s tablespace management, Oracle database administrators can:

  • Simplify daily storage administration with an intuitive interface.

  • Optimize performance by balancing object placement across tablespaces.

  • Anticipate capacity issues with real-time monitoring of space usage.

  • Save time through automated post-processing steps like index rebuilds.

By combining ease of use, monitoring, and automation, Hora ensures efficient and reliable tablespace management for Oracle databases.

Managing Oracle tablespaces
KeepTool Hora icon

Session Monitoring for Oracle DBAs

Monitoring active database sessions is crucial for diagnosing performance issues and maintaining database stability. The Session Overview page in Hora gives DBAs a clear, real-time view of all sessions, making it easy to detect and resolve problems quickly.

Key Capabilities

  • Comprehensive Session List: View all database sessions in a single, consolidated overview.

  • Color-Coded Status Indicators: Instantly recognize the state of each session:

    • Green – Active session

    • Red – Session blocking another session

    • Yellow – Session waiting for a resource (e.g., blocked by another session)

    • Grey – Inactive session

  • Real-Time Insights: Quickly identify bottlenecks, blocking chains, and resource contention.

Benefits for DBAs

With Hora’s session monitoring, Oracle DBAs can:

  • Detect and resolve blocking sessions before they affect performance.

  • Gain immediate insights into overall session activity.

  • Proactively monitor resource waits to avoid downtime.

  • Maintain database health with a simple, intuitive interface.

By combining clarity, visualization, and real-time monitoring, Hora makes it easier for DBAs to keep sessions under control and ensure smooth database operations.

Top Oracle sessions monitor, finding blockers
KeepTool Hora icon

Container Database Management for Oracle DBAs

Managing pluggable databases (PDBs) within a container database (CDB) is a core task for Oracle DBAs. With Hora, administrators can easily monitor and control container environments through a clear, user-friendly interface.

Key Capabilities

  • Comprehensive Container Overview: Display a complete list of all containers and their current state.

  • Lifecycle Management: Use the context menu to start, stop, or clone pluggable databases with just a few clicks.

  • Event History Tracking: For each container, Hora maintains a detailed history of lifecycle events, providing full transparency and traceability.

Benefits for DBAs

With Hora’s container database management, Oracle DBAs can:

  • Simplify the administration of multitenant environments.

  • Quickly provision or decommission pluggable databases as needed.

  • Improve accountability with clear lifecycle event tracking.

  • Save time and reduce errors through intuitive, menu-driven actions.

By combining ease of use, visibility, and control, Hora makes container database management more efficient and reliable for Oracle administrators.

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

Performance Optimization for Oracle DBAs

Ensuring peak database performance is one of the most important responsibilities of Oracle DBAs. KeepTool provides a rich set of features to help analyze, troubleshoot, and optimize database workloads efficiently.

Key Capabilities

  • Explain Plan Analysis: Open the Explain Plan dialog directly from the SQL Editor to review query execution strategies. Apply optimizer hints via drag-and-drop from the Code Templates pane, then re-check the Explain Plan to immediately evaluate the impact.

  • Optimizer Hints Made Easy: Experiment with query tuning without manually editing SQL code.

  • PL/SQL Profiler: Monitor execution performance of PL/SQL blocks, procedures, and functions to identify bottlenecks.

  • AWR Reporting (Optional): For users with an Oracle AWR license, KeepTool can generate detailed Automatic Workload Repository (AWR) reports for advanced performance analysis.

  • SQL History Viewer: Gain insight into top SQL activity per hour, including execution times, frequency of execution, and other performance statistics.

Benefits for DBAs

With KeepTool’s performance optimization features, Oracle DBAs can:

  • Tune SQL queries interactively and validate improvements immediately.

  • Detect and resolve performance bottlenecks in PL/SQL applications.

  • Leverage AWR reports for deep workload analysis when available.

  • Monitor workload trends over time to ensure consistent performance.

By combining analysis, tuning, and monitoring, KeepTool equips DBAs with the tools needed to maintain high-performing Oracle databases.

AWR - advanced workload repository

Explore More Examples & Applications

Application Development
Application Support