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