Excessive archvelog creation
From: Schauss, Peter [US] (ES&CSO) <"Schauss,>
Date: Wed, 6 Sep 2017 18:27:44 +0000
Message-ID: <47f45527f182415fb7424d7c764d26cd_at_XCGVAG23.northgrum.com>
Environment: Oracle 12.1.0.2 (January 2017 PSU)
Date: Wed, 6 Sep 2017 18:27:44 +0000
Message-ID: <47f45527f182415fb7424d7c764d26cd_at_XCGVAG23.northgrum.com>
Environment: Oracle 12.1.0.2 (January 2017 PSU)
Redhat Linux 6.2 Application (in case it matters Deltek Cobra)
I came into the office one morning a few weeks ago and discovered that the above application had devoured 500 gb of archivelog space in a period of about five hours over the previous night. Fortunately, this was on the development database server.
I ran an awr report for the time period in question and it listed the following statement executed 3740 times:
UPDATE PROCESSLOG SET DATA = CONCAT(DATA,:B2 ) WHERE ROW_UID = :B1 The DATA column is clob and, based on timestamps that the application writes to the table I located the row to which that data was being added. DBMS_CLOB.GETLENGTH shows the size of the clob in that row as 48 mb.
So my questions are:
- If the application was adding the data with CONCAT in small increments, say 100 characters at a time, would this account for the large volume of redo that we saw?
- If the application had added the 48 mb all at once would it have generated less redo?
Thanks,
Peter
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 06 2017 - 20:27:44 CEST