Archive Log size is too big - need troubleshooting advice
Anyone know of some advise on where/how to troubleshoot when archived log size is too big?
I'm getting a large archived size compared to my small database. I want to see who/what is the offending schema or sql.
Usage is at 12% and archive size is way too much for it. Usually my usage with larger database is 1% or .8%
Oracle 19c 19.8.0.0.0
Linux 7
Single Tenant database (non-RAC)
This is second post I made, I think I messed up the first one (sorry) - https://community.oracle.com/mosc/discussion/4513426/my-archive-size-is-too-big-need-troubleshoot-advice