Using Quest SQL Tracker I found out that when editing a package body (not in spec) SQLNav is always making a query
WHERE owner = :owner
AND object_name = :name
AND object_type = :type
AND status = ‘VALID’;
that query happens when changing line, moving the cursor along ,etc…
I think that is to see if the object was compiled with debug. Why it’s doing that all the time?
Also strange if that it will make that query 2 times (!!) for each package body that is in the selected tabs of each editor when saving the preferences or making apply