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.
AgileSites is a framework for Oracle WebCenter Sites (formerly Fatwire) designed to be easy to use and productive. It allows agile development practices and makes development with distributed teams (offshore) possible, trackable, and healthy. It is compatible with standard coding practices so Java developers will feel at home. It uses only documented APIs to keep support and compatibility between Fatwire/Sites versions.
Point-in-time recovery of an Oracle DB entails the use of transaction log files. The set of such logs grows over the lifetime of a DB, and their management often requires that they be copied to remote locations and/or backed up to offline storage. Alv can verify a set of archive logs prior to its use in a DB recovery scenario: checks are made on file size and type, and the checksum of each redo record is verified. The output is a sequence of log file numbers and character codes to indicate status and highlight any gaps in the sequence (which would stall a recovery). Environment variables can be set to allow for custom log file name formats and to check the DBNAME associated with each log.
XIST is an extensible HTML and XML generator. It is also an XML parser with a very simple and Python-esque tree API. Every XML element type corresponds to a Python class, and these Python classes provide a conversion method to transform the XML tree (e.g. into HTML). XIST can be considered 'object-oriented XSLT'. XIST also includes a cross-platform templating language, Oracle utilities, and various other tools.
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.
Oracletool is an interactive, Web-based application for Oracle Database administration. The advantage of Oracletool over non-Web-based tools is that nothing needs to be installed on the client-side machine or in your databases. All you need to use Oracletool, once installed, is a Web browser.
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.).
SAP has three different types of tables: Pooled tables, direct tables, and clusters. Pooled tables pool together several smaller lists and lookups into one table. The format of the pooled tables is basically Cobol Record structure. SAP Pooled Table Viewer uses the SAP data dictionary to create Oracle views that allow easy querying of the SAP data. This makes it easier to integrate with SAP systems where you can use database connectivity and bypass the need for ABAP.