This discussion is archived
3 Replies Latest reply: Nov 9, 2012 10:57 AM by Hussein Sawwan-Oracle RSS

Can I speed up/skip adpatch bug history insertion stage of 6678700 patch?

stopuz Newbie
Currently Being Moderated
Hi,

I have the following configuration:

OS: Red Hat Enterprise Linux 5 (64-Bit) running with 24GB RAM, 16 CPUs
DB: 10.2.0.5

The upgrade driver patch is already taking very long, but this last stage where it says:

"Saving Patch History Information to Database" takes really long.

adpatch batchsize=5000 #of workers=32

Is there a way of doing this separetly or speeding it up a little?
oraprod:oraprod>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Oct 29 16:35:04 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter sga

NAME                         TYPE      VALUE
------------------------------------ ----------- ------------------------------
lock_sga                    boolean      FALSE
pre_page_sga                    boolean      FALSE
sga_max_size                    big integer 4G
sga_target                    big integer 4G
SQL> 
OS top all users:
top - 16:36:16 up 2 days, 55 min,  4 users,  load average: 1.11, 1.01, 0.96
Tasks: 403 total,   2 running, 400 sleeping,   0 stopped,   1 zombie
Cpu(s):  6.3%us,  0.0%sy,  0.0%ni, 93.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  24674616k total, 22827236k used,  1847380k free,   180040k buffers
Swap: 21692400k total,   123244k used, 21569156k free, 19686652k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                      
26937 oraprod   25   0 4260m 856m 843m R 99.8  3.6 174:15.47 oracle                                                        
    1 root      15   0 10364  696  580 S  0.0  0.0   0:06.80 init                                                          
    2 root      RT  -5     0    0    0 S  0.0  0.0   0:00.05 migration/0                                                   
    3 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/0                                                   
    4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/0                                                    
    5 root      RT  -5     0    0    0 S  0.0  0.0   0:00.03 migration/1                                                   
    6 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/1                                                   
    7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/1                                                    
    8 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/2                                                   
    9 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/2                                                   
   10 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/2                                                    
   11 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/3                                                   
   12 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/3                                                   
   13 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/3                                                    
   14 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/4                                                   
   15 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/4                                                   
   16 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/4                                                    
   17 root      RT  -5     0    0    0 S  0.0  0.0   0:00.01 migration/5                                                   
   18 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/5                                                   
   19 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/5        
top for oraprod
top - 16:41:02 up 2 days,  1:00,  4 users,  load average: 0.98, 0.98, 0.96
Tasks: 403 total,   2 running, 400 sleeping,   0 stopped,   1 zombie
Cpu(s):  6.3%us,  0.0%sy,  0.0%ni, 93.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  24674616k total, 22832872k used,  1841744k free,   181568k buffers
Swap: 21692400k total,   123244k used, 21569156k free, 19688904k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                      
26937 oraprod   25   0 4260m 856m 844m R 100.0  3.6 178:56.94 oracle                                                       
20130 oraprod   15   0 52472  10m 6368 S  0.0  0.0   1:06.71 tnslsnr                                                       
20177 oraprod   15   0 4246m  22m  18m S  0.0  0.1   0:10.77 oracle                                                        
20179 oraprod   15   0 4245m  16m  13m S  0.0  0.1   0:00.23 oracle                                                        
20181 oraprod   15   0 4245m 2.2g 2.2g S  0.0  9.4   0:26.25 oracle                                                        
20183 oraprod   15   0 4249m 2.9g 2.9g S  0.0 12.3   2:47.31 oracle                                                        
20185 oraprod   15   0 4249m 2.9g 2.8g S  0.0 12.1   2:42.03 oracle                                                        
20187 oraprod   15   0 4260m  48m  44m S  0.0  0.2   5:38.32 oracle                                                        
20189 oraprod   16   0 4245m 188m 184m S  0.0  0.8   0:23.59 oracle                                                        
20191 oraprod   15   0 4251m 1.8g 1.8g S  0.0  7.8   0:27.21 oracle                                                        
20193 oraprod   18   0 4246m  46m  41m S  0.0  0.2   0:00.04 oracle                                                        
20195 oraprod   15   0 4246m 343m 339m S  0.0  1.4   0:04.98 oracle                                                        
20197 oraprod   15   0 4248m 433m 427m S  0.0  1.8   0:05.03 oracle                                                        
20199 oraprod   18   0 4245m 111m 108m S  0.0  0.5   0:07.18 oracle                                                        
20205 oraprod   15   0 4245m  18m  14m S  0.0  0.1   0:00.00 oracle                                                        
20216 oraprod   18   0 4245m  23m  19m S  0.0  0.1   0:00.00 oracle                                                        
20219 oraprod   18   0 4245m  17m  13m S  0.0  0.1   0:00.01 oracle                                                        
20770 oraprod   15   0 4246m  39m  34m S  0.0  0.2   0:00.04 oracle             
Thanks,
Sinan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points