SQL Developer Version: Version 3.2.20.09 - Build MAIN-09.87
OS: Ubuntu 13.04
Java Version: /usr/lib/jvm/java-6-openjdk-amd64
Oracle Version: 11g
1. Connect to database instance.
2. Navigate to a very large table in the Connection tab on the left and click on the table name.
3. Grid appears on the right listing the table columns.
4. Click on the data tab.
5. Connection is currently busy - try again? message appears.
6. SD hangs at this point. Click on the buttons on the error message prompt box and there's no response. Wait for several minutes and nothing happens.
7. Forced to End Process using Ubuntu's System Monitor.
This doesn't happen 100% of the time. But very often. I have 4G of memory on my computer. I did check the memory when this occurred and I was only at 34% of RAM usage.
Please let me know if there is any additional information I can provide.
Message was edited by: user6451593
Connection busy means it is probably running 'select *' on that table to get first n rows. Perhaps you have a large table with lot of empty space? that is the most likely scenario,. is that is the case? you can also see this by running 'select * from that_specific_table' in your worksheet, it will be some time before you will get results back.
Well it is likely that all the blocks needed for your db are in the db_cache now, hence instantaneous data back. if you can bounce the db and try again. However if there is a bug, then all bets are off. I have seen similar behavior on large tables with lot deleted rows on v3 and v4. it just could be your case too.