Hi,
we have OLTP PROD database (11.2.0.3 on RHEL 5 64 ). For last 2 years we had approx. 350G avg archive generation till this October. Starting from November this has increased to around 500G per day avg. There are many ETL load programs and other applications connects to this database. As DBA we don't have control over new application/programs being introduced.
Trying to find out what is causing sudden increase in archive generation. Definitely new program/code is cause but application team is not is telling tihe same. We tried running AWR Comparison report but it didn't not materialized.
Any other idea ?
regards
Pravin