Re: Archivelog mysteries

  • From: Michael Haddon <m.haddon@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 18 Mar 2007 08:05:07 -0600

Bill -

What is the table definition? - I have seen updates to a table that stores xml in a CLOB generate this kind of archive when there are alot of upates to the CLOB column. There are several updates that take place. If you can - create a test instance somewhere, run the test, then mine the archive logs and look at how many updates to the LOB index are actually taking place.

We have this issue but I have finally convinced the dev team to use XML tables and varchar2 datatypes wherever possible instead of CLOB column for high activity tables.

Hope this helps

Any idea why a table that's only 11.6 GB (when complete) would have generated approximately 100 GB of archive logs? It doesn't seem logical to me (at this point), that the archive log data would be approximately 10 times the size of the data.

-- Bill Ferguson


Other related posts: