Karl, When I was working on PeopleSoft that company didn't have ANY disaster plan other than sending people home with copies of tapes. Dick Goulet Senior Oracle DBA ________________________________ From: Karl Arao [mailto:karlarao@xxxxxxxxx] Sent: Friday, October 22, 2010 1:20 AM To: Goulet, Richard Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Peoplesoft Batch run and excessive redo generation Thanks for your response on this. I also asked David Kurtz about this issue, he also responded that Global Temporary Tables could be used to reduce the volume of redo being generated http://blog.psftdba.com/2008/01/global-temporary-tables-and-peoplesoft.h tml http://blog.psftdba.com/2009/07/dynamically-switching-peoplesoft.html The product we have is PeopleSoft HCM v8.9 and v9.1 BTW, how about on the environment you've worked on, how do they address having the DR (data guard, etc.) given the excessive redo generation on batch runs? -- Karl Arao karlarao.wordpress.com karlarao.tiddlyspot.com