Re: move table with securefiles extremely slow
From: Anton <djeday84_at_gmail.com>
Date: Thu, 10 Jul 2014 19:51:44 +0400
Message-ID: <53BEB690.6040005_at_gmail.com>
Thx for reply, both ways are slow, on prod system i use alter table move, while investigating i do CTAS, it was slow to and trace files looks similar ( lots of 1,2 block read of lob )
Date: Thu, 10 Jul 2014 19:51:44 +0400
Message-ID: <53BEB690.6040005_at_gmail.com>
Thx for reply, both ways are slow, on prod system i use alter table move, while investigating i do CTAS, it was slow to and trace files looks similar ( lots of 1,2 block read of lob )
09.07.2014 23:34, Kevin Jernigan пишет:
> How are you moving the table - ALTER TABLE MOVE? Online redefinition?
> Create Table As Select (CTAS)? -KJ
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 10 2014 - 17:51:44 CEST