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:[EMAIL PROTECTED]
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" <[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).
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
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).
