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
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
