Please note the following new feature available as part of March 2024 Update of OAC :
OCI Diagnostic Logs now captures Init Block queries and failure messages enabling customers to self-service any issues related to Init Block SQL queries, Init Block failures due to database connectivity issues, etc.
Doc Reference : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/administer-services.html#GUID-4B364390-912B-4765-AF39-5AE134FD7DB3
Queries: Initialization block issues with the initialization block query, timing and error details, and errors during initialization block execution.