Performance issue moving from ODAC 5.7 to ODAC 6.8
Posted: Wed 26 Aug 2009 11:48
Hi,
I recently changed my ODAC version from 5.7 to 6.8 and I'm having some performance problems in querys. In Oracle trace file, one new query appeared and it's costing a big time. This query is:
SELECT synonym_name, table_owner, table_name, db_link
FROM
all_synonyms WHERE (synonym_name = 'DUAL' AND owner IN ('BIBLIOTECA',
'PUBLIC') ) ORDER BY decode(owner, 'PUBLIC', 1, 0)
Why ODAC does this query? Why this query do not appear in OraSQLMonitor? Is there any property in OraSession or SmartQuery that I can use to disable this query?
Thanks a lot
Alexandre
I recently changed my ODAC version from 5.7 to 6.8 and I'm having some performance problems in querys. In Oracle trace file, one new query appeared and it's costing a big time. This query is:
SELECT synonym_name, table_owner, table_name, db_link
FROM
all_synonyms WHERE (synonym_name = 'DUAL' AND owner IN ('BIBLIOTECA',
'PUBLIC') ) ORDER BY decode(owner, 'PUBLIC', 1, 0)
Why ODAC does this query? Why this query do not appear in OraSQLMonitor? Is there any property in OraSession or SmartQuery that I can use to disable this query?
Thanks a lot
Alexandre