Toad World® Forums

SQLNav stops responding on connect / TeamCoding issue?


Recently we’ve switched to a new production database and whenever I’m trying to connect to a read-only developer schema SQL Navigator freezes and stops responding for 5-10 minutes. It does not happen every time and I have no idea what it tries to do.

Today I’ve tried to close it with [X] and got the usual windows prompt - “SQL Navigator is not responsding. Try to restore the program, close, wait to respond”. After selecting ‘try to recover’ SQL Nav came back to life and I’ve got the following error message:

13:34:45 Error initializing Team Coding: ORA-03113: end-of-file on communication channel

Well, as I said, I’m trying to connect to a production database and I do not expect any TeamCoding configuration there. Also since my team does not use this TeamCoding feature, is there any way to disable it completely so SQL Nav does not try to initialize it every time I try to connect to a database? At this poing this is beyond being simply annoying.

Forgot to mention, that’s SQL Nav 6.7

Message was edited by: ashmelev


never mind, looks like it is the same issue as I’ve reported before - SQL Nav attempts to do this:

select count(rownum) from sys.DBA_OBJECTS

select count(rownum) from sys.DBA_TABLES

and so on…
On that particular database these SQLs are VERY VERY VERY SLOW by some reason.

Message was edited by: ashmelev



Message was edited by: ashmelev