Database Administration (MOSC)

MOSC Banner

Something between GTT/PTT and permanent tables to avoid archived redo log volume

Can't find a good solution -- 19c database in ARCHIVELOG mode, need "temporary" tables that are shared between a small number of sessions (2-3), and I want the equivalent of NOLOGGING to avoid almost all redo log switching and archived log generation and transfer to archive destination. GTTs and PTTs won't work since the contents are private to the session. Not concerned about failure during creation and usage; they can be recreated quickly but are very large. Any combination of Oracle Database features I can use to accomplish these goals? Thanks.

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