Home » Other » General » REDO Logs not wanted (Oracle PLSql/Sqlplus 10g)
REDO Logs not wanted [message #429602] Wed, 04 November 2009 13:26 Go to next message
whatfur
Messages: 29
Registered: July 2006
Junior Member
I have a number of processes that require the creation and use of large temp tables that are essentially scratch areas. I have often wondered whether the overhead of REDO logs could be avoided with these. I mean can REDO logs be turned off via parameter? These tables are generally created and removed during the running of the process.

Report message to a moderator

Re: REDO Logs not wanted [message #429611 is a reply to message #429602] Wed, 04 November 2009 14:19 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use GTT (Global Temporary Table) and stop creating and dropping permanent tables.

Regards
Michel

Report message to a moderator

Previous Topic: Licensing and scripts
Next Topic: Profile error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 02:17:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.