LogMiner V$LOGMNR_CONTENTS view

From: Ron Boggs <rboggs_at_endian-networks.com>
Date: 19 Nov 2003 15:36:11 -0800
Message-ID: <e53f59be.0311191536.2662fc94@posting.google.com>

2 questions...

During heavy inserts into a db, I see the following thru log miner:

Time     Operation                         Operation_Code     Count
11:47:13 START                                         6         59
11:47:13 COMMIT                                        7         59
11:47:13 INSERT                                        1       3339
11:47:13 UPDATE                                        3        300
11:47:13 INTERNAL                                      0       5309
11:47:13 UNSUPPORTED                                 255         54

That scenario is repeated every second. The number of INTERNAL operations seems high relative to the number of inserts. But since I don't really know what operation=INTERNAL represents, I'm not sure. Maybe this is typical. Any insight?

2) How the *&*! do I know what OPERATION_CODE represents? I have searched the Doc, MetalLink, Internet...this is a well kept secret! Anybody have a table of these values?

Thanks,
Ron Boggs
St. Louis Received on Wed Nov 19 2003 - 17:36:11 CST