Re: ASM Record Deletions

From: Scott <oraracdba_at_yahoo.com>
Date: Tue, 13 Jun 2006 16:26:17 -0700 (PDT)
Message-ID: <20060613232617.96819.qmail@web35703.mail.mud.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 13 2006 - 18:26:17 CDT