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
--
//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:
