写重型Oracle应用程序的优化？ [英] Optimizations for a Write heavy Oracle application?

问题描述

一些有用的Oracle优化可以用于主要向Oracle数据库写入（更新）的应用程序？

What are some useful Oracle optimizations one can use for an Application that mostly writes (updates) to an Oracle database?

这里的一般使用模式不是Web服务或日志记录，因为在大多数情况下，而是持久的系统的复杂状态，所以只需要阅读是系统启动时，之后它的更新和创建一路。因此，现在的写入读取比率超过9比1，在这种情况下什么数据库调优可以提高性能？

The general usage pattern here is not web-serving or logging, as is most cases, but instead to persist complex state of a system, so the only times reading is needed is when the system starts up, after that its update and create all the way. Thus right now the Write to Read ratio is over 9 to 1, in this case what database tuning could improve performance?

推荐答案

使用statspack（9i）或AWR（10g +）的系统健康状况将是识别瓶颈的最佳方法。

Monitoring of the system health using statspack (9i) or AWR (10g+) would be the best method of identifying bottlenecks.

特别是：

• 了解重做等待。


• 使用绑定变量


• 尽可能使用批量操作。


• 观察索引争用，其中多个进程将记录插入到序列派生列上具有索引的单个表中

• lookout for redo waits. The redo log is critical in maintaining a high write rate
• Use bind variables
• Use bulk operations wherever possible.
• Watch for index contention where multiple processes insert records into a single table having an index on a sequence-derived column

这篇关于写重型Oracle应用程序的优化？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！