Oracle 数据库的缺点
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1856414/
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
Cons of Oracle Database
提问by Szymon Lipiński
What cons of Oracle can you find?
您能发现 Oracle 的哪些缺点？
回答by gorsky
It's expensive.
它的价格昂贵。
回答by Carl Smotricz
- Oracle for private/small-time use is free. But Oracle for bigger users becomes EXPENSIVE quickly.
- Oracle is not simple to configure. Big buck paying companies usually keep full time Oracle admins on staff.
- If you're interfacing with Open Source code a lot, Oracle is not exactly popular there. You'd be closer to home with MySQL and PostgreSQL.
- After installing Oracle, you'll feel like your PC is no longer yours. It's HUGE and drains a lot of memory and performance.
- 用于私人/小时间使用的 Oracle 是免费的。但是对于较大用户的 Oracle 很快就会变得昂贵。
- Oracle 配置起来并不简单。高薪公司通常会在员工中保留全职 Oracle 管理员。
- 如果您经常与开源代码交互，那么 Oracle 在那里并不是很受欢迎。使用 MySQL 和 PostgreSQL 会让您更亲近。
- 安装 Oracle 后，您会觉得您的 PC 不再属于您。它很大，会消耗大量内存和性能。
回答by bobince
Oracle has put no effort into making deployment easy. (And they have good economic reasons not to.)
The '' IS NULLProblem.
Oracle 没有努力简化部署。（而且他们有充分的经济理由不这样做。）
该“”为空的问题。
回答by Philip Schlump
The oracle license agreement allows them to audit your usage of the database. So if you license for 5 users and you have 50 you are going to pay for 50. For web sites they really want you to have a license for each user.
oracle 许可协议允许他们审核您对数据库的使用。因此，如果您获得 5 个用户的许可，而您有 50 个，那么您将支付 50 个。对于网站，他们确实希望您为每个用户拥有一个许可。
Hiring folks to work with Oracle is more expensive than other databases (IBM DB2 is $$$ too).
雇用人员使用 Oracle 比其他数据库更昂贵（IBM DB2 也是 $$$）。
Since Oracle is so expensive it assumes that it is the only thing running on a computer and it wants to take all of the resources of the entire machine.
由于 Oracle 如此昂贵，它假设它是计算机上唯一运行的东西，并且它想要占用整台机器的所有资源。
The design of Oracle is more favorable to a UN*X server than a Windows machine (That may or may not be a disadvantage to you).
Oracle 的设计比 Windows 机器更适合 UN*X 服务器（这可能对您不利，也可能不会）。
Most documentation is strictly from Oracle - there is very little on the web documentation/help/examples. For MySQL or other open source databases there is usually an answer to your problem with a Google search.
大多数文档严格来自 Oracle - Web 文档/帮助/示例中的内容很少。对于 MySQL 或其他开源数据库，通常可以通过 Google 搜索来解决您的问题。
There is a big list of good things about Oracle too.
Oracle 也有很多优点。
- Immense scalability
- Supports object oriented tables
- Lots of folks to hire to work on it
- Runs on all sorts of hardware
- Partitioning is AMAZING
- Cost based query optimization
- 巨大的可扩展性
- 支持面向对象的表
- 有很多人可以雇佣来处理它
- 在各种硬件上运行
- 分区是惊人的
- 基于成本的查询优化
回答by Venkataramesh Kommoju
out of my experience,
根据我的经验，
when we want to take a dump of the database and import later it takes for ever for a db of size 4 TB.
当我们想要转储数据库并稍后导入时，它永远需要一个 4 TB 的数据库。
But if you do the same in DB2, its done in under an Hour.
但是如果您在 DB2 中做同样的事情，它会在一个小时内完成。
Reason for oracle being very slow is, they do not allow users/dba to get dumps directly from the file level. they do not have any utilities or API to develop.
oracle 很慢的原因是，它们不允许用户/dba 直接从文件级别获取转储。他们没有任何要开发的实用程序或 API。
DB2 has some things like DSNUTILB, DSNTIAUD etc many more.
DB2 还有一些东西，比如 DSNUTILB、DSNTIAUD 等等。
