recently I am using Toad for data analyst and connected to Oracle database, but someone this query kept running in the backgroup. and I kept getting warning from DBA telling me I have a query that’s running for too long.
this is the query shows up at DBA’s script .
SELECT s.synonym_name, s.table_owner, s.table_name, s.db_link,
o.object_type FROM all_synonyms s left outer join all_objects
o on (o.object_name = s.table_name and o.owner = s.table_owner) WHERE s.owner = :owner and o.subobject_name is null and (o.obj ect_type is null or o.object_type NOT LIKE ‘%BODY’) order by s.
anyone knows how to stop this ?