In Memory Undo (IMU) introducted in oracle 10g. We all as experienced DBA's would appreciate the fact that how much ever improvements have been made so far in the undo management solutioning provided by oracle , this topic always takes a beating the moment we start a debate on comparing oracle with other DataBase offerings like IBM or informix.The undo segment management has given rise to lot of hidden complexities in terms of consuming resources; memory, CPU, and IO.The next step is the avtar of In Memory Undo (IMU) which improves performance by overrding the the above said.
I did go through a very nice document by Craig Shallahamer which gives an expericene of IMU
http://www.trutek.com/uploads/docs/In%20Memory%20Undo%201g_1.pdf
Hope we will have more responses from IBM on top of the below
ftp://ftp.software.ibm.com/software/data/pubs/papers/readconsistency.pdf
No comments:
Post a Comment