Re: ASM Record Deletions

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 13 Jun 2006 17:47:38 -0700 (PDT)
Message-ID: <20060614004738.85671.qmail@web51313.mail.yahoo.com>

Thanks Scott

Scott <oraracdba_at_yahoo.com> wrote: 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 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




 __________________________________________________
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 - 19:47:38 CDT