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.