Archive log generation
I have a scenario here, which my friend is facing :)
Recently one of their database is migrated from 10G to 11G.
Before migration, per day 10Gb archives logs were generating and after the migration the archive log generation is 100Gb per day. Business transaction is normal and there is no increase.
Does anybody have some idea what is behind this behaviour of the database ?
Oracle database version:- 22.214.171.124
Plat form:- Windows.
Ask him to check if Supplemental Logging is enabled..
Originally Posted by gopu_g
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
thanks for the Suggestion.
Please see the output.
SQL> select SUPPLEMENTALLOGDATA_MIN from v$database;