Database Administration (MOSC)

MOSC Banner

To determine the size of redo generated by each DML statement

edited May 13, 2010 10:20PM in Database Administration (MOSC) 3 commentsAnswered

** 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center