Programming Languages & Frameworks

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OCI instantclient Tracing on client side

Sheeraz MajeedMay 9 2024 — edited May 9 2024

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

Added on May 9 2024

3 comments

293 views