Hora feature list

Feature list

(Feature lists of other tools)

General Features

  • Connect to Oracle 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 12c
  • 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

Databrowser

  • 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/MERGE js 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
  • Schema dependencies show a dependency diagram of schema owners that have either dependent objects of the schema or depend on objects of the schema
  • 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 block waiting graph
  • 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

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
© 2018 KeepTool GmbH. All rights reserved