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?
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?
Exception in thread "InsightThread" java.lang.IllegalMonitorStateException