redo log and log miner questions
Oracle 10.2.0.4:
I am looking at v$logmnr_contents after populating that view by using log miner. Some of the questions I have is:
1. I see whole bunch of "UNSUPPORTED" operations. These are high in number but not sure why it says UNSUPPORTED. I tried SQL_REDO, SQL_UNDO and it just returns "UNSUPPORTED" text.
2. Another question I had was around INSERT and UPDATE of LOB columns. We have a table that has 2 columns. First column is used during INSERT and the second column is used during UPDATE. Now my question is that when LOB is updated does both columns get written to redo log or just the column that's being updated.
For a little IO we generate whole lot of redo log. I am just trying to see why so much log is being written.