How to use CloudWatch Logs Insights on Amazon RDS for Oracle log files
Click View in Log Insight to search in the log and specify date and time.
Select date & Time and click Apply. Use Filter Criteria bases on your search criteria and Run query
You can use the following CloudWatch query to analysis alert log file
Similar way we can check the Listener Log. Select /aws/rds/instance/<instance name>/listener
Click View in Log Insights and provide the search criteria to search contenct from Listener log
You can use the following CloudWatch query to analysis Listener Log file