尝试查看表时 Oracle SQL Developer 没有响应（或建议使用 Oracle Mac 客户端）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12877/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)
提问by Tim Trueman
I just get the beach ball all day long (it's been doing nothing for hours). It's not taking CPU, not reading from disk, not using the network.
我一整天都在拿沙滩球（它已经好几个小时无所事事了）。它不占用 CPU，不从磁盘读取，不使用网络。
I'm using Java 1.6on Mac OS X 10.5.4. It worked once, now even restarts of the computer won't help. Activity Monitor says it's "(Not Responding)". Only thing that I can do is kill -9 that sucker.
我在Mac OS X 10.5.4上使用Java 1.6。它工作过一次，现在即使重新启动计算机也无济于事。活动监视器说它是“（无响应）”。我唯一能做的就是杀死 -9 那个傻瓜。
When I sample the process I see this:
当我对这个过程进行采样时，我看到了这个：
mach_msg_trap 16620
read 831
semaphore_wait_trap 831
An acceptable answer that doesn't fix this would include a url for a decent free Oracle client for the Mac.
一个不能解决这个问题的可接受的答案将包括一个适用于 Mac 的免费 Oracle 客户端的 URL。
Edit: @Mark Harrison sadly this happens every time I start it up, it's not an old connection. I'll like to avoid running Windows on my laptop. I'm giving some plugins for my IDE a whirl, but still no solution for me. @Matthew Schinckel Navicat seems to only have a non-commercial Oracle product...I need a commercial friendly one (even if it costs money).
编辑：@Mark Harrison 遗憾的是，每次启动时都会发生这种情况，这不是旧连接。我想避免在我的笔记本电脑上运行 Windows。我正在为我的 IDE 提供一些插件，但对我来说仍然没有解决方案。@Matthew Schinckel Navicat 似乎只有一个非商业的 Oracle 产品......我需要一个商业友好的产品（即使它要花钱）。
采纳答案by Mark Harrison
I get the same problem after there's been an active connection sitting idle for a while. I solve it by restarting sql developer every once in a while.
在活动连接闲置一段时间后，我遇到了同样的问题。我通过每隔一段时间重新启动 sql developer 来解决它。
I also have Toad for Oracle running on a vmware XP session, and it works great. If you don't mind the money, try that.
我还在 vmware XP 会话上运行了 Toad for Oracle，它运行良好。如果你不介意钱，那就试试吧。
回答by Matthew Schinckel
回答by Mark Harrison
Have you looked at http://www.aquafold.com/? They have a very JDBC/java Mac-friendly utility, Aqua Data Studio (ADS) that you can try for I think 30 days. It's not free, but...
你看过http://www.aquafold.com/吗？他们有一个非常适合 JDBC/java Mac 的实用程序 Aqua Data Studio (ADS)，我认为您可以试用 30 天。它不是免费的，但是...
Excellent support via Yahoo groups. VERY responsive re bugs or enhancement requests.
通过雅虎群组提供出色的支持。非常敏感的重新错误或增强请求。
No affiliation with them - just a fan.
与他们没有任何关系 - 只是一个粉丝。
回答by Steve Bower
回答by terson
I use SQLDeveloper on the Mac and have had problems where it becomes unresponsive. Usually, I can fix this by going into the Activity Monitor and killing the process. However, this doesn't always work to end the process. When that happens, I go to the Terminal and find the process id and send it a SIGKILL and then the next time it will work correctly.
我在 Mac 上使用 SQLDeveloper，但遇到了无响应的问题。通常，我可以通过进入活动监视器并终止进程来解决此问题。但是，这并不总是可以结束该过程。发生这种情况时，我会转到终端并找到进程 ID 并向其发送 SIGKILL，然后下次它会正常工作。
However, more importantly I evaluated SQLGrinderat one point. I didn't end up buying the software, largely because I have a Mac laptop and a windows desktop. Therefore, I more often use Toad on the windows desktop and it wasn't worth purchasing SQLGrinder for me.
然而，更重要的是我曾经评估过SQLGrinder。我最终没有购买该软件，主要是因为我有一台 Mac 笔记本电脑和一个 Windows 桌面。因此，我更经常在 Windows 桌面上使用 Toad，不值得为我购买 SQLGrinder。
回答by serg10
回答by stevechol
The latest version of SQL Developer is very good and I have experienced no problems with it on my Mac Pro. DB Solo 3 is also quite good.
最新版本的 SQL Developer 非常好，我在 Mac Pro 上没有遇到任何问题。DB Solo 3 也相当不错。
