Oracle 11g，良好的安装和调优指南
我们有大量数据的表，当我们导入11g大约2000万条数据记录时，它开始执行非常慢。
例如 SELECT COUNT(*) FROM TABLE 在大约一分钟内执行。
我认为我们在初始配置和调整方面存在问题，它安装在 Oracle Linux、服务器 - XEON 4TB 硬盘、8 RAM 和 4CPU 上。数据库甚至没有使用所有资源的一半，没有使用 RAM 和 CPU。 我有使用MySql的经验，并且认为2000万条记录不应该对数据库锁这么多。
现在，我们正在寻找在 11g 中处理大数据的良好建议、指南或生活窍门。
使用哪个操作系统？ 哪里可以找到好的安装指南？ 调整提示。
此致。
We have tables with large amounts of data, when we imported into 11g about 20 million data records it started to perform very slowly.
For exampleSELECT COUNT(*) FROM TABLE executed in about a minute.
I think we have problems with initial configutions and tune up, it is installed on Oracle Linux, server - XEON 4TB hardisk, 8 RAM and 4CPU. The database is not even using half of all resources, not using RAM and CPU.
I am experienced in using MySql, and think 20 million records should not lock the database so much.
Now we are looking for good recommendations, guides or life hacks of performing with large data in 11g.
Which OS to use?
Where to find good installation guide?
Tune up tips.
Best regards.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你读过文档吗？与 MySQL 相比，Oracle 更加精密/复杂（随你选择）。恐怕您不能只是打开一台机器并期望它能够在处理大量数据时高效运行。
有一系列为期两天的指南，旨在让新从业者快速上手。这是用于调整的。然而，它主要关注用于调整 Oracle 的自动工具，这些工具会产生额外的许可成本，而且您可能没有这些工具。因此，您还应该查看完整的性能指南。 了解更多信息。另请查看免费的 Statspack（并且在最新的文档中不再提及）。 了解更多信息。
至于安装，有丰富的信息。 了解更多信息。您应该特别注意最佳灵活架构（OFA），这是Oracle推荐的目录布局；具体细节将根据您使用的操作系统而有所不同。这是Linux 版。
Have you read the documentation? Oracle is considerably more sosphicated/complicated (take your pick) compared to MySQL. I'm afraid you can't just bung in on a machine and expect it to run performantly with large volumes of data.
There is a series of two-day guides designed to get new practitioners quickly up to speed. Here is the one for tuning. However it mainly focuses on the automatic tools for tuning Oracle, which incur additional license costs and which you probably don't have. So you should also have a look at the full Performance Guide. Find out more. Also check out Statspack which is free (and no longer mentioned in the more recent documentation). Find out more.
As for installation, there's a wealth of information. Find out more. You should pay particular attention to the Optimal Flexible Architecture (OFA), which is Oracle's recommended directory layout; the specifics will vary according to which OS you're using. Here's the one for Linux.