Maybe I'm just a cynic but I view AUM as being akin the SAME disk layout policy. That is, (and this is subjective figures) it gives 90% optimal performance in about 90% of databases out there.
Since going to aum on a "significant" (read: reasonable number of users and workload) database I used to manage in the UK, I found aum gave ever so slightly increased undo figures in v$waitstat, but not really enough to discount it. Similarly, file IO was slight increased (which I have put down to its fairly aggressive nature of enforcing retention time). One thing that is good about aum, is that it encourages people to never shut their databases (a policy I advocate strongly). I would like to be able to have multiple undo tspaces simply as an aid to IO balancing Cheers Connor --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > This is more of a survey than a question about > problems. > > For those of you using automatic undo management, > what have been your > experiences, both good and bad. Are you also using > flashback query and what > are your experiences? > > Thank you for all the responses, > > Dan Fink > > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
