Re: move table with securefiles extremely slow

  • From: Anton <djeday84@xxxxxxxxx>
  • To: Kevin Jernigan <kevin.jernigan@xxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Jul 2014 19:51:44 +0400

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 



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2014