Re: ASM for single-instance 11g db server?

From: onedbguru <>
Date: Tue, 5 Apr 2011 18:50:55 -0700 (PDT)
Message-ID: <>

On Apr 5, 8:38 pm, Mladen Gogala <mgog..._at_no.address.invalid> wrote:
> On Tue, 05 Apr 2011 17:21:25 -0700, onedbguru wrote:
> > M.
> > First,  my apologies for the unintended unprofessional tone in my
> > original response...
> Not a problem.
> > alter diskgroup {N} rebalance power 11;   -- where 11 is some number of
> > parallel server processes you can use to do the move, on a 48 dual- core
> > system, 11 is acceptable
> > and wait until it finishes.  On the gear we had, while adding 1TB of
> > data a day, we averaged 300+GB/hr for the move.
> Thanks. This looks great and simple. I will test you and let you know.
> > Finally, upgrade to 11gR2 (  Some of the new features like
> > interval partitions (automatically creates the next partition for you
> > without locking up your app),
> Yes, I know about that. Upgrade is in progress, but it's not as fast as I
> would like. Functional testing, UAT, dry run or two and only after that
> can I upgrade. The projected date for the main database is the weekend
> for the 4th of July. I'll miss out on the barbecue party, but I will not
> put on 2 pounds, which happens with worrying regularity. Who would think
> that burgers and beer do not belong into the wholesome diet food category?
> > DBMS_PARALLEL_EXECUTE (helps in the
> Hmmm, I will have to check this one. Thanks for the tip.
> > parallel execution of  dml like update,delete - even (insert into as
> > select)) and EXCHANGE PARTITION (I believe this was also available back
> > in 10g)  just to name a couple that I have found extremely useful,
> > especially in a DW environment.
> EXCHANGE PARTITION is available since 9i. I am using it regularly in 10g.
> I had to make all my indexes local, because global indexes will get
> messed up, but it does work.
> > The exchange partition makes that truncate oldest partition a much
> > shorter process - but you do need to be aware of the use of GLOBAL vs.
> > LOCAL indexes.
> Oh yes, I see now that you mentioned it. Thanks. Also, if I may return
> the favor, 11g allows you to compress the expdp output. Oracle 10g could
> only compress metadata, 11g can compress the entire data set. Comes in
> handy when you have to export a development database, put it onto a USB
> drive and send to India to the developers.
> As for the upgrade, we're in the functional testing phase. UAT is
> scheduled for May. I certainly hope that I will not have to hint
> anything, but if necessarry...
> --

one of the best things that impdp gave us was the ability to impdp via a database link and "can be" easier than expdp, scp, impdp but you do have the option. Received on Tue Apr 05 2011 - 20:50:55 CDT

Original text of this message