PowerBuilder performance issue?
we have a PowerBuilder application and we have noticed a performance issue. It seems that the following SQL statement is called continuously and it causes severe delays and performance impact:
SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM
SYS.ALL_CONSTRAINTS,SYS.ALL_CONS_COLUMNS WHERE SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND
SYS.ALL_CONSTRAINTS.TABLE_NAME = 'OLRIVI' AND SYS.ALL_CONSTRAINTS.OWNER = 'XYZ' AND
SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND
SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND SYS.ALL_CONSTRAINTS.OWNER =
SYS.ALL_CONS_COLUMNS.OWNER ORDER BY
The database versions are 10g and 11g. Any ideas, how to cache, speedup or turn off the statement?
Thanks in advance,