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

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

Current Time: Thu Oct 27 18:35:03 CDT 2016

Total time taken to generate the page: 0.05927 seconds