KeepTool Features

Tool	KeepTool Features	Editions
		Free ¹)	Professional	Enterprise
Each tool	Connect to Oracle database using SQL*Net or build-in direct TCP/IP connectivity Pick up connect string from tnsnames.ora file Sortable history of recent connections Tag connections using personal description or color scheme Various skins to personalize visual experience 32 and 64 Bit versions available Supports Oracle 7.3.4 up to Oracle 23c Fixed workstation or floating network licenses available Easily transfer license between machines
SQL Scratchpad	SQL and PL/SQL syntax highlighting Open SQL from your personal scratchpad tree view Open SQL from Integrated file explorer or FTP source SQL query builder supporting both Oracle and ANSI SQL syntax SQL query execution and updatable result sets Data presentation as grid, record and text view Data presentation as tree and pivot view Data export in MS Excel Data export in various formats such as MS Access, CSV and much more KML export of spatial data and presentation in Google Earth Integrated FastReport engine with automatic and manual layout option Oracle execution plan presentation as collapsible tree view Compare files and highlight differences Expand selected table name to a statement such as SELECT, INSERT, UPDATE or CURSOR FOR LOOP Oracle PL/SQL profiler interface Code completion Delegate SQL execution to SQL*Plus and capture ouput DBMS_OUTPUT window Describe selected object
Data Content Browser	Quick launch list shows tables and views including table comment Click a table or view on the list to open data content view Tab-switch between multiple open table views Data presentation as grid, record and text view Data presentation as tree and pivot view Pick up foreign key values by master table lookup SQL filter text box and WHERE condition wizard Sortable, resizable and hidable columns and build-in filter capabilities Data export in MS Excel Data export in various formats such as MS Access, CSV and much more KML export of spatial data and presentation in Google Earth Integrated FastReport engine with automatic and manual layout option Goto master or detail table along referential integrity and pass key values from current row as filter context to the opened master or detail table Create INSERT, UPDATE, DELETE and MERGE statements from currently selected data and visible columns and copy to clipboard or save to file Optional in-memory grid mode provides additional features such as data grouping, filter value suggestion Tooltip hints for column headers (data type, constraints and column comment), row headers (instant record view) and data cells (foreign key lookup) Save work set of open tables and current filter conditions in an XML file for future use DBMS_OUTPUT window
Tables/Views	Overview of tables and views including properties such as comments, tablespaces, timestamps, storage parameters, statistics, several flags Red highlighting of erroneous views, gray for invalid views. Green highlighting of recently changed tables and views. Confirm button to reset green coloring CREATE, DROP, DELETE FROM and TRUNCATE tables, views and synonyms for tables and views Generate and copy to clipboard SQL statements such as INSERT, SELECT, UPDATA, DELETE, MERGE or CURSOR FOR LOOP Maintenance operations such as tablespace movement, statistics generation, monitoring Search for table, column, constraint or trigger names Show DDL for entire table/view or constraint, index, trigger only Column view with context operations such as rename column, drop column, re-order columns, create sequence, add check constraint Subordinate views for columns constraints, indexes on column, triggers, privileges, histogram, LOB segment storage, column updatability and bounding rectangle for spatial data columns Constraints view with context operations such as create primary or unique key, create foreign key, create check constraint, drop constraint, enable/disable Create index on foreign key columns Show indexes that support the constraint columns Show exceptions for disabled or not validated constraint (data that violates) Create and edit triggers with syntax and PL/SQL error highlighting Wizards to create instead-of triggers for views, mutating table compound triggers and triggers to set primary key value from sequence Manage table and index partitions including subpartitions Manage table and column privileges and show grantees and privileges in cross-table matrix Manage public and private synonyms for the table or view Master/detail table diagram shows ER diagram detail view for the current table and allows you to navigate tables along referential integrity Object dependency view shows objects that depend on or are dependent of the current table or view Data content view opens a data browser for the current table similar to the Data Content Browser including additional Master/Detail view View current table access and manage auditing Detailed table and column statistics view including statistics preferences
Sequences	Overview sequences including time stamps, value range, cycle flags Create, drop or change sequences, increment the counter, show DDL Manage privileges, synonyms, auditing and view object dependencies
PL/SQL	Overview PL/SQL objects such as packages, package bodies, procedures and functions including time stamps and PL/SQL object settings Show packages and their bodies one below the other Red grid highlighting of erroneous objects. Green highlighting of recently changed objects, gray for invalid objects. Confirm button to reset green coloring Create and edit PL/SQL code with syntax and PL/SQL error highlighting Show DB object cache, pin objects to SGA, compile debug, show DDL Call interface generator provides anonymous PL/SQL block for instant procedure calls including dbms_output of return value Manage privileges, synonyms, auditing and view object dependencies
Synonyms	Overview synonyms including referenced object Create, drop or change synonyms, show DDL Manage privileges
Jobs	Manage both Oracle jobs and Oracle scheduler jobs including programs, schedules, windows, window groups and global attributes Create, run, stop, enable and disable jobs Show related Oracle initialization parameter
Pipes	Create and remove dbms_pipes Send and receive messages Purge pipes
DB Links	Create and drop database links Manage synonyms. Show snapshots and transactions Ping remote database
Materialized Views and MView Logs	Materialized Views and MView Logs Show properties such as SQL query, detail relations, joins, keys, aggregates Show granted privileges that are required for operating with Materialized Views Show Materialized View related initialization parameters Refresh Materialized view Show DDL for Materialized View and Materialized View Log
Schema	Cross-table display of objects in schema, grantees (users and roles), and granted privileges Yellow cell background when grantee has a private synonym for the object Reporting capability, create DDL script, export view to MS-Excel, create various administration script The role hierarchy shows a dependency diagram of all roles that received grants from the schema Schema dependencies show a dependency diagram of schema owners that have either dependent objects of the schema or depend on objects of the schema List of invalid objects, PL/SQL errors, not validated constraints, unusable indexes, disabled triggers and context operations to fix these faults Management of schema triggers with syntax and PL/SQL error highlighting Show Oracle recycle bin. Several options to purge recycle bin. Show recently changed objects in grid or calendar view Global schema operations such as constraints and trigger manager, truncate or drop all objects, mask schema data Search all tables in schema for string
Java	Display Java package hierarchy in collapsible tree view Manage Java classes, resources, source code and data Source code editor with syntax and error highlighting Manage privileges, synonyms and object dependencies
Types	Overview collection types, object types, type bodies and incomplete types Source code editor with syntax and error highlighting Show type attributes and methods Manage privileges, synonyms, auditing and object dependencies
Operators	View, create and drop operators Show bindings and arguments
Index Types	View, create and drop index types Show used operators
Dimensions	View, create and drop dimensions View levels and hierarchies
Outlines	View, create and drop outlines Show SQL text
Directories	View, create, drop and change directories Manage auditing and privileges Show DDL
Libraries	View, create and drop libraries Manage auditing Show DDL
XML	Show XML schemas View XSD with syntax highlighting View XML tables and XML views
Tablespaces	Overview Tablespaces including properties such as size, free space, status, statistics, default storage and gauge indicators for percentages Red highlighting of almost full tablespaces Create, drop and change tablespaces Maintenance operations such as switch logging or backup option, change status, coalesce, set as default permanent/temporary tablespace, Show DDL. Diagram view of tablespace size and used space Show datafiles, resize, set online/offline/offline drop Show free space fragmentation of data file Show object segments in datafile Pie diagram view of segment owners and their share of used space and number of segments List of segments in datafile grouped by segment owner and detail list of extents Manage tablespace quota for users Manage clusters in tablespace View sort segment usage and temp segment usage
Users	Overview Users including properties such as time stamps, default tablespaces, number of database objects, several status information Red highlighting of users with elevated privileges such as DBA or SELECT ANY TABLE. Gray highlighting of locked users Create, drop lock, unlock and change users and passwords Show DDL for multi-selected users Show and manage granted roles, object privileges, system privileges and default roles View and manage tablespace quota for the user List of objects owned by the user including timestamps and grouped by object type View tablespace usage of the user Management of schema triggers with syntax and PL/SQL error highlighting Show SQL area utilization of the USER including statistics for each SQL statement View and assign consumer groups Manage auditing by object, statement and privileges
Sessions	Overview sessions including status, blocking, waiting, application info, client, SQL statement incl. syntax highlighting Optional show multi-instance RAC view Blocking sessions are highlighted red, sessions waiting for block release or pipe get are highlighted yellow, killed and inactive sessions gray, active transactions green Kill or disconnect session. Switch SQL trace on or off View locks and waiting session graph (hierarchy). View session transactions, long operations, access and latches View session statistics and wait events View open cursors and syntax highlighted SQL statement
Database	Database overview sheet showing versions of database components, installed options, licenses and other properties such as character set, log mode, global db name and resource costs Database instance information including host name, startup time, archiver status Undo segment list including status, tablespace, size, statistics, extent info and additional undo related information such as undo tablespace size, undo retention time, undo statistics time usage NLS parameters overview for database, instance and session including comment and nls_lang related registry settings of the client Showing session and system related initialization parameters and change in either memory, spfile or both scope List of control files and control file record section Overview database roles and detail views for granted roles, directly and by subordinate role granted object privileges, system privileges and grantees of the role. Manage role privileges using comfortable dialogs Show and manage profiles and resource limits Management of database triggers with syntax and PL/SQL error highlighting List of data files for all tablespaces and similar management functions to the tablespace view Showing ASM disc groups and attributes Zoomable diagram of object owner dependencies of the entire database Show system statistics List of database features, usage and statistics
SGA	Instance SGA view as pie diagram and data grid Show SGA component memory usage SGA relates database parameters Library cache view and DB object cache detail view by namespace Row cache view Buffer cache view by buffer pool and buffer cache related statistics SQL area with several instant filters for top-resource-consuming sessions and SQL display including syntax highlighting System event statistics, wait statistics and system statistics Result cache statistics, parameters and object list SQL plan baselines
Dictionary	List of Oracle data dictionary views grouped by view prefix such as ALL_, DBA_ Search for dictionary views View column list including comments Dictionary view content browser
Data Pump	List of data pump jobs and data pump sessions Display of server host name and data pump directory Add job for export, import or SQL file Stop job View job status
AWR	Requires a valid license for the Oracle Enterprise Manager Diagnostic Pack List of AWR snapshot per instance Create new snapshot Create AWR report View AWR baseline View SQL history for snapshot interval including execution time, SQL statement
Reverse DB	Create DDL script for entire schema from data dictionary information Select database objects Optionally exclude tablespace and storage parameters, reset sequence counter
DB Doc	Create HTML documentation for entire schema from data dictionary information Choose between English and German language option Hyperlinks for cross-references between objects
SQL Editor	Stand-alone version of SQL editor SQL and PL/SQL syntax highlighting SQL query builder supporting both Oracle and ANSI SQL syntax SQL query execution and updatable result sets Data presentation as grid, record, text, tree and pivot view Data export in various formats such as MS Excel, MS Access, CSV and much more KML export of spatial data and presentation in Google Earth Integrated FastReport engine with automatic and manual layout option Oracle execution plan presentation as collapsible tree view Compare files and highlight differences Expand selected table name to a statement such as SELECT, INSERT, UPDATE or CURSOR FOR LOOP Oracle PL/SQL profiler interface Code completion Delegate SQL execution to SQL*Plus and capture output DBMS_OUTPUT window
DB Compare	Compare two database schemas Mark database objects as changed, added or removed Highlight object changes in DDL script Create basic DDL script to consolidate schemas
ER Diagrammer	Create ER diagram for database schema from data dictionary information Automatic layout places independent tables on the left and dependent tables right next to the master table Create multiple subset diagram views for the model Copy diagram subsets to clipboard for use in your own documents Context menu items for table and foreign key definition
PL/SQL Debugger	Debug PL/SQL code Trace into, step over, trace out and run Add, toggle and remove breakpoints View call stack Add watches Evaluate and modify variables dbms_output window

¹) KeepTool Free provides most features mentioned in the appropriate block