Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time

joel garry wrote:

> Well, I don't know about the OP, but on one system, if I increased undo
> to where a script tells me it "should be," I would have to quadruple
> the tablespace from 10G to 40G. Now, that system
> has two days online full backups available, so that means an additional
> 90G.
>
> jg
> --
> @home.com is bogus.
> http://geeksaresexy.blogspot.com/2006/01/freeze-your-hard-drive-to-recover-data.html

Only if your backup is brain-dead. Aren't you using RMAN?

And just in case someone interprets that answer as meaning you should do what the v$ tells you too ... are there any 1555s or other issues?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org