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


OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010) Free
Direct Contention Identification Using Oracle's Session Wait Event Views (April-2002) Free
Total Performance Management (Feb 1995) Free
Advanced CPU Forecasting Excel Workbook (1d, 30-July-2008) Free
Evaluating Alternative Performance Solutions (v2e, 6-November-2009) Technical Paper Free
Index Organized Tables -- When should they be used? (April-2002) Free
Responsibly Forecasting Oracle System Performance (June-2003) Free
Oracle Performance Firefighting Book in *PDF* (OraPub) $39.95