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 than that, i view
shutting the database as wasting money...
I say money because your license fee's or part thereof
goes into building trendy little things like buffer
cache management, library cache management etc
etc...when you shutdown, its like throwing away some
of your license dollars
there of course are some (i would contend rare)
occasions when a regular shutdown policy can be
justified (eg memory leak accumulation etc), but i try
to avoid it at all costs if I can
cheers
connor
- chao_ping <chao_ping_at_vip.163.com> wrote: > 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).
>
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).
Received on Tue Jan 28 2003 - 02:49:06 CST
