Re: ASM for single-instance 11g db server?
From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 5 Apr 2011 18:50:55 -0700 (PDT)
Message-ID: <112ae63c-efde-4fe1-ab22-1f0c1d05042c_at_k30g2000yqb.googlegroups.com>
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 (11.2.0.2) 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...
>
> --http://mgogala.byethost5.com
Date: Tue, 5 Apr 2011 18:50:55 -0700 (PDT)
Message-ID: <112ae63c-efde-4fe1-ab22-1f0c1d05042c_at_k30g2000yqb.googlegroups.com>
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 (11.2.0.2) 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...
>
> --http://mgogala.byethost5.com
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