Re: Killing parallel processes?

From: Rich J <rich242j_at_gmail.com>
Date: Thu, 19 Mar 2020 10:28:13 -0500
Message-ID: <CAANsBX3h5ghjE5Q+PJG5va1bdn-XBUEcVYPgai9iaknBu9c0cg_at_mail.gmail.com>



Hey Andrew,

Good call on the expdp process! I hadn't thought to check that. Now I just need to get the approvals and the killing can begin... :)

Thanks!
Rich

On Thu, Mar 19, 2020 at 10:03 AM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> You can safely kill the parallel processes, but make sure you know the
> correct OS pid as well as the sid and serial# before you kill them, you
> might need to kill them at both the database and OS level, and its hard to
> find all of that after you kill them in one place. You should probably
> make sure the expdp process has been completely killed first however.
>
> On Thu, Mar 19, 2020 at 9:58 AM Rich J <rich242j_at_gmail.com> wrote:
>
>> Hey all,
>>
>> In 12.1.0.2 on AIX 7.1, I needed to export a few schemas that were larger
>> than the local disk space available. Since on-the-fly compression is no
>> longer feasible without Advanced Compression, I used an NSFv4 mount point.
>>
>> There was some issue (I don't recall -- it was in January) that I needed
>> to kill the expdp. Ran it again with no problems, and all's well until
>> today when I saw that the NFS mount point was still up and I tried to
>> umount it. There are 7 files still open on the remote server from each of
>> 7 parallel processes on the local database server. The files are named
>> ".nfsxxxxx". I'd like to close this mount point, so I see that I have a
>> few options:
>>
>> 1) Kill each parallel process. This database does not normally utilize
>> parallel during the day, with only 1 query using it over night.
>> 2) Bounce the instance. Scheduled downtime is in 6 days (just missed
>> yesterday's window). This is a primary in an Active DG config with 1
>> physical standby.
>> 3) Stop the NFS client. Nothing else is using it.
>> 4) Stop the NFS server. Nothing else is using it.
>>
>> The safest to me seems to be the instance bounce. But it's the most
>> work, too, as I need to involve application folks.
>>
>> I've killed parallel processes before, but only on test instances where I
>> didn't care what the outcome was. There's currently 64 parallel processes
>> (the maximum for this instance, IIRC).
>>
>> Stopping NFS seems...messy. Unsure how the parallel processes will
>> handle that.
>>
>> Thoughts?
>>
>> Thanks,
>> Rich
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 19 2020 - 16:28:13 CET

Original text of this message