Oracle Enterprise Manager 对资源的消耗有多大?
我正在使用基于 Oracle 数据库构建的医疗记录系统。 我们的供应商刚刚告诉我们,当我们不使用Oracle的企业管理器服务时,我们需要关闭它,因为它使用了太多的系统资源。 我知道我可以通过检查 Sysinternals Process Explorer 获得实际数字,但我希望有人可以根据他们的个人经验向我提供信息。
完成后我是否需要关闭 EM,还是他过于担心了?
I'm using a medical records system built on an Oracle database. Our vendor just told us that we need to shut down Oracle's Enterprise Manager service when we're not using it, because it uses too much of the system's resources. I know I can get actual numbers by checking Sysinternals Process Explorer, but I was hoping that someone can give me info from their personal experience.
Do I need to shut down EM when I'm done with it, or is he being overly concerned?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
我们也在测试和生产服务器上做同样的事情。 我没有任何可用的指标,但它确实在整体数据库响应方面取得了显着的改进
We do the same thing on our testing and production servers too. I don't have any metrics to hand, but it did make a noticeable improvement in overall database response
EM 不应该那么具有侵入性。 我发现在默认安装 (YMMV) 下,每 30 秒会占用大约 10% 的 cpu 不到 2 秒,而当系统处于负载状态时,它甚至似乎不会这样做。
当我在这里谈论 EM 时,我不是在谈论 oracle.exe 进程上的负载,而是在谈论 nmesrvc 及其生成的 perl、cmd 和 emagent 进程的负载。 要了解它对数据库本身的影响,需要一点预言机专家的知识。
我发现进程资源管理器是一个很好的工具,可以帮助实时查看此过程,因为它显示了来自服务父 nmesrvc 的进程层次结构。
坦率地说,如果您在停止 dbconsole 服务时实际上看到了最终用户的差异,那么您的盒子已经超出了容量,您可能需要升级或退出。
如果您使用不同的工具来管理和监视 oracle 和其他应用程序进程,则没有太大必要让 dbconsole 进程始终运行。
要获得该领域一些顶尖人士回答的有关 Oracle 的非常具体的问题,请查看 Oracle-L 邮件列表。 响应时间令人惊叹,而且答案的质量通常比您在其他地方找到的要好。
EM should not be that intrusive. I find that it takes about 10% cpu for less then 2 seconds every 30 seconds with the default install (YMMV) and when the system is under load, it doesn't even seem to do that.
When I talk about EM here, I am NOT talking about the load on the oracle.exe process, but instead from the nmesrvc and the perl, cmd and emagent processes it spawns. To see its impact on the database itself requires a bit of an oracle expert.
I find process explorer a nice tool to help review this real time because it shows the process hierarchy from the service parent nmesrvc.
Frankly, if you're actually seeing an end user difference when stopping the dbconsole service, then your box is over capacity and you likely need to grow up or out.
If you use a different tool to manage and monitor oracle and other application processes, there's not much need for the dbconsole process to run all the time.
To get very specific questions about Oracle answered by some of the top people in the field, check out the Oracle-L mailing list. Response times are amazing and the quality of answers are typically better then you'll find in other places.
我发现仅运行 Oracle EM 就会占用大量资源,具体取决于您要求它执行的操作。 我发现我很少使用开箱即用的配置,通过删除不需要的服务,我可以大大减少 EM 所需的资源量。
一般来说,我在单独的应用程序服务器上运行 EM,而不是在我的数据库服务器上。 EM 的真正力量和价值在于运行/维护/监控多个数据库时,并且将 EM 放在自己的服务器上意味着我不必担心它会影响任何数据库。
EM 所做的每一件事,你都可以手动完成,如果只管理一个数据库,我通常会走这条路线。 然而,这条路线确实需要一定水平的 DBA 知识。
I have found that just running Oracle EM can take a lot of resources depending on what you are asking it to do. I have found that I have rarely used the out of the box configuration and by removing services I don't need I can reduce the amount of resources EM needs considerably.
In general, I run EM on a separate application server, not on my DB server. The real power and value of EM is when running / maintaining / monitoring multiple databases and having EM on its own server means I don't have to worry about it affecting any of the DBs.
Everything that EM does, you can do manually and I usually go down this route if just managing one DB. However, this route does require a reasonable level of DBA knowledge.
我立即想到的唯一一件事是企业管理器(适用于 Oracle 9 及之前版本)是基于 Java 的。
我想这可能会给它带来一些资源使用失控的可能性,但我从未在我使用过它的任何机器上看到任何证据。
The only thing that immediately springs to mind to me is that the Enterprise Manager (for Oracle 9 and pre) was Java based.
I guess that would give it the potential for a bit of runaway resource usage, but I have never seen any evidence of that on any of the machines that I have used it on here.
Oracle 的 EM 使您可以配置掉大部分开销。 此开销包括轮询许多服务以在满足阈值时报告警报或提供性能图表。 话虽这么说,如果您配置了这些功能,那为什么还要运行它呢。
Oracle's EM lets you configure out much of its overhead. This overhead consists of polling many of the services to report alerts if a threshold is met or to provide graphs of performance. That being said, if you configure these features out, then why run it at all.
这是一头猪,我喜欢在 Linux 上运行 Oracle,并在初始安装后关闭 GUI(Oracle 的安装程序需要它)。
It's a hog, I like to run Oracle on Linux, and turn off the GUI after the initial install (Oracle's installer requires it).