Re: ASM Record Deletions

  • From: Scott <oraracdba@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Jun 2006 16:26:17 -0700 (PDT)

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 
--
http://www.freelists.org/webpage/oracle-l


Other related posts: