DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
DocumentBurster is a tool for report distribution: split, merge, email, and FTP your reports. It has report delivery for Crystal Reports, SSRS Reporting Services, MS Access, Cognos, PeopleSoft, and SAP. It has report bursting for Pentaho, JasperReports, and BIRT. It can upload reports to MS SharePoint.
The YB.ORM library aims to simplify writing C++ code that has to deal with SQL databases. The goal is to provide a convenient interface like SQLAlchemy (Python) or Hibernate (Java). The library itself is cross-platform and supports a variety of SQL dialects: SQLite3, MySQL, Postgres, Oracle, and Firebird. Integration with Boost, Qt4, and wxWidgets is built-in. In a typical usage scenario, you would describe your database schema and table relationships in a simple XML-based format, generate SQL code to populate database schema with tables, generate C++ classes, add application-specific logic to the classes, and use these classes in cooperation with the Session object to query objects from the database, create new or modify/delete existing objects, or link and unlink objects using relations. Simple serialization to XML is supported along with connection pooling.
check_oracle_health is a plugin for the Shinken (Nagios) monitoring software that allows you to monitor various metrics of an Oracle database. It includes connection time, SGA data buffer hit ratio, SGA library cache hit ratio, SGA dictionary cache hit ratio, SGA shared pool free, PGA in memory sort ratio, tablespace usage, tablespace fragmentation, tablespace I/O balance, invalid objects, and many more.
LightProfiler provides performance analysis of Oracle databases. It generates detailed resource profiles for extended SQL trace files, containing information about the consuming of response time (by events, by cursors, etc.), data file usage, error analysis (SQL, PL/SQL), and much more. It also contains tools for additional processing of trace files (extracting session data, splitting files) and for management of a database's sessions (disconnecting, tracing, monitoring parameters, blocking locks, events, etc.).
Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring and performance and availability reporting and measurement for Oracle Databases, along with server performance metrics. It provides an effective mechanism to acquire data from numerous Oracle instances, and in turn provides this information for monitoring and performance metrics to your Zabbix server. You can then utilise the reporting capabilities of Zabbix for all data collected, and provide analysis such as graphs and service level agreement metrics for stakeholders. The current distribution contains a set of pre-defined templates that incorporate alerting and graphing capabilities from initial deployment. However, these can be fine tuned to suit your needs and data/monitoring requirements.
SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.