Re: Re: Experiences with Automatic Undo Management

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 system, but my system is most read only so did not see anything different , performance is pretty good.
		By the way, do friends in this list also suggest never shutdown database? I prefer to shutdown db/unix every several monthes, to give out a stable os enviroment.

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)

• 2003-01-27 15:33:00 ,you wrote£º=======

>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" <Dan.Fink_at_mdx.com> 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: connor_mcdonald_at_yahoo.com
>
>"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: hamcdc_at_yahoo.co.uk
>
>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: ListGuru_at_fatcity.com (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).

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

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: ListGuru_at_fatcity.com (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).