I was looking at the web this evening for a paper for some research and ended up at www.oracletuning.com
from a google search string. As it happens the site was not of any use in my research this evening but whilst there i noticed a paper I have read a long time ago. The paper is Dissassembling the Oracle Redolog
. It is a little dated now as it was published on 26 September 2000 and was written by Graham Thornton. This is a great paper that gives some great detailed information on how to dump a redo log to trace and also how to interpret it and to look for specific events in the log file. With the advent of the LogMiner this laborious method is out-dated but this paper is still valuable. Using tools such as DBMS_LOGMNR is a great way to read the redo stream and find events but knowing how it works is insightful. I like internals and hard to find info and had forgotten about this paper, it was a joy to re-find it and have a read of it again.