Toad World® Forums

Query running by itself


#1

Hi,

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.

synonym_name

anyone knows how to stop this ?

Thanks