Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ASM Record Deletions

RE: ASM Record Deletions

From: Kevin Closson <>
Date: Tue, 13 Jun 2006 16:32:45 -0700
Message-ID: <>


>>>>If I have 10 millions records in a table and if I drop the
table or delete 1 million records and if ASM_POWER_LIMIT to > 0, Is it going to rebalance the Disk space among all Disks used in the Diskgroup. This table is currently having 50G space.

Folks, absorb this one:

        ASM is not aware of the contents of blocks.

ASM is a raw disk space manager. If you add or drop a disk, you trigger a rebalancing act. If you drop a disk, say a lot of prayers you are helping mankind by performing oracle QA.

If you add less than probably 100% disk capacity and endure a total rebalance, the odds are actually pretty slim that you will get a performance increase. "Oh boy, he's making that up", they sigh. Two words, test it.

ASM is not QoS. Not by any stratch of the imagination. Of course, blind ASM fanatics will tell you you don't need QoS of any sort--since ASM doesn't have it.

Consider the fact that the majority of OLTP accesses hit the minority of the database blocks (usually on the order of 80% hit some 20% of the data) ...and that minority of blocks moves. If you have, say, 50 disks and you add 10 and go through a rebalance, will the hot blocks get extra representation on the new spindles? No. Should they? Yes. Who is implementing stuff like that? Not Oracle. Guess who does?

QoS is the art of transparently promoting or demoting blocks of disk to different levels of the storage hierarchy. Since IT shops have generally
given up on actually caring about such elegance, you just don't get a lot of water-cooler talk about such. And, after all, if ASM doesn't do it, it must not be needed. Conversely, if ASM does do something, it must be right.

Ok, off to add 20 disks to my 200 disk diskgroup. I'll start with eleventeen Spaten Pils and count my way down until it is done (if it ever finishes). Then I'll be properly anesthetized so that when I measure the performance delta I wont be upset to find I got squat out of all that monkey business. I'll then slumber dreaming of ASM-ites enduring ATONTRI delights.                                 

Received on Tue Jun 13 2006 - 18:32:45 CDT

Original text of this message