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.
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.
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.
The Session Overview page displays a list of all database sessions. Each session is displayed in a different color depending on its status:
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.
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.
