Database Administration (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center