3 Replies Latest reply: Jan 17, 2013 11:14 AM by Gary Graham-Oracle RSS

    Cannot view table list, nor execute large queries

    985134
      Hi,

      We recently moved our database into a hosted environment (and migrated from 10g to 11g), since doing this, on one of our schemas, I can no longer get a list of tables, nor can I execute any queries where the resulting dataset is more than a few rows.

      Running same queries on the database directly is fine. The data set isn't particular large, and both sides of the infrastructure are decent sized internet links. Querying our existing MySQL tables via a separate ID does not have this same problem.

      We can also list tables from other Oracle Schemas.

      We have found that if we use a filter on the table list, we can get some results. We have about 370 tables in this schema.

      Has anyone else experienced this before? Anyone have any great ideas on how to fix? Could it be database configuration in anyway?

      Thanks in advance!
      Martin.
        • 1. Re: Cannot view table list, nor execute large queries
          Jeff Smith Sqldev Pm-Oracle
          What happens when you try to execute queries and view the tables - do you get an error message?

          Can you try the directions here and look to see if any exceptions are logged when you attempt those tasks?
          http://www.thatjeffsmith.com/archive/2012/06/how-to-collect-debug-info-for-oracle-sql-developer/

          Share your findings here.
          • 2. Re: Cannot view table list, nor execute large queries
            985134
            Hey - The only response we see is;

            Exception in thread "InsightThread" java.lang.IllegalMonitorStateException
            at java.util.concurrent.locks.ReentrantLock$Sync.tryRelease(ReentrantLock.java:127)
            at java.util.concurrent.locks.AbstractQueuedSynchronizer.release(AbstractQueuedSynchronizer.java:1239)
            at java.util.concurrent.locks.ReentrantLock.unlock(ReentrantLock.java:431)
            at oracle.dbtools.raptor.insight.SynonymsCache.getTable(SynonymsCache.java:82)
            at oracle.dbtools.raptor.insight.InsightableOracleDatabase.prepareColumns(InsightableOracleDatabase.java:313)
            at oracle.dbtools.raptor.insight.CompletionInsight.complete(CompletionInsight.java:731)
            at oracle.dbtools.raptor.insight.CompletionInsight$InsightThread.run(CompletionInsight.java:504)
            • 3. Re: Cannot view table list, nor execute large queries
              Gary Graham-Oracle
              Hi,

              Not sure if we have enough to log a bug -- it looks like we are trying to release a lock and that is failing. Broken connection?

              Anyway, as a workaround, you might try disabling code Completion Insight:
              Tools -> Preferences -> Code Editor -> Completion Insight
              Regards,
              Gary
              SQL Developer Team