Forum Stats

  • 3,742,578 Users
  • 499,138 Discussions
  • 1,599,180 Comments

Discussions

Global temporary tables create a lot of log switches

dhman
dhman Posts: 87 Blue Ribbon
edited Jul 8, 2020 8:28AM in Database Administration (MOSC) 14 commentsAccepted Answer

On our database we had a log switch every 15-20 minutes.

Recently there was a new feature where on a heavily used screen, we added logic where a stored procedure is filling global temporary tables to calculate a status that the screen needs to show.

Since this was implemented the log switches are happening every 1 minute.

The main global temporary table is "on commit preserve rows" Inserting data and then truncates on next run.

Is it the global temporary tables that create the excessive entries in archive logs? These data will not be needed in case of recovery. Is there a way to see what statement creates most of the REDO information?

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.

New to My Oracle Support Community? Visit our Welcome Center