Sanjay, ASM works at the file level not at the table level. If you delete records the space in ASM does not change so there will be no re-balancing. Re-balancing will or should occur if you add, expand or drop tablespaces/datafiles. Scott --- Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: > Hi > > 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. > > TIA > Sanjay > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l