Members   Search   Help    Register    Login   Home
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: 22
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: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: Mon Nov 30 14:39:37 CST 2009

Total time taken to generate the page: 0.30101 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.