Re: LogMiner V$LOGMNR_CONTENTS view

rboggs_at_endian-networks.com (Ron Boggs) wrote in message news:<e53f59be.0311191536.2662fc94_at_posting.google.com>...
> 2 questions...
>
> 1) 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

1 IIRC internal operations are index maintenance 2 Presumably the codes used are the same as the codes used in the command column of v$session and this column's values are documented.

Sybrand Bakker
Senior Oracle DBA Received on Thu Nov 20 2003 - 03:10:19 CST