Home > Technical Papers/Books >

  All About Oracle's In-Memory Undo (v1n, 22-January-2009) Technical Paper
 
 
Our Price: Free


Availability: Available for download now
Product Code: IMU1

Description
 
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
 


Browse for more products in the same category as this item:

Technical Papers/Books


Introduction To Oracle Server Consolidation (v2b, 10-February-2009) PRESENTATION Free
Oracle Centric CPU Speed Test (1c, 22-Jan-09) w/Results Posted! Free
Response Time Graph Template (CPU(1,2) & IO) (1a, 17-Jul-2009) Free
Excel Add-in: M/M/m Queuing Theory Functions (1a, Nov 2007) Free
Basic CPU Forecasting Excel Workbook (1b, 21-October-2007) Free
Hash Block Perl Script (26-Jan-2010) Free