Oracle LogMiner (Unsupported Operation)

Posted by Sarith on Server Fault See other posts from Server Fault or by Sarith
Published on 2010-03-12T04:35:31Z Indexed on 2010/03/12 4:37 UTC
Read the original article Hit count: 606

Filed under:

Hi all,

I'm currently using Oracle 11g on RHEL5. I'm digging to see what are in the archived log files. After I query from v$logmnr_contents, I see many transactions of UNSUPPORTED operation.

What do these unsupported transactions mean? I think that it's the cause that make my database generates lots of archived logs. Moreover, I'm using global temporary table for generating reports. I discover that when I insert and delete from those temporary table, it also records in the archived log file.

How to do to reduce those recorded transactions?

Regards,

Sarith

© Server Fault or respective owner

Related posts about Oracle