SYSTEM$GET_APPLICATION_SERVICE_LOGS

Returns the container logs for a running Application Service. Use this function to troubleshoot a deployed application.

Syntax

SYSTEM$GET_APPLICATION_SERVICE_LOGS( '<service_identifier>' [ , <tail_lines> ] )

Arguments

service_identifier
Fully qualified or unqualified identifier of the Application Service.
tail_lines

Optional integer specifying the number of lines to return from the tail of the log. The default is 500.

Returns

A string that contains the concatenated log output from the service containers.

Access control requirements

The role must have the MONITOR privilege on the Application Service.

Usage notes

  • The service identifier must be enclosed in single quotes.
  • The service must be in a running state to return container logs. For a suspended service, the function returns an empty result.
  • For structured logs routed through an active event table, query the event table directly. For more information, see Logging, tracing, and metrics.

Examples

SELECT SYSTEM$GET_APPLICATION_SERVICE_LOGS('my_db.my_schema.my_app');