Oracle JDBC Log Analyzer v1.0.0

The Oracle JDBC log analyzer tool is used to parse and extract meaningful information from JDBC/UCP and RDBMS/SQLNet log files. It allows clients to access, query, and analyze log data stored in a file, whether the log file is located locally on the machine or available on the web (by supplying a URL).

The library support the following log formatters:

• OracleSimpleFormatter (This is the recommended formatter, since it provides more details such as connection id and tenant).
• SimpleFormatter (Default JUL formatter).
• UCPFormatter.

Key Features of JDBC/UCP log parsing:

• Error Retrieval: Access error log entries.
• Insights: Generate statistics and metrics to identify trends (and maybe also anomalies).
• Executed Queries: Retrieve the executed SQL statements with the timestamp and the execution time.
• Connection Events: Retrieve the connection opened/closed events.
• Log Comparison: Compare two log files focusing on performance metrics, error details, and network information.

Key Features of RDBMS/SQLNet trace files parsing:

• Error Retrieval: Retrieve all the reported ORA errors.
• Extract Packet dumps: Extracts all the packet dumps that corresponds with a connection id.