Re: ASM Record Deletions

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: oraracdba@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Jun 2006 17:47:38 -0700 (PDT)

Thanks Scott

Scott <oraracdba@xxxxxxxxx> 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 

Other related posts: