IBM Support

IZ09923: The v$lock query used by the Oracle ASM is extraordinarily CPU intensive on Oracle 9.2/AIX without rule-based optimization.

Readmes are available

IBM Tivoli 4.0.0-TIV-SSM-FP0010
IBM Tivoli 4.0.0-TIV-SSM-FP0011
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 12 README 4.0.0-TIV-SSM-FP0012
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 13 README 4.0.0-TIV-SSM-FP0013
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 14 README 4.0.0-TIV-SSM-FP0014
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.14-TIV-SSM-IF0001
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 2 README 4.0.0.14-TIV-SSM-IF0002
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 3 README 4.0.0.14-TIV-SSM-IF0003
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 4 README 4.0.0.14-TIV-SSM-IF0004
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 5 README 4.0.0.14-TIV-SSM-IF0005
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 6 README 4.0.0.14-TIV-SSM-IF0006
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 7 README 4.0.0.14-TIV-SSM-IF0007
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 8 README 4.0.0.14-TIV-SSM-IF0008
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.15-TIV-SSM-IF0001

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Queries against the v$lock tables can take a long time to
return.  One customer has observed the SQL statement that the
Oracle ASM submits to have taken over 8 minutes to return.

Local fix

  • There is no current fix.  What can be done is to disable
monitoring on those specific tables by disabling the relevant
Control Table, (see the section on "Controlling Queries" in
the Oracle Application Monitor of the SSM Reference Guide).

Problem summary

  • Added the oraLockQueryHint scalar to the oraQueryControl group,
allowing an optimizer hint to be added to the query.

Problem conclusion

  • Fix will be available in 4.0.0-TIV-SSM-IF0003

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ09923
    • 

  • Reported component name
    NETCOOL SYS SVC
    • 

  • Reported component ID
    5724P4300
    • 

  • Reported release
    320
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2007-12-03
    • 

  • Closed date
    2008-02-08
    • 

  • Last modified date
    2008-04-10
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    NETCOOL SYS SVC
    • 

  • Fixed component ID
    5724P4300
    • 



Applicable component levels


    

  • R400  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCP7NT","label":"Netcool System Service Monitor"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"320","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            10 April 2008
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback