PL/SQL (MOSC)

MOSC Banner

Lowering redo generation

edited May 5, 2014 9:01AM in PL/SQL (MOSC) 9 commentsAnswered ✓

Hello,

I'd like to hear opinion of experienced developers regarding possibility of lowering redo log generation while keeping FORCE LOGGING on. Application needs to compute some data and the process can be restarted any time, so only the result is important. It's very space demanding, but still FORCE LOGGING should stay on for obvious reasons. There's a choice of temporary tables or doing computing outside of db but I was curious, are there more possibilities? Me, as DBA, would appreciate any experience from dev point of view.

Thanks, Michael

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