Skip to content

SQL Tracing

OData provider supports generating and tagging SQL trace files in the Oracle database. This can be useful when debugging and monitoring the database calls associated with the web requests.

Enabling SQL Tracing

To enable SQL tracing, OData provider should receive the request header X-IFS-Trace-Id with a value of five alphanumeric characters (eg: 1X2y3). After sending the request header, OData Provider will alter the database session to create a new trace file. If the trace file gets created you will receive the response header X-IFS-Client-Id, this client ID will be useful to separate the respective trace file from all the ‘_IFS.trc’ files. For a given X-IFS-Trace-Id request header, the client ID will always be the same. This would make it possible to control the tagging of Oracle trace files from the client side.

More information about SQL Tracing is available at Foundation 1 -> Development Guide -> Core Server -> Base Server Dev -> Tracing_and_diagnostics -> Sql Trace.