To determine the size of redo generated by each DML statement
** Oracle is currently working on the issue, this thread as been opened on behalf of customer to know the inputs of community users **
Hi all,
Database 9.2.0.8 on Oracle Solaris on SPARC (64-bit)
I have a database which generates huge of redo and I am trying to determine which DML statements are generating big amount of redo. I am trying to use logminer to read the redo generated in archive logs and I can see which SQL, object, operation , but not the size of redo generated by each DML statement. I feel that there has to be some view which gives this info since Oracle has some delimiter/logic while reading DML statement from archive logs thru logminer.