In order to speed up slow insert current partitionâs subpartitions which are in âcoldâ disks are moved to âhotâ flash. goldengate is only client writing in this subpartition. The âresource busyâ error comes only after good 3-4mins of running the statement. Typically it used to come right away if itâs a blocking operation and required X lock to start its proceedings. This might suggest it requires X lock towards the end for âmergingâ ? Or is it that in 12c there is a default value of ddl_lock_timeout which is 3-4 mins ? Isnât ddl_lock_timeout is used for blocking/offline ddls, is it still required if its supposed to be online operation.
The statement:
Alter table testdba.testtable move subpartition testsubpart1 tablespace hot online parallel (degree 10);
On Oct 3, 2018, at 11:35 PM, Stefan Knecht <***@gmail.com<mailto:***@gmail.com>> wrote:
What is the exact script / statement you're running? Are you setting ddl_lock_timeout? It might need to wait for any open transactions and may time out?
On Thu, Oct 4, 2018 at 11:57 AM, samrat roy <***@hotmail.com<mailto:***@hotmail.com>> wrote:
Hi,
I am trying online sub partition move but it fails with ORA-00054 resource busy error. Isnât 12.2.0.1 claims that online move is possible while writes are going on the same segment. Writes are from goldengate replicate. Once replicats are stopped obviously it works. But is the expectation of 12c online move is âread onlineâ ?
-Samrat
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net<http://zztat.net/> | @zztat_oracle | fb.me/zztat<http://fb.me/zztat> | zztat.net/blog/<http://zztat.net/blog/>