Kbase P115246: Dataserv.lg shows loop of oparse for same select
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
Oracle DataServer
Oracle 8.1.7
SYMPTOM(s):
bad performance for a certain query
loop of 996 "oparse" for the SELECT corresponding to the query seen within dataserv.lg
query is using JOIN-BY-SQLDB
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Add "QUERY-TUNING(NO-JOIN-BY-SQLDB)" or compile the program containing the query within a session started with "-nojoinbysqldb" parameter.