Re: Archivelog mysteries

From: Michael Haddon <m.haddon_at_tx.rr.com>
Date: Sun, 18 Mar 2007 08:05:07 -0600
Message-ID: <45FD4713.6070608@tx.rr.com>

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

Mike
>
> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 18 2007 - 09:05:07 CDT