Re: Unplug problem
Date: Mon, 29 Mar 2021 23:05:32 -0400
Message-ID: <7f72849e-9634-f8c0-e073-2910e260a13d_at_gmail.com>
Hi Andy, replies in-line
On 3/29/21 11:47 AM, Andy Sayer wrote:
> You could try unplugging in an xml file, this will be super fast as it
> will just copy metadata. Then you can use a multicore friendly utility
> to zip up the data files.
Problem is that I don't know of such utility. Both tar and cpio are single threaded. I have now installed GNU parallel and will probably do better the next time around. Believe it or not, tar zcvf is approximately as fast as unplug into .pdb.
>
> This would be something nicer handled all by Oracle so might be worth
> filing an ER with support.
>
> Thanks,
> Andrew
Yeah, you're right. Enhancement request is the right thing to do. I was sort of annoyed after wasting 9 hours of my Saturday. And there are lots of improvements that are needed with multi-tenant.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 30 2021 - 05:05:32 CEST