Re: How to speed up 6678700 patching process
- From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 8 Sep 2010 00:30:41 +0530
Is the patch stuck at a single worker?
What is the average speed of workers completion?
How many workers are used by adpatch ?
SGA of 5G when we have 16G of memory might not be the best. Consider
increasing it to 8G if /dev/shm allows it.
Try to run AWR report for a duration of 2hrs when patch is running and see
what is the top wait event. It might give an insight into what is going
wrong.
~Ravi.M
On Thu, Sep 2, 2010 at 4:18 PM, Avadhani mys <avadhanimys@xxxxxxxxx> wrote:
> Adding to the below note, when i restart the DB and continue the patching
> session it runs fine for some hours and hangs again.
>
> Regards
> Avadhani
>
>
> On Thu, Sep 2, 2010 at 3:59 PM, Avadhani mys <avadhanimys@xxxxxxxxx>wrote:
>
>> Hello Gurus,
>>
>> Please help me to understand the parameters to be set at DB end to speed
>> up the NLS driver patching process.
>> we are upgrading 11.5.9 to R12.1.1 on RHEL5. I applied the patch
>> 8576725<https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=8576725>
>> to
>> fix the bug as per note: [ID 839978.1].
>> We have 16G memory and 4CPU machine. Below is my SGA settings
>>
>> SQL> show sga
>>
>> Total System Global Area 5678776320 bytes
>> Fixed Size 2213336 bytes
>> Variable Size 4496296488 bytes
>> Database Buffers 1140850688 bytes
>> Redo Buffers 39415808 bytes
>> SQL>
>>
>>
>> Thanks in Advance
>>
>> Regards,
>> Avadhani
>>
>
>
Other related posts:
