Dialog "Connected to Database <DB_NAME>" hangs too long

Question

Each time a member of our team tries to do something with the database (create entity from table, test a query etc.) a dialog "Connected to Database" is shown and it hangs there for a very long time (5-10 minutes). If you cancel it, it closes and reappears again after few seconds and if you do not touch anything it will again periodically disappear and show again.

Perhaps its worth mentioning that our team is producing ADF application with ADF Business Components and project has around 40 root modules (so each has its own database connection).

Is anybody aware of this phenomena and has any ideas about speeding it up ? The thing happens from both JDeveloper and SQLDeveloper.

Answer 1

Hey even i faced a similar problem.

Might be you are trying to access a locked object.

Please release the locks of the objects before accesing them.

Also close the sql developer using the task manager.

And now restart it again.

Also you can use the sql developer application in the bin folder as it logs the exact cause of such an error.