Tech Geek wrote:
>>I will be interested in see what answers you get from those more
>>knowledgeable than I. But until then ... two quick questions.
>>
>>1. Does your SQL using incremental commits?
>>2. Have you looked at the UNDO size recommendations provided by OEM?
>
> Thanks Daniel,
>
> 1. No we are not using incremental commits.
> 2. OEM indicates that I need about 8G of space to maintain an
> undo_retention of 2 hours, and I have 13G space.
Based on your answers my presumption would be that some SQL you
are executing is taking longer than 3 hours to run. Is that
possible?
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Mar 01 2004 - 00:34:20 CST
