3 Replies Latest reply: Nov 9, 2012 12:57 PM by Hussein Sawwan-Oracle RSS

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

    stopuz
      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