 |
 |
 |
|
Note: OraPub provides performance-centric consulting services and also provides industry unique training through it's Oracle Performance Firefighting course.
The Oracle database is extremely complex software. Part of the solution to performance optimization is Oracle Corporation itself optimizing the core database kernel code. One such optimization is the introduction of Oracle’s patented In-memory undo (IMU). Essentially, instead of maintaining undo in Oracle segments, the undo is managed, as much as possible, in memory using structures optimized for in-memory operations. But as you will read, how Oracle does this is fascinating and foreshadows even greater things to come. But with any piece of code, there is always the possibility of a bottleneck, so this paper covers how to detect IMU performance issues and multiple ways to potentially solve the problem (in addition to just tuning it off).
The associated presentation is also posted on-line. Just do a search for IMU.
Author: Craig A. Shallahamer |
|
|
|
|
|
|
