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

From: Mladen Gogala <mgogala_at_no.address.invalid>
Date: Wed, 6 Apr 2011 00:38:10 +0000 (UTC)
Message-ID: <ingclh$1ft$>

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?


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...

Received on Tue Apr 05 2011 - 19:38:10 CDT

Original text of this message