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.
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use GTT (Global Temporary Table) and stop creating and dropping permanent tables.

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


Current Time: Thu Mar 28 12:27:05 CDT 2024