I've found that large DML operations create a large amount
of redo even if the objects are in a locally managed tablespace.
Ratio is 17:1, at least for me.
Jared
On Wednesday 05 September 2001 10:11, Mohammad Rafiq wrote:
Grant,
I am glad that you found reason for lot of archiving.
Yes,
Grant,
I am glad that you found reason for lot of archiving.
Yes, even with nologging, if table/tablespaces are dictionery managed, there
are redologs generated for extent management.
Archiving may be minimized by commiting after certain amount of rows like
rows = 1 or whaever which your
Were the indexes also created with nologging?
And for those more knowledgeable than I: If the index was created with
nologging and its associated table has date inserted with APPEND will block
change vectors for the Indexes be written to redo logs?
If so, perhaps dropping the indexes before
Mohammad and Jaymany thanks for the responses.
Upon running your script Mohammad, I noticed that archive files were being
written to the archive directory during a large insert operation and
stopped being written once the insert had completed. The insert command
uses APPEND, the associated