Logminer not showing expected records
Hi. I am using logminer to look at inserts into the TST03 data. I know that the spool data in question is supposed to have a certain number of rows in it (e.g. 47), implying that I should find 47 inserts via logminer.
What usually happens is that a query against v$logmnr_contents lists insterts for rows 2, 4, 6, 8, ..., but not 1, 3, 5, 7, .... Oddly, both 46 and 47 show up.
I have another case where there are 48 rows in TST03 for the spool. In that case, log miner only shows inserts for the even numbered rows (i.e., 2, 4, 6, ..., 44, 46 & 48).
I have another situation where I have 6 rows in TST03, but when looking through logminer, I only see an insert for the 6th row, and not the previous 5. Hence why I said "usually" above.
Does logminer sometimes not show all operations?
What could cause this behavior?
Is there something I need to ensure is set in order to see all data?
In this case, one of the columns of TST03 is a long raw column (DCONTENTS). Could this be problematic?