Skip to Content
avatar image
Former Member

Sys.all SQL statements?

Hello all,

we have a PowerBuilder application (version 12.5) 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

SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME,SYS.ALL_CONS_COLUMNS.POSITION

The database versions are 10g and 11g. Any ideas, how to cache, speedup or turn off the statement?


We have tried to change PB.ini options (noCatalog and StaticBind) modifing the file without success.

Thanks in advance,

Mika

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 30, 2014 at 10:59 AM

    Hello,

    It seems that is the same subject as this topic : http://scn.sap.com/thread/3658794

    Anthony

    Add comment
    10|10000 characters needed characters exceeded