IZ19880: ITM 6.1- SOME ATTRIBUTES IN 'ORACLE SGA MEMORY' GROUP ARE ZERO

APAR status

• Closed as program error.

Error description

• Environment:
  ===========
  1) Agent:
  Oracle Agent 6.1 + FP01
  Oracle Database 10g Release 10.2.0.3.0
  Red Hat Enterprise Linux ES release 3 (32-bit)
  
  2) TEMS/TEPS:
  ITM 6.2
  Windows 2003 Enterprise Edition SP2
  
  C. * Failure Description:
  Oracle SGA Memory has some attributes whose values are zero.
  Examples of such attributes are Data Cache size (MB), SGA pct
  data cache, SGA pct dict cache, shared pool size.
  Of them, Data Cache Size (MB)'s value is correct in other
  workspace, 'Oracle Server'
  
  D. * Steps to recreate:
  1. Go to Query Editor.
  2. Select new query, then select 'oracle' under category, give a
  name to query, click ok. Then select 'Oracle SGA Memory' and
  then select all under     'Items' list box. click ok.
  3. Observe the data for above mentioned attributes(Data Cache
  size (MB), SGA pct data cache, SGA pct dict cache, shared pool
  size).
  

Local fix

Problem summary

• The values for several Oracle SGA Memory attributes are
  incorrectly returned as zero. The attributes include: Data Cache
  size (MB), SGA pct data cache, SGA pct dict cache, shared pool
  size.
  

Problem conclusion

• This APAR has been fixed and delivered in a limited availability
  fix 6.1.0.1-TIV-ITM_ORA-LA0008. This maintenance delivery
  vehicle is a limited availability patch and therefore is in a
  "hidden directory." Level 2 Support can provide down load
  instructions to you. Contact level 2 support at:
  
  http://www.ibm.com/software/sysmgmt/products/support/Contact_L2
  Support.html
  

Temporary fix

Comments

APAR Information

• 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

  TIV MON ORACLE

• Fixed component ID

  5724B96OO

Applicable component levels

• R610 PSY

     UP