When you look at the Oracle productivity and admin tools currently on the market, you’ll see some primarily oriented toward developers, and others toward DBAs.
This is exactly what makes KeepTool different. In fact, you won’t find the word “Developer” or “DBA” in any of our product names. With KeepTool Professional, no add-ons are needed to perform key DBA functions. Our core tool, Hora, offers both the developer and the administrator a wealth of ways to view and manipulate the database — without the up-front need for a tutorial. Once they’ve experienced a few of Hora’s pages, they’ll find the rest to be surprisingly similar, since each features the same three-fold approach to the task at hand: Overview, Drill-down, and Build.
Packaged with Hora are complementary tools to automate the generation of documentation and DDL for all or selected objects belonging to a user — and an extremely customizable SQL Editor that can be be used even offline and associated with any file types that you specify. Check out the market, and you will be hard-pressed to find any other software that offers so much functionality for the price.
To code your CREATE OR REPLACE statement, you can start from a built-in template (further customizable to your company’s standards) or by copying an existing definition. Syntax errors are highlighted and identified by line number, making them easy to fix and retry.
When you’re ready to test, Hora furnishes a skeleton calling block for each procedure or function, with default values for the required parameters.
After developing and testing, you’re just a click away from viewing your objects or another user’s. Data displayed for each PL/SQL object includes synonyms and privileges, which you can easily create or modify from the context menu.
On the Overview tab, you’ll find essential information such as SID, user, application, client machine for each current session. A separate panel lists the current SQL statement for the highlighted row. A context menu also allows authorized users to kill a session, turn SQL Trace on, or move a session to a different consumer group.
Additional tabs drill down on other details of the selected session, such as locks, latches, accessed objects, I/O statistics, open cursors…and more, allowing the DBA quick access to needed information without the need to find and run queries against the data dictionary views.
As is the case with all of Hora’s grid views, several powerful filtering options are available. If, for example, you’d like see only the sessions with open transactions, it’s quite simple.
If you’ve created a view on various joined tables, and now want to make it updatable, so that the view’s column names can be referenced for inserts, updates and deletes on the underlying table, you can create an INSTEAD OF trigger that turns DML on the view into DML on the base tables.
Hora provides a wizard to walk you through building the required PL/SQL in a 4-step process:
No need about column names, key columns and their relation – just supply the essentials.
As a DBA, you’ve never had a moment where you’ve needed to answer a question by consulting a data dictionary view, whose exact name you may have forgotten. For other users, KeepTool’s Data Dictionary View can help you out.
When first opened, the Data Dictionary asks you to expand a tree view by prefix: USER_, DBA_ or V$, for example. Highlight the one that you’re interested in; then click the Columns or Data Browser tab.
In a particularly large table like DBA_TABLES, you can then filter on any of the columns. Say you’re not sure of the owner, or the exact table name-in that case, just filter on a LIKE expression.
Although the Data Dictionary viewer appears on Hora’s DBA page, it is not only for DBA’s. Granting the HORA_USER role gives SELECT privileges on all the DBA_, GV$ and V$ views, allowing your developers a view of the dictionary.
If your Oracle project teams use any type of HTML platform, such as a corporate Intranet or wiki, to maintain ongoing documentation for applications as they change over time, you will find that KeepTool Professional’s Documentation Generator can save you a lot of manual work.
The Generator builds an HTML page listing all metadata for a schema’s objects, including tables, views and PL/SQL program units. Tables and views list all columns and their attributes, constraints, indexes and triggers, along with any comments that have defined. DDL is included for views as is source code for PL/SQL objects is included. Hyperlinks connect related objects.
View the result in your browser, explore the options, save it, and you’re done!
Corporate Help Desks are often confronted with calls from users who can’t view or update data that their co-workers can. Often, this stems from changes to their underlying privileges as a database user, and as a result, second-line support is called upon to look at the database for an answer.
If a user can update a table that another user can’t, the reason may not readily be apparent by querying table privileges, because in most cases privileges are granted through roles.
This picture is taken from Hora’s Database page. The tilde (~) indicates object privileges that have been granted through roles. By selecting a different user, it becomes easy to see if that user has any access to a particular object, either directly or through a role. A similar view on the Users page shows all roles that have been granted to or by a particular user.