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: 63802
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: Sun Sep 25 16:17:53 CDT 2016

Total time taken to generate the page: 0.08560 seconds