Skip to Content
0
Former Member
Nov 14, 2012 at 05:32 PM

Data Dictionary Query - Can We Turn It Off?

52 Views

PB 12.5.1

Every time I go into the SQL of a DataWindow I am left twiddling my thumbs for x number of seconds waiting for the SQL to show. When I query the DB to find out what is it doing it returns a Select against the data dictionary. I realize that this is an Oracle issue (those have gotten very slow in 11g) but it there a way to tell PB not to do this query?

Query:

SELECT F.CONSTRAINT_NAME,F.OWNER,F.R_OWNER,P.TABLE_NAME,SYS.ALL_CONS_COLUMNS.COLUMN_NAME,F.DELETE_RULE

FROM SYS.ALL_CONSTRAINTS F, SYS.ALL_CONS_COLUMNS,SYS.ALL_CONSTRAINTS P

WHERE F.OWNER = 'COMPANY_23' AND F.TABLE_NAME = 'IC_PRODUCT_UOM' AND F.CONSTRAINT_TYPE ='R' AND SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME = F.CONSTRAINT_NAME AND SYS.ALL_CONS_COLUMNS.TABLE_NAME = 'IC_PRODUCT_UOM' AND SYS.ALL_CONS_COLUMNS.OWNER = 'COMPANY_23' AND P.OWNER = F.R_OWNER AND P.CONSTRAINT_NAME = F.R_CONSTRAINT_NAME ORDER BY F.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION

Thanks,

Chris Craft