Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: enable row movement for partition tables
Have not used it, but I would expect you would get some performance hit when
data had to move from one partition to another. Oracle has to actually move
the data (insert into new partition, delete row from old one.). Depending
upon how often this happens and the volume it might not be noticeable.
Jim
"G.Ong" <onggs_at_acslink.aone.net.au> wrote in message
news:0roN7.38393$li3.357322_at_ozemail.com.au...
> Hello,
>
>
> We are interested to use this feature ie enable row movement for partition
> tables. Are there problems eg bugs, performance overhead etc associated
with
> this feature ?
> We are using 8.1.6.3 on Solaris 2.7
>
> TIA,
> Ghee
>
>
Received on Thu Nov 29 2001 - 08:23:55 CST