Re: Re: Experiences with Automatic Undo Management

2003-01-28 Thread Connor McDonald
the only time i've had the need for a regular shutdown was when there was that lovely old solaris problem where an os clock wrapped and put junk into the controlfile (and thus made a little bit of a mess of the database) so a db had to be bounced at least once every (I think) 248 days, but other th

RE: Experiences with Automatic Undo Management

2003-01-28 Thread Robert Freeman
>> I would like to be able to have multiple undo tspaces simply as an aid to IO balancing... Connor, you can... Oooo... You meant you want them active at the same TIME :-) They are saving that as a "new" feature for some later release I'm sure. It's probably on some marketing guys white

Re: Re: Experiences with Automatic Undo Management

2003-01-27 Thread chao_ping
Connor McDonald, Hi, for IO balance , I think in most case, we put datafiles on raid so it is not a problem? Or you can use multiple datafiles, which will give you solution when no raid or multiple raid is used and you want to balance io? I used AUM too in my rac s

Re: Experiences with Automatic Undo Management

2003-01-27 Thread Connor McDonald
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

Re: Experiences with Automatic Undo Management

2003-01-27 Thread Shaleen garg
.   -Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 8:49 AM Subject: RE: Experiences with Automatic Undo Management Dan,   We are using AUM on ALL our PROD/DEVL/TEST environments, no

RE: Experiences with Automatic Undo Management

2003-01-27 Thread Jamadagni, Rajendra
y, January 27, 2003 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: Experiences with Automatic Undo Management 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 ba

Re: Experiences with Automatic Undo Management

2003-01-27 Thread Igor Neyman
, January 27, 2003 10:09 AM Subject: Experiences with Automatic Undo Management 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

Experiences with Automatic Undo Management

2003-01-27 Thread Fink, Dan
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