Logging options
- Last UpdatedJan 04, 2023
- 1 minute read
- PI System
- PI SQL Client ODBC 2021
- Developer
For performance reasons and to understand unexpected results, it is very important to recognize the difference between the heterogeneous query that is executed in the Oracle client and the remote query that is executed by the Oracle Database Gateway.
The remote query is visible at various levels by using logging options:
-
Oracle Database Gateway tracing (see FDS_HS_TRACE_LEVEL)
-
PI SQL Client ODBC logging
-
PI SQL Data Access Server (RTQP Engine) logging
Note: Using logging options can degrade performance, so logging should normally be disabled.