I am new to Oracle OCI. Is there something that I can use in Oracle OCI to trace all OCI function calls done? I cannot use Oracle server-side tracing, partly because I don't have sufficient permissions. I tried SQL*Net trace, but it did not show any dynamic SQL statements from OCI.
I am using windows 11 with instantclient 21.3. there was no network/admin/sqlnet.ora file. i created with following settings:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
TRACE_LEVEL_CLIENT=16
TRACE_FILE_CLIENT=sqlnet.trc
TRACE_DIRECTORY_CLIENT=c:\temp
LOG_DIRECTORY_CLIENT=c:\temp
TRACE_UNIQUE_CLIENT=TRUE
TRACE_TIMESTAMP_CLIENT=TRUE
DIAG_ADR_ENABLED=ON