Kbase P8355: How to trace queries sent by Progess to Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to trace queries sent by Progress to Oracle
GOAL:
How to find out what SQL statement is been sent to Oracle
FACT(s) (Environment):
Oracle DataServer
FIX:
Use -Dsrv connection parameter with option qt_debug,SQL
The exact parameter is: -Dsrv qt_debug,SQL
Using this option all queries sent by Progress to Oracle through OCI will be written in the dataserv.lg.
P3565, Where does the dataserv.lg file get created?
to find out more about how to locate your dataserv.lg