Performance issue moving from ODAC 5.7 to ODAC 6.8

[agvillaca]

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

[Plash]

You should set the ExtendedFieldsInfo option of TOraQuery to False to disable this query.