I see the following query several times in top running sql queries. Also, it has over 1000 buffer gets per execution.
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME,
null COLUMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_constraints ac, all_cons_columns acc
where ac.owner = acc.owner and ac.table_name = acc.table_name and ac.constraint_type = 'P' and ac.constraint_name = acc.constraint_name)
DBSCHEMA_PRIMARY_KEYSÂ WHERE TABLE_SCHEMA = 'myschemaname' AND TABLE_NAME = 'mytablename' order by 3, 4
Obviously, it is not a query from my application. Any ideas how to eliminate this ? or at least don't run that many times.