IBM Tivoli Monitoring for Databases: Oracle Agent 6.2.1-TIV-ITM_ORA-IF0007

Downloadable files


Abstract

This fix resolves the APARs and defects listed in the "Problems Fixed" section below. This fix also includes the superseded fixes listed in section 2.4. Updated 2/19/2013

Download Description

Copyright International Business Machines Corporation 2012.

All rights reserved.

Component: IBM(R) Tivoli(R) Monitoring for Databases: Oracle Agent,
Version 6.2.1

Component ID: 5724B96OO

Interim Fix: 0007, 6.2.1-TIV-ITM_ORA-IF0007

Date: Oct 12, 2012

Contents:

1.0 General description
2.0 Problems fixed
3.0 Architecture and prerequisites
4.0 Image directory contents
5.0 Installation instructions
6.0 Additional installation information
7.0 Known problems and workarounds
8.0 Additional product information
9.0 Copyright and trademark information
10.0 Notices

1.0 General description
===============
This fix resolves the APARs and defects listed in the "Problems Fixed"
section below. This fix also includes the superseded fixes listed in
section 2.4.


2.0 Problems fixed
============
The following problems are addressed by this fix.

2.1 APARs
-------------
APAR: IV24791
Abstract: COLLECTOR CRASH ON CURSOR KORSRVRD
Additional information: Oracle Agent collector process of
kor<nn>col gets core dump if the cursor KORSRVRD
(Oracle Server Options) or its pre_cursors of
KSRVRD1/KSRVRD2 is in running.

APAR: IV22048
Abstract: PROCESS DETAIL CURSOR UNABLE TO HANDLE LONG PARAMETER
ON SOLARIS
Additional Information: The KORPROCD (process detail) cursor gets
information of Oracle's processes by calling kddos or kddos64
process with processes' ID list as parameter. When the whole
command is longer than 1024 characters, the agent cannot handle it,
and report error message in collector log file:

<hostname>_or_<oraclesid>_col.out
-------------------------------------------
UEX2051E KDDUEXE(512) cmdparms overflow (1319), cmd=(kddos),
parms=(pss '18171' .....
-------------------------------------------

APAR: IV16897
Abstract: TS8A(FREE_SPACE_AUTOEXTEND) CAUSE AGENT TIMEOUT
Additional Information: The agent cursor TS8A
(Free Space Including Autoextend) takes more than 5 minutes
to complete the data query in the Oracle database.
This causes all other cursors get timeout and return no data
to the Tivoli Enterprise Portal(TEP) even if user extends the
agent timeout value from default 45 seconds to 300 seconds.

To use new SQL in the TS8A, do the following steps:
1) Additional option need to be set in the agent configure file
installdir/config/host_or_sid.cfg .

export KOR_TS8A_NEWTABLE=1

2) Grant Oracle user Create Global Temporary Table authority.
3) Restart the Oracle agent.

APAR: IV13724
Abstract: OPEN CURSORS PER SESSION IS WRONG
Additional Information: Agent may return wrong value on the
attributes in the following:

Oracle_Session_Detail_64(KORSESDX)/Open Cursors(OPENCURS)
Oracle_Session_Detail_64(KORSESDX)/Total Open Cursors(TOTOPENCUR)
Oracle_Session_Detail(KORSESSD)/Open Cursors(OPENCURS)
Oracle_Session_Detail(KORSESSD)/Total Open Cursors(TOTOPENCUR)

You might see Open Cursors > 100% in Session Detail view, and
Total Open Cursors > value of open_cursors parameter.

APAR: IV13722
Abstract: KORERR CORE DUMP IN CURSOR KORALRTD
Additional Information: Agent utility binary 'korerr' may core dump
in the cursor KORALRTD if there is long 'ORA-*' string
(length >= 10, without the message text after colon) in the
Oracle Database Alert log file.

For example:
ORA-01656:
ORA-027300:

ORA-001001:
ORA-001031:

APAR: IV08084
Abstract: Collector crashes at cursor KORLCON2 and KORLCONF
Additional Information: Oracle Agent collector process (kor<nn>col)
crashes when there are more than 1365 records in cursor KORLCON2
or KORLCONF.

APAR: IV03899
Abstract: KORSQL CORE DUMP IN AIX
Additional Information: Oracle Agent gets core dump from binary
file kor<nn>sql when the output of command "df -k <dbf_file>"
contains two lines about disk usage information in AIX platform.

For example:

Output of df -k looks like following in problematic AIX platform:

#df -k /datafiles/test.dbf
Filesystem 1024-blocks Free %Used Iused %Iused
Mounted on
ibm01:/datafiles 1177419776 821516 100% 415 1%
/datafiles
/dev/dbfiles 1177419776 821516 100% 415 1%
/corp/datafiles

Output of df -k looks like following in normal AIX platform:

#df -k /datafiles/test.dbf
Filesystem 1024-blocks Free %Used Iused %Iused
Mounted on
/dev/datafiles 18219008 1274288 94% 128222 31%
/datafiles


2.2 Defects
--------------
Defect: 185842
Abstract: No data from Free_Space_Including_Autoextend
Additional Information: Oracle agent's cursor TS8A(Free
Space Including Autoextend) will not execute successfully
if the target Oracle database's directory(tivolior_temp)
object does not exist or the value of this directory is
not accessable(read+write) to both Oracle OS user and
Agent OS user. Oracle agent will use the installdir/logs
as the alternative temporary directory.

Defect: 185766
Abstract: Error message from korgrant.sql
Additional Information: there is error message
during the execution of Oracle user granting sql files:
korgrant.sql, korgrant_user.sql or korgrantcustom.sql.

ERROR at line 1:
ORA-01543: tablespace 'TIVOLIORTS' already exists

ERROR at line 1:
ORA-01543: tablespace 'TIVOLIORTEMPTS' already exists

Note: such error message can be ignored for the end user.

Defect: 185490
Abstract: No version info in the korgrant.log file
Additional Information: a version tag will be logged
in the log file like below:

SQL> -- Print diagnostic information
SQL> select '&1' username,
2 '&2' temp_dir ,
3 to_char(sysdate, 'YYYY/MM/dd hh:mm:ss') time,
4 '6.2.1-TIV-ITM_ORA-IF0007' version
5 from dual;
old 1: select '&1' username,
new 1: select 'tivoli' username,
old 2: '&2' temp_dir ,
new 2: '/tmp' temp_dir ,

USERNA TEMP TIME VERSION
------ ---- ------------------- ------------------------
tivoli /tmp 2012/07/07 09:07:34 6.2.1-TIV-ITM_ORA-IF0007

Defect: 179330
Abstract: COLL_NUMBAKOUT/COLL_WRAPLINES DEFAULT VALUES
Additional Information: Following agent environment variables
will be added into the agent configuration files if they
did not set in the file.

WAIT_TIMEOUT
COLL_WRAPLINES
COLL_NUMOUTBAK
COLL_DISABLE_CURSOR_TS8A

for example:
#cat /opt/IBM/ITM/config/tivpc027.cn.ibm.com_or_oradb.cfg
...
# To set agent collector inter-communication timeout, enable variable WAIT_TIMEOUT.
# Note: Default timeout is 45 seconds, maximum timeout time is 600 seconds
#WAIT_TIMEOUT="45"

# To set collector log file line limit, enable following variable COLL_WRAPLINES.
#COLL_WRAPLINES="100000"

# To set collector log file number, enable following variable COLL_NUMOUTBAK.
#COLL_NUMOUTBAK="9"

# To enable the free space including autoextend, enable following variable COLL_DISABLE_CURSOR_TS8A.
#COLL_DISABLE_CURSOR_TS8A="0"

Defect: 167277
Abstract: CANNOT DISPLAY DATE IN THE COL LOG ENTRY
Additional Information: there is only time
(HourMinuteSecond) as the timestamp in the collector log files.

For example in the tivp56_or_orcl_col.out file:

PTC4760I (042156) Trace Parsing ended ok
CML1530I (042156) Start collecting. -----------------------------

The date will be added into the timestamp in the log file:

PTC4760I (2012-07-17 18:56:46) Trace Parsing ended ok
CML1530I (2012-07-17 18:56:46) Start collecting. ----------------

Defect: 145939
Abstract: Repeat warning message in collection log and output file
Additional Information: Oracle agent prints out warning
messages like following by interval. It's not necessary with
default log trace level and will be only printed out with
detail trace level.

CMA3530E (101747) Math statement SHSVRPRPCT for cursor KORPROCS
references KORSHSPC which has no rows, setting answer to 0

EER0089E (101839) korerr:Start:read_tnsnames: Can't read
file /u01/app/oracle/product/10.2.0.3/network/admin/tnsnames.ora

2.3 Enhancements:
-----------------
Enhancement: 153365
Abstract: SWITCH TO TCP SQL*NET PROTOCOL TO CONNECT BY LISTENER
WITH TWO_TASK VARIABLE.
Additional Information: Oracle Agent will try to use the BEQ(IPC)
protocol to connect to Oracle Database for the data collection,
this protocol requires the $ORACLE_HOME/bin/oracle file has
suid file permission and read+execution file permission for
other users not in dba group.

With this enhancement, Oracle Agent will switch to use TCP
SQL*NET protocol to connect to Oracle Database by Oracle Listener
if agent found the oracle file does not have suid file permission.

And user can also force Oracle Agent to use the TCP SQL*NET
protocol by adding following variables into the agent configure
file installdir/config/<hostname>_or_<sid>.cfg:

export TWO_TASK=<sid>

Note: this requires that Oracle Listener is in READY status on
the monitored Oracle database instance.

for example:
-bash-2.05b$ lsnrctl status
...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...

Enhancement: 178525
Abstract: remove old core dump file to avoid filling up file system
Additional Information: There are duplicated core files in the agent
temporary directory installdir/tmp/<hostname>_or_<sid>.

for example:
[root@tivpc027 local_lis]# find . -name *core*
./tmp/tivpc027.cn.ibm.com_or_oradb/core.9916
./tmp/tivpc027.cn.ibm.com_or_oradb/core.9781
./tmp/tivpc027.cn.ibm.com_or_oradb/core.10510
./tmp/tivpc027.cn.ibm.com_or_oradb/core.11116

Enhancement: 188400
Abstract: use /*+ RULE */ hint for some Oracle Locks related cursors.

cursor KORLONEW;
cursor KORLCONF;
cursor KORLCON2;
cursor KORLOCK2;
cursor KORLOCK3;
cursor KORLKCS;

2.4 Superseded fixes
-------------------------
6.2.1-TIV-ITM_ORA-IF0006
6.2.1-TIV-ITM_ORA-LA0005
6.2.1-TIV-ITM_ORA-IF0004
6.2.1-TIV-ITM_ORA-IF0003
6.2.1-TIV-ITM_ORA-IF0002
6.2.1-TIV-ITM_ORA-IF0001

2.5 APARs and defects included from superseded fixes
----------------------------------------------------
6.2.1-TIV-ITM_ORA-IF0006
------------------------
APAR : IZ95117
Abstract : CANNOT MONITOR ORACLE TM LOCK
Additional Information: The Oracle_Lock_Conflicts attribute group
does not contain information about the TM lock. The corresponding
product predefined workspace is Contention navigator node
Contention Summary workspace Lock Conflict view.

APAR : IZ95350
Abstract : TEMS CONNECTIVITY AND SEEDING TEST HANGUP AND FAILED
Additional Information: The agent cannot verify the
Tivoli Enterprise Monitoring Server connectivity correctly even if
the Tivoli Enterprise Monitoring Server host or port is correct
on the Linux x86_64 operating system. The configuration console
stops in the 'Tivoli Enterprise Monitoring Server connectivity
and seeding tests' step.

APAR : IZ97870
Abstract : MEMORY LEAK OF KORCOLL
Additional Information: The collector process has memory leak when
there are many "Open Probe pipe errno" error messages in
<hostname>_or_<sid>_col.log, for example:
CIR1880E (191636) Open Probe pipe errno= 2.

APAR : IZ98041
Abstract : FALSE UNKNOWN LISTENER STATUS IN MULTI-INSTANCES ENVIRONMENT
Additional Information: The agent sometimes reports false unknown
status for listener in an environment with multiple Oracle agent
instances running in one IBM Tivoli Monitoring home directory
because of a script file conflict.

APAR : IZ99037
Abstract : COLLECTOR CORE DUMP IN THE FETCH EXIT CURSOR
Additional Information: The agent collector process
(kor09col, kor10col, and kor11col) might dump core in the KORPROCD
cursor if there are too many Oracle database processes. The KORPROCD
cursor runs fetch_exit cursor to launch the kddos utility, and
the PIDs for all Oracle processes are passed to kddos as parameters.
A parameter that is too long causes the collector buffer to
overflow with a core dump.

APAR : IZ99177
Abstract : COLLECTOR SELF DOWN WHEN ORACLE SERVER SHUTDOWN
Additional Information: The agent collector process
(kor09col, kor10col, and kor11col) might stop without a core file
if the monitored Oracle database server shuts down and the 'BEQ'
protocol is used between the collector and Oracle database server process.

APAR : IZ99668
Abstract : WRONG ALERT LOG DETAIL ROWS IN WINDOWNS
Additional Information: The Oracle agent might return an alert log
message with the wrong severity and wrong timestamp as 'DataFmrErr'
from the oracle alert log monitoring on the Windows operating system.

APAR : IV01226
Abstract : WRONG VALUE OF
ORACLE_ARCHIVE_DESTINATION_DETAIL.FREE_SPACE_PERCENT
ON SOME HP-UX SYSTEMS
Additional Information: The value of the
Oracle_Archive_Destination_Detail.Free_Space_Percent attribute
is wrong on some HP-UX systems, where the output of 'df -k' has
a different format from typical HP-UX systems.
----------------------------------------------------------------
Output of 'df -k' on problematic HPUX:

$ df -k /usr
/usr (/dev/vg40_aaaaaaa/lvol1) : 16601060 total allocated Kb
16529939 free allocated Kb
71121 used allocated Kb
1 % allocation used

----------------------------------------------------------------
Output of 'df -k' on normal HPUX:

-bash-3.2# df -k /tmp
/tmp (/dev/vg00/lvol4 ) : 2087768 total allocated Kb
1330544 free allocated Kb
757224 used allocated Kb
37 % allocation used
----------------------------------------------------------------
There are blank spaces between physical path name and ')' on
normal HP-UX systems, but not on problematic HP-UX systems.

Defect: 96965
Abstract: Enable WAIT_TIMEOUT when collector uses share memory
Additional Information: The agent cannot get value of WAIT_TIMEOUT
when the collector uses share memory to communicate with the agent on
Windows operating systems. The share memory is the default
communication method between the collector and the agent.

To set the environment variable WAIT_TIMEOUT on Windows systems:
Add a WAIT_TIMEOUT string value under the key
HKEY_LOCAL_MACHINE\SOFTWARE\Candle\KOR\610\instance\
Environment\ in the registry.

Defect: 141134
Abstract: Error message in TEPS log file
Additional Information: You get an Oracle agent error message in
the Tivoli Enterprise Portal Server log file but, data exist in
the portal, for example:
(4DB099BF.0002-17:ctcmwphysicaltopology.cpp,984,
"CTCMWPhysicalTopology::Data::updateTopology")
Null return from makeMObj for
</PHYSICAL_ENTERPRISE/Linux Systems/test30/orcl:test30:ORA/kor.621_20080807_0032/>

Defect: 152871
Abstract: Wrong listener information after enable trace -dddddddddd
Additional Information: The agent displays redundant and incorrect
listener information after enabling trace by adding "-dddddddddd"
into KORLISTD cursor monitoring.

Defect: 153439
Abstract: endless loop ufe2005e error message
Additional Information: The agent prints the following message in the
<hostname>_or_<col>_col.log until the disk space is 100% used.
UFE2005E KDDUTIL(2155) Error in u_free_error and not ok to jump

Defect: 153665
Abstract: Remove some useless messages from col.log file
Additional Information: Remove messages similar to the following
message from the <hostname>_or_<sid>_col.log file:
EER0089E (182342) korerr:Start:read_tnsnames: Can't read file
/opt/app/oracle/product/10.2.0.1/network/admin/tnsnames.ora

Enhancement: 145355
Abstract: SUPPORT ORACLE 11G ON SOLARIS X86_64
Additional Information: The agent supports Oracle 11G on
Solaris x86-64 from 6.2.1-TIV-ITM_ORA-IF0007.

Enhancement: 153607
Abstract: Wrap <hostname>_or_<sid>_col.log
Additional Information: In previous releases, the size of
<hostname>_or_<sid>_col.out is wrapped, but
<hostname>_or_<sid>_col.log is never wrapped.

6.2.1-TIV-ITM_ORA-IF0007 adds support of COLL_WRAPLINES and
COLL_NUMOUTBAK to limit message number and backup copy number of
<hostname>_or_<sid>_col.log.

COLL_WRAPLINES and COLL_NUMOUTBAK have default values of 30,000 and 1.
In general, do not define these values by themselves. If you
wants to define these values by themselves, you must add the
COLL_WRAPLINES and COLL_NUMOUTBAK variables into
config/<hotname>_or_<sid>.cfg.
For example:

export COLL_WRAPLINES=100000
export COLL_NUMOUTBAK=9

And then, restart the agent.

COLL_WRAPLINES:
By default, new collector log files are created each time you start
the agent or when the log file reaches the limit specified by the
COLL_WRAPLINES environment variable. COLL_WRAPLINES defines the
number of lines in the col.out and col.log files and is 30,000
lines by default (about 2 MB).

COLL_NUMOUTBAK:
By default, the product creates one backup copy of the collector
log file. The file tag is changed from *.out to *.ou1, and
*.log to *.lo1. You can configure the product to create up to
nine backup files by defining COLL_NUMOUTBAK to be an integer
from one to nine.

6.2.1-TIV-ITM_ORA-LA0005
------------------------
Enhancement: ER MR1207105258
Abstract: monitor number of free extents for segments in all
tablespaces without specifying tablespace name
Additional Information: In 6.2.1-TIV-ITM_ORA-IF0004 and preceding
fixes, users must add Tablespace Name in the formula
of the following situations to monitor the number
of free extents for segments:

Oracle_Max_Extents_Crit
Oracle_Max_Extents_Crit_2
Oracle_Max_Extents_Warn
Oracle_Max_Extents_Warn_2

6.2.1-TIV-ITM_ORA-LA0005 enhances the monitoring of free
extents for segments. The agent monitors free extents for
segments in all tablespaces without having to specify
Tablespace Name, as long as the situation formula contains
the following 2 parameters:

*VALUE Oracle_Segments_64.Total_Extents_Not_Allocated *GE <Parameter 1>
*AND
*VALUE Oracle_Segments_64.Total_Extents_Not_Allocated *LT <Parameter 2>
or
*VALUE Oracle_Segments.Total_Extents_Not_Allocated *GE <Parameter 1>
*AND
*VALUE Oracle_Segments.Total_Extents_Not_Allocated *LT <Parameter 2>

Note: The enhancement supports both Oracle_Segments_64 and
Oracle_Segments attribute groups.

Except the above 2 parameters, user can add other conditions
in the same line of these 2 necessary parameters in the
situation editor. It is optional.

User cannot define multiple lines in the situation editor.
In another word, the situation formula cannot contain "*OR".

The agent collector returns information of the first
5000 segments which Total_Extents_Not_Allocated
is greater than or equal to parameter 1 and
Total_Extents_Not_Allocated is less than parameter 2
in all tablespaces except 'UNDO', 'ROLLBACK', 'CACHE'
segments.

6.2.1-TIV-ITM_ORA-IF0004
------------------------

APAR : IZ77623
Abstract : AGENT AUTODISCOVERS ORACLE HANGUP IN SUN ZONE
Additional Information: The agent stops during the automatic
discovery step of configuration because it cannot distinguish
Oracle process from global zone and local zone.

APAR : IZ80107
Abstract : DATA\CACHE\HIT\PERCENT attribute is negative
Additional Information: Duplicate APAR with IZ31051, which was
fixed in 6.2.0.1-TIV-ITM_ORA-IF0001.

APAR : IZ83209
Abstract : TOTAL_OS_CPU_PERCENT IS WRONG ON AIX 64BIT
Additional Information: The Oracle agent returns a wrong usage
percentage of operating system CPU on AIX 64-bit operating systems.

You can navigate in the Tivoli Enterprise Portal as follows:
Servers node ->
Server Summary workspace ->
Server Summary view ->
Total OS\CPU\Percent column.

APAR : IZ85003
Abstract : KOR_PATCHDEPOT.BAT SCRIPT NOT UPDATE TARGET FILE
Additional Information: There is a kor_patchdepot.bat script in the
root path of the ifix package for the Windows(R) operating system.
This script cannot switch to the Tivoli Enterprise Monitoring Server
depot path if the depot is located on a different disk from itmhome.
The script cannot update the or_dd_062100000.xml and or_dd.properties files
in the Tivoli Enterprise Monitoring Server depot repository path.

APAR : IZ87012
Abstract : TEMPDIR NOT MANDATORY READ PERMISSION
Additional Information: The information center has the following
description for the 'temp directory':

Name of the temporary directory where the Oracle Database agent
writes temporary files. This directory must exist before
running this SQL script. Example value: /opt/IBM/ITM/tmp
The Oracle account must have write access to the directory.

The above description only lists the write permission and not the
read permission.

The following troubleshooting Technote has been published:

http://www-01.ibm.com/support/docview.wss?uid=swg21455512

Title: The Pct Free Space\Including Auto Extend column in the
Tivoli Enterprise Portal displays "Not Available"

APAR : IZ87057
Abstract : FREESPACE AUTOEXTEND FALSE RETURN NEGATIVE NUMBER
Additional Information: The 'Pct Free Space\Including Autoextend'
column and 'Free Space\Including\Autoextend(MB)' columns
return negative numbers in the Tivoli Enterprise Portal
unexpectedly. The root cause is that the Tivoli agent calculation is
wrong when the 'Maxsize' of the data file is less then the 'Size' of
the data file. This data file cannot be extended more, even if the
'autoextend' attribute of the data file is set to 'on'.

APAR : IZ87098
Abstract : FREESPACE AUTOEXTEND COUNT WRONG IN HP-UX
Additional Information: On a specific HP-UX workstation where the
output of the 'df -k' command is different from other HP-UX workstations,
the Oracle agent counts incorrectly on the Free\Space\Including\Autoextend
column and the value is the same as the value of the 'Space\Free\(MB)' column,
even if the data file is set to autoextend on and there is a large amount of
free space in the physical disk.

----------------------------------------------------------------
Output of df -k in problematic HP-UX:

/oradata/ora04137/general/system/dict
(/dev/vg01/lv_ora04137_dict ) : 2031367 total allocated Kb
986875 free allocated Kb
1044492 used allocated Kb
52 % allocation used

----------------------------------------------------------------
Output of df -k in other HP-UX:

-bash-3.2# df -k /tmp
/tmp (/dev/vg00/lvol4) : 2083328 total allocated Kb
2015112 free allocated Kb
68216 used allocated Kb
4 % allocation used
----------------------------------------------------------------


APAR : IZ88683
Abstract : WRONG SEVERITY FOR SOME ALERTS
Additional Information: An Oracle Alert message might be reported
by the Oracle agent with an incorrect severity when part of the error
id is duplicated with another error id.
For example, error id 'ORA-0206' is reported as the same severity
with error id 'ORA-02063' unexpectedly.

APAR : IZ89677
Abstract : PCT FREESPACE DISPLAY WRONG FOR TEMP TABLESPACE
Additional Information: The 'Pct Free Space' column displays '0',
the 'Pct Free Space\Including Autoextend' column and the
'Free Space\Including\Autoextend(MB)' column display incorrect numbers
for Oracle temporary tablespaces in the Tivoli Enterprise Portal.

APAR : IZ89679
Abstract : KORERR RETURN REDUNDANCY FOR ALERT LOG BY TRACE OPEN
Additional Information: There are redundancy rows to be returned
in the 'Alert Log Detail' workspace in the Tivoli Enterprise Portal
after utility korerr is appended with '-ddddddddd' in the
KORALRTD cursor in the control file 'korcoll.ctl'.

APAR : IZ89729
Abstract : DOC MISTAKE - TABLE 4: CAPACITY PLANNING FOR HISTORICAL DATA
Additional Information: All attribute groups including those that
cannot collect historical data are listed in the "Capacity planning
for historical data" table.

The following troubleshooting Technote has been published:

http://www-01.ibm.com/support/docview.wss?uid=swg21458610

Title: Document mistake - table 4: Capacity planning for
historical data in the Oracle Database agent user's guide.

APAR : IZ90133
Abstract : NO RECORD FOR OFFLINE OR RECOVER DATAFILE IN Tivoli Enterprise Portal
Additional Information: When a data file is offline or a tablespace
is offline, "Tablespace" table view does not include the offline
data file records.
In addition, the 'Total\Files\Recover' column always diaplays a
value of '0' and cannot return the exact recovered data file number.

APAR : IZ90912
Abstract : WRONG SPACE USAGE VALUE FOR TEMPORARY TABLESPACES
Additional Information: 'Oracle Tablespaces' attribute group
'Pct\Free\Space' attribute displays the wrong value for temporary
tablespaces. The relative attributes are also wrong, including
'Space\Free\(MB)', 'Space\Used\(MB)','Pct\Free\Space',
'Free Space\Including\Auto Extend(MB)', and
'Pct Free Space\Including Auto Extend'.

APAR : IZ91459
Abstract : RUNINFO FILE OWNER/PERMISSION MODIFIED WRONG
Additional Information: If the user who starts the Agent is
different from the original installation user, the IBM Tivoli Monitoring
common shared runtime files
(install_dir/config/.ConfigData/RunInfo and RunInfo_Description)
are modified with the file owner and permission
of the startup user. The new owner and permission can block other
agents from being started with the other user.

Defect: 132067
Abstract: NO CURSOR NAME IN OPEN PIPE ERROR MESSAGE
Additional Information: The agent cannot print the cursor
name when the "Open Pipe error" occurs in the log file.

Defect: 132576
Abstract: CANNOT DISABLE INTERVAL CURSORS IN CONFIG FILE
Additional Information: Some cursors run in an interval mode and
cannot be disabled in the agent configuration file by the
'db_extparms' parameter.
These cursors include 'KORLOCKS', 'KORPROCS', 'KORCACHE', 'KORCACHX'
'KORSTASX', 'KORSESSS', and 'TS2'.

Note: Corresponding SQL statements and cursor disable instructions
are listed in 8.0 Additional product information.

Defect: 133036
Abstract: KEEP OCCUPY SESSIONS WHEN ORACLE PASSWORD ABOUT TO EXPIRE
Additional Information: The agent does not exit the Oracle session
it requests when sqlca.sqlcode equals 28002, which means the Oracle
database user is close to expiring. (The password is in the duration
of PASSWORD_GRACE_TIME). The agent keeps requesting a new session for
the Oracle database user, and the count of sessions keep increasing.

Defect: 136143
Abstract: QUERY ON V$DBFILE CAUSES ORACLE SERVER PROCESS HIGH CPU
Additional Information: The query on v$dbfile causes high CPU
for the Oracle server process in the KORHART4 cursor.

Defect: 136835
Abstract: KORALRTD.MSGTIME DISPLAYS "DateFmtErr"
Additional Information: Oracle database 10.2.0.5 adds the time zone
into the timestamp in the alert log. This fix ensures that the agent
can parse both formats of timestamps in the Oracle alert log.

Defect: 136836
Abstract: ISREMOTE FAILED PROMPT WHEN AGENT STARTUP
Additional Information: Removes unnecessary messages when the agent
starts.

kddexec: kddos isremote failed, no localization.

Defect: 138832
Abstract: PCT_FREE_SPACE COUNT WRONG IN THE TEP
Additional Information: There is a row limitation in the TS2
cursor with 'limit 200' that causes the agent to calculate the wrong
value of 'Pecent\Free\Space' in the attribute group 'Tablespace'
in cases where there are more then 200 tablespaces in the Oracle
database. The value of 'Pecent\Free\Space' returns 0 no matter
how much free space remains in the temporary tablespaces such as
'TEMP'.

Defect: 144569
Abstract: PCT FREESPACE AUTOEXTEND 100% BUT PCT FREESPACE 0%
Additional Information: The value of 'Pct Free Space\Including
Auto Extend' FREESPAEX attribute is 100% when the value of
'Pct\Free\Space' PFREESPC displays 0% for non-temporary
tablespaces with auto-extend datafiles.

6.2.1-TIV-ITM_ORA-IF0003
------------------------

APAR : IZ66890
Abstract : ORA-01476: DIVISOR IS EQUAL TO ZERO BLOCK CURSOR KORPROCS
Additional Information: The Oracle agent reports an Oracle error message
with ID ORA-01476 in the log file. This error prevents the correct
value from returning in the Process\Process Summary workspace.

APAR : IZ67268
Abstract : WHEN THE ORACLE DATABASE INSTANCE HAS BEEN STANDBY OR SHUTDOWN
Additional Information: The Oracle agent cannot monitor the listener
status when the Oracle Database instance has been in standby
or shutdown.

APAR : IZ67453
Abstract: AGENT CANNOT MONITOR OVER 128 LISTENERS
Additional Information: The Oracle agent cannot read more then 128 listener
definitions from the listener.ora file, and cannot read more then
500 lines of listener definitions from the listener.ora file.
The maximum listener definition has been extended from 128 to
2048, and the maximum line number has been extended from 500
to 10,000.

APAR : IZ68097
Abstract: THE VIEW TIVOLI_KORFILES_VIEW CAUSED HIGH CPU AND MEMORY USAGE
Additional Information: The view SYS.TIVOLI_KORFILES_VIEW is created
in the korgrant.sql and used by the Oracle agent.

APAR : IZ68232
Abstract: ORACLE AGENT CONFIG PROGRAM CRASH WHEN ORACLE INSTANCE PFILEIS
Additional Information: On a Windows operating system, the Oracle agent
configuration program crashes if the Oracle Server 8i/9i
PFILE defined in the Windows registry key of
SOFTWARE\ORACLE\HOME0\ORALLE_<SID>_PFILE does not exist.

APAR : IZ69132
Abstract: KORSQL CANNOT HANDLE THE OUTPUT OF DF -K ON HP-UX
Additional Information: The Oracle agent uses the "df -k" command to
retrieve the physical disk free size and usage size. This command
cannot retrieve the correct size value for an HP-UX operating system.
This problem causes the calculation of the
Free_Space_Including_Auto_Extend attribute to be incorrect.

APAR : IZ74822
Abstract: SERVER_CPU_PCT CALCULATE WORNG W/ ZERO OR MINUS
Additional Information: The Oracle agent might return a zero or minus
value in the Server\CPU\Percent column in the Server
Summary workspace on the UNIX(R) or Linux(R) operating systems.

APAR : IZ75900
Abstract: AGENT GENERATE CORE DURING STOP IN HP-UX 11.31 IA64
Additional Information: The Oracle agent generates a core file
each time the agent stops on HP-UX 11.31 IA64 systems.

APAR : IZ76587
Abstract: AGENT COLLECTOR PROCESS HAS MEMORY LEAK
Additional Information: The Oracle agent collector processes
(kor09col, kor10col or kor11col) consume more and more
real memory (resident set) and virtual memory
during normal running.

APAR : IZ76694
Abstract: CANNOT PARSE LISTENER INFO WITHOUT KEY OF DESCRIPTION
Additional Information: The Oracle agent cannot parse the correct
listener information in case there is not a
'DESCRIPTION' key included in the definition of a listener
in the listener.ora file.

APAR : IZ77124
Abstract: LISTENER SITUATION FALSE ALERT OF INACTIVE STATUS
Additional Information: The Oracle agent issues a false alert of inactive
status of the listener in all addresses in case the first
address in a listener is inactive(such as the IPC protocol in the
following example).
#################################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY =
EXTPROC)))
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
gb02qvn020rbsx7)(PORT = 1521)))
)
)
#################################################

APAR : IZ77391
Abstract: ALERT LOG MONITOR FAILED AFTER 30 MINS
Additional Information: The Oracle agent cannot read from the Oracle alert
log file to monitor the alert log after 30 minutes since agent
startup. The following error message is in the agent log file:

ERB0020E (133914) read_backwards: fileName <path>,
initialization failed|

Defect: 121900
Abstract: AGENT CANNOT IDENTIFY ORA PARAMETER LOCAL_LISTENER
Additional Information: The Oracle agent cannot identify correct
listener information in cases where you defined the detail of
the listener in the Oracle local_listener parameter directly,
instead of using a listener name alias.

Defect: 123349
Abstract: FREE_SPACE_INCLUDING_AUTOEXTEND COUNT WRONG
Additional Information: The Oracle agent count is wrong for the
Free_Space_Including_Autoextend attribute when one data file
in a tablespace is set with autoextend on and the maximum size
of this data file is lower then the free disk space in the
current mount point.

Defect: 123696
Abstract: COMMENT LINE START WITH '=' CAUSE KORERR CORE
Additional Information: The Oracle agent cannot parse the correct
listener information from the listener.ora file or tnsnames.ora
file if there is a comment line starting with the = character in
these two files.

Defect: 124052
Abstract: AGENT CANNOT SET PATH OF ORACLE_HOME BYSELF
Additional Information: The Oracle agent works as a Windows service
on Windows operating systems, and the agent depends on the
Windows system PATH variable.

Important note: After you apply this patch, the Oracle agent
instance must be removed and reconfigured on the Windows
operating system to remove the dependency of the Windows system
PATH variable.

Defect: 132014
Abstract: NOT ALL LISTENER ADDRESSES ARE VERIFIED WITH TNSPING
Additional Information: The Oracle agent does not use the Oracle
'tnsping' utility to verify the correct status of the Oracle
listener in each valid address. The Oracle agent might report an
incorrect listener status.


6.2.1-TIV-ITM_ORA-IF0002
------------------------

APAR: IZ58688
Abstract: INCORRECT OUTPUT FOR "ARCH DEST PCT FULL" VALUE ON
ORACLE AGENT
Additional Information: The Archive Dest Pct Full column in
the Server Summary workspace displays an incorrect value
that is different from the output of the "df -k" command.

APAR: IZ59224
Abstract: WRONG VALUE FOR "PCT FREE SPACE INCLUDING AUTO EXTEND"
Additional Information: The Pct Free Space Including Auto
Extend column in the Tablespace view displays an incorrect value
when the size of the tablespace is full.

APAR: IZ60378
Abstract: GRANTING ON TIVOLI USER FAILS
Additional Information: A new SQL script, korgrant_user.sql, is
packaged in the IF0002. These are the usage
instructions:

1. Recreate the user after dropping the existing user
and role as SYSDBA.

sqlplus / as sysdba
SQL> drop user TIVOLI cascade;
SQL> drop role TIVOLI_ROLE;
SQL> create user TIVOLI identified by "password";

2. Apply IF0002.

3. Run the korgrant_user.sql script to grant the
required privileges to the TIVOLI user.

cd $candlehome/misc
sqlplus / as sysdba
SQL> @korgrant_user.sql TIVOLI $tmp_dir;

4. Check whether there is a korgarnt_user.log file in
$tmp_dir after korgrant_user.sql has run completely.
The korgarnt_user.log must not have granting errors in it.
You can ignore the error about V_$MTS.

5. Restart the Oracle agent.

APAR: IZ63540
Abstract: ORACLE AGENT GENERATES CORE FILES WHILE ALERT LOG DELETED
Additional Information: Core files are generated under the
$CANDLEHOME/tmp/<hostname>_or_<instancename>/ directory
if the file alert_<sid>.log is removed from the
background_dump_dest directory.
Also, the following error message is logged in the file:
$CANDLEHOME/logs/<hostname>_or_<instancename>_col.out
------------------------------------------------------------
Interval collection failed for cursor SETERRLG
No data in cursor (SETERRLG) for hv (SETERRLG.ERRLOG
in script (korerr -log [SETERRLG.ERRLOG [KORV.LOGTIME )
Call Exit korerr, Parms -log .
Error, Usage : korerr -log <errorlogname> <integer greater
than -1>
------------------------------------------------------------


APAR: IZ63561
Abstract: KORERR GENERATES CORE WHEN QUERYING LISTENER INFO
Additional Information: The Oracle agent generates a core file if
additional properties are defined before the listener
definition in the listener.ora file.
For example,
-bash-3.00$ more listener.ora
# listener.ora Network Configuration File:
# /orah1/product/11.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
# Additional properties definition start
INBOUND_CONNECT_TIMEOUT_LISTENER_dodsprep = 120
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_dodsprod = OFF
# Additional properties definition end

#Normal listener definition start
listener_dodsprod =
(DESCRIPTION_LIST =
...
#Normal listener definition end

Defect: 113278
Abstract: Wrong value for KORSRVR.SRVRSTATUS
Additional Information: A situation with the
SERVSTATUS!='Active' condition is fired unexpectedly when
the database is started normally.

6.2.1-TIV-ITM_ORA-IF0001
------------------------

APAR: IZ44045
Abstract: IBM TIVOLI MONITORING OR AGENT DOES NOT DISPLAY DATA ON TIVOLI ENTERPRISE PORTAL
DUE TO LONG RUNNING
Additional Information: If more than 500 sessions are open on
a heavily loaded Oracle database, the Tivoli Enterprise
Portal workspace might not display any data because of
slow responding cursors.

APAR: IZ52073
Abstract: SERVER STATUS IS NOT ACTIVE-RESTRICT AFTER STARTUP RESTRICT
Additional Information: After the monitored database is started with
the restrict option, "Server Status" in the Server Summary
workspace does not become "Active-Restrict."

The database user for the agent must have the "RESTRICTED
SESSION" privilege.

APAR: IZ54861
Abstract: THE QUERY ON V$ACCESS or V$OPEN_CURSOR CAUSES HIGH CPU
Additional Information: Querying these two views, V$ACCESS or V$OPEN_CURSOR,
might cause the Oracle high CPU problem, the ORA-7445 error,
or the Oracle instance core dump error in some environments.

This fix provides a new setting to disable the queries on
these two views: Append "KORSESSB, KORSESSO, KORSESSX" to the
"Extended Parameters" to disable queries on V$ACCESS and
V$OPEN_CURSOR. The new setting affects some attributes in the
Tivoli Enterprise Portal. See Section 8.0 for details.

The queries on these two cursors are enabled by default,
so you must disable these queries manually.

Defect: 94398
Abstract: The koragent fails to retrieve data from collector process.
Additional Information: On HP-UX Itanium 64 operating systems, if the
WAIT_TIMEOUT or COLL_WAITTIMEOUT parameters are specified in the
agent instance configuration file, no data is displayed
in the Tivoli Enterprise Portal view. The error message, "Write
Pipe error 22", can be found in the koragent log files.

Defect: 95753
Abstract: Enable customization of the severity level of Oracle message ID
Additional Information: The data displayed in the Tivoli Enterprise Portal
Alert Log view does not correspond to the customization of the
severity level of the Oracle message ID, which is saved in the
$CANDLEHOME/misc/regExp<orcl>.properties file on UNIX systems, or in
%CANDLE_HOME%\TMAITM6\regExp<orcl>.properties on Windows systems.

Defect: 105350
Abstract: KORSRVR.ARCDESTU is wrong for 64 Multiple Archive Dest
Database
Additional Information: On a 64-bit operating system, when more than
one Oracle Archive Destination is specified, the Percent
Archive Free Space, Archive Free Space(kb), and Archive
Used Space(kb) attributes in the Oracle Server attribute
group show an incorrect value.


3.0 Architecture and prerequisites
==================================
The following link is for the Tivoli platform and application support
matrix. See this matrix for the latest certification
information:

http://www.ibm.com/software/sysmgmt/products/support/Tivoli_Supported_Platforms.html

3.1 Prerequisites for this fix:
--------------------------------
The prerequisite level for this fix is as follows:
- IBM Tivoli Composite Application Manager Agent for Oracle Agent,
Version 6.2.1

Because this fix is cumulative, it can be installed on any fix level for
this version, release, and modification level above the prerequisite.


4.0 Image directory contents
============================
This fix image contains the following files:

- 6.2.1-TIV-ITM_ORA-IF0007.README - This README file
- 6.2.1-TIV-ITM_ORA-IF0007.tar - Fix archive .tar format
- 6.2.1-TIV-ITM_ORA-IF0007.zip - Fix archive .zip format

Note: The .tar and .zip files are identical in content. Use the .tar
file if you are working in a UNIX environment; use the .zip file if
you are working in a Windows environment.

The fix archive file contains the following files:
6.2.1-TIV-ITM_ORA-IF0007/inst_prereq_patch.sh
6.2.1-TIV-ITM_ORA-IF0007/inst_prereq_itmpatch.exe.bat
6.2.1-TIV-ITM_ORA-IF0007/kdd_aix523_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_aix526_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_aix533_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_aix536_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_hpi116_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_li6243_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_li6263_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_lia266_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_ls3243_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_ls3246_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_ls3263_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_ls3266_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_lpp266_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_lx8266_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_sol283_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_sol286_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_sol293_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_sol296_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kdd_sol606_tema_if0006.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_aix523_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_aix526_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_aix533_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_aix536_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_hpi116_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_li6243_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_li6263_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_lia266_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_lpp266_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_ls3243_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_ls3246_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_ls3263_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_ls3266_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_lx8266_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_sol283_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_sol286_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_sol293_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_sol296_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_sol606_tema_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_tems_teps_tepd_if0007.tar
6.2.1-TIV-ITM_ORA-IF0007/kor_tems_teps_tepd_if0007.zip
6.2.1-TIV-ITM_ORA-IF0007/KOR_winnt_tema_if0007.cab
6.2.1-TIV-ITM_ORA-IF0007/kdd_winnt_tema_if0006.cab
6.2.1-TIV-ITM_ORA-IF0007/KORWINNT.dsc
6.2.1-TIV-ITM_ORA-IF0007/koraix523.dsc
6.2.1-TIV-ITM_ORA-IF0007/koraix526.dsc
6.2.1-TIV-ITM_ORA-IF0007/koraix533.dsc
6.2.1-TIV-ITM_ORA-IF0007/koraix536.dsc
6.2.1-TIV-ITM_ORA-IF0007/korhpi116.dsc
6.2.1-TIV-ITM_ORA-IF0007/korsol283.dsc
6.2.1-TIV-ITM_ORA-IF0007/korsol286.dsc
6.2.1-TIV-ITM_ORA-IF0007/korsol293.dsc
6.2.1-TIV-ITM_ORA-IF0007/korsol296.dsc
6.2.1-TIV-ITM_ORA-IF0007/korsol606.dsc
6.2.1-TIV-ITM_ORA-IF0007/korli6243.dsc
6.2.1-TIV-ITM_ORA-IF0007/korli6263.dsc
6.2.1-TIV-ITM_ORA-IF0007/korlia266.dsc
6.2.1-TIV-ITM_ORA-IF0007/korlpp266.dsc
6.2.1-TIV-ITM_ORA-IF0007/korls3243.dsc
6.2.1-TIV-ITM_ORA-IF0007/korls3246.dsc
6.2.1-TIV-ITM_ORA-IF0007/korls3263.dsc
6.2.1-TIV-ITM_ORA-IF0007/korls3266.dsc
6.2.1-TIV-ITM_ORA-IF0007/korlx8266.dsc
6.2.1-TIV-ITM_ORA-IF0007/or_dd.properties
6.2.1-TIV-ITM_ORA-IF0007/or_dd_062100007.xml


5.0 Installation instructions
=============================
This fix can only be installed over an existing installation. Use
the following steps to install this fix.

5.1 Before installing the fix
-----------------------------
- The prerequisites listed under section 3.1 entitled 'Prerequisites
for this fix' must be installed before this fix can be installed.

- For the purpose of this README, the symbol <CANDLEHOME> is the
IBM Tivoli Monitoring installation directory. The default value
for CANDLEHOME is '/opt/IBM/ITM' on UNIX systems and 'C:\IBM\ITM'
on Windows systems.

Before installing this fix on UNIX systems, set the environment
variable CANDLEHOME to the IBM Tivoli Monitoring installation
directory.

For example:
> CANDLEHOME=/opt/IBM/ITM
> export CANDLEHOME

- Because there is no uninstall utility for this fix, be sure to
perform a backup of your environment before installing this fix.

- If you have customized the Oracle agent korcoll.ctl file,
this file is backed up during the fix install
as korcoll.ctl.621.{timestamp}. After this fix is installed,
edit the latest korcoll.ctl file and merge your modifications
into this korcoll.ctl file.

5.2 Local agent update
----------------------
1. Transfer the appropriate archive file (6.2.1-TIV-ITM_ORA-IF0007.tar
or .zip) to a temporary directory on the system that contains the
agent code to be updated. For the purpose of this README, the
<TEMP> symbol represents the fully qualified path to this
directory. Note: On Windows systems, this path includes the drive
letter.

2. Expand the archive file using the "tar" command on UNIX systems
or an extract utility on Windows systems. This step creates a
directory structure that contains fixes for all of the supported
platforms.

3. Use the "itmpatch" command to install the included prerequisite
fix for the target agent platform. For more information on the
"itmpatch" command, see section [6.2].

On UNIX systems, if the fix was expanded to
<TEMP>/6.2.1-TIV-ITM_ORA-IF0007, the install command is:

> itmpatch -h <CANDLEHOME>
-i <TEMP>/6.2.1-TIV-ITM_ORA-IF0007
/kdd_xxxxxx_tema_if0006.tar

where:
- xxxxxx corresponds to the value in the first column
returned by the ./cinfo -i command.

In the following example, the file is kdd_li6243_tema_if0006.tar
> ./cinfo -i
Distributed Database common code
li6243 Version: 06.21.00.06

On a Windows system, if the fix was expanded to
<TEMP>\6.2.1-TIV-ITM_ORA-IF0007, the install command is:

> itmpatch -h <CANDLEHOME>
-i <TEMP>\6.2.1-TIV-ITM_ORA-IF0007
\kdd_winnt_tema_if0006.cab

4. Use the "itmpatch" command to install the fix for the operating
system for that agent. For more information about the "itmpatch"
command, see section [6.2].

On UNIX systems, if the fix was expanded to
<TEMP>/6.2.1-TIV-ITM_ORA-IF0007, the install command is:

> itmpatch -h <CANDLEHOME>
-i <TEMP>/6.2.1-TIV-ITM_ORA-IF0007
/kor_xxxxxx_tema_IF0007.tar

where:
- xxxxxx corresponds to the value in the first column returned
by the ./cinfo -i command.

In the following example, the file is kor_li6243_tema_if0007.tar
> ./cinfo -i
Monitoring Agent for Oracle
li6243 Version: 06.21.00.07

On a Windows system, if the fix was expanded to
<TEMP>\6.2.1-TIV-ITM_ORA-IF0007, the install command is:

> itmpatch -h <CANDLEHOME>
-i <TEMP>\6.2.1-TIV-ITM_ORA-IF0007
\KOR_winnt_tema_if0007.cab

5. #########################IMPORTANT NOTE#########################
Fix 6.2.1-TIV-ITM_ORA-IF0007 includes changes to the agent user
database permission. the 'korgrant.sql' or 'korgrantcustom.sql'
or 'korgrant_user.sql' script must be run after applying
fix 6.2.1-TIV-ITM_ORA-IF0007.

See the Oracle Agent 6.2.1 User's Guide for Graning permissions.
http://publib.boulder.ibm.com/infocenter/tivihelp/v24r1/topic/com.ibm.itcama.doc_6.2.2/config.htm?path=2_20_1_11_3_2_2#grantpermissionwin



5.3 Remote agent update
-----------------------
1. Transfer the appropriate archive file (6.2.1-TIV-ITM_ORA-IF0007.tar
or .zip) to a temporary directory on the IBM Tivoli Enterprise
Monitoring Server system. For the purpose of this README, the
symbol <TEMP> represents the fully qualified path to this
directory. Note: On Windows systems, this path includes the
drive letter.

2. Expand the archive file using the "tar" command on UNIX systems or
an extract utility on Windows systems. This step creates a
directory structure that contains fixes for all of the supported
platforms.

3. To add the agent fix bundles into the remote deploy depot, use
the "tacmd addBundles" command found in $CANDLEHOME/bin on UNIX
systems or in %CANDLE_HOME%\bin on Windows systems. For more
information on the "tacmd addBundles" command, see the IBM Tivoli
Monitoring Administrator's Guide.

On UNIX systems,
if the fix was expanded to <TEMP>/6.2.1-TIV-ITM_ORA-IF0007:
> $CANDLEHOME/bin/tacmd addBundles -n -i <TEMP>/6.2.1-TIV-ITM_ORA-IF0007

On a Windows system,
if the fix was expanded to <TEMP>\6.2.1-TIV-ITM_ORA-IF0007:
> %CANDLE_HOME%\bin\tacmd addBundles -n -i <TEMP>\6.2.1-TIV-ITM_ORA-IF0007

where:
-n indicates that prerequisite bundles are not automatically
added. The -n parameter must be used because the fix
directory does not contain any prerequisites that the fix
might require. Please see Section 3.1 for the prerequisites
for this fix.
-i is the directory that contains the deployment bundles to be
added to the depot.

4. To log in to the Tivoli Enterprise Monitoring server, and deploy
the fix to the appropriate nodes where the agent is running, use
the following "tacmd" commands. For more information on the
"tacmd login" and "tacmd updateAgent" commands, see the IBM Tivoli
Monitoring Administrator's Guide.

On UNIX systems:
> $CANDLEHOME/bin/tacmd login -s <server>
-u <itmuser>
-p <password>

> $CANDLEHOME/bin/tacmd listSystems

The output shows the Managed System Name for the OS agent on the
remote system to be updated. Use this value as the target of the
tacmd updateAgent command.

> $CANDLEHOME/bin/tacmd updateAgent -t or
-n <Managed system name>
-v 062100007

On Windows systems:
> %CANDLE_HOME%\bin\tacmd login -s <server>
-u <itmuser>
-p <password>

> %CANDLE_HOME%\bin\tacmd listSystems

The output shows the Managed System Name for the OS agent on the
remote system to be updated. Use this value as the target of the
tacmd updateAgent command.

> %CANDLE_HOME%\bin\tacmd updateAgent -t OR
-n <Managed system name>
-v 062100007
Note:
- The component (-t) for the "tacmd updateAgent" command is
specified as two characters (or), not three characters (kor).
- The node (-n) for the "tacmd updateAgent" command is the managed
system name of the operating system (OS) agent to be updated.
The target node for an "tacmd updateAgent" command is always an
OS agent.
-The following error might occur with the updateAgent command on
Linux(R) and UNIX endpoints, however the agent is successfully
updated. This error does not occur on Windows endpoints.

KUICUA011I: Updating the or agents.
KUICUA015E: The updateAgent command did not complete because
an error occurred. Refer to the following error
returned from the server:

The monitoring server encountered an error while updating the
managed system type.

The kuiras1.log file might provide more information about
this error. If you require further assistance resolving the
error, contact IBM Software Support.

A timeout occurred while waiting for an agent task to
complete on {node name}.

The agent task did not complete within the configured
time out period.

Verify that the target system is online. Increase the
time out value and try the operation again.

5. #########################IMPORTANT NOTE#########################
Fix 6.2.1-TIV-ITM_ORA-IF0007 includes changes to the agent user
database permission. the 'korgrant.sql' or 'korgrantcustom.sql'
or 'korgrant_user.sql' script must be run after applying
fix 6.2.1-TIV-ITM_ORA-IF0007.

See the Oracle Agent 6.2.1 User's Guide for Graning permissions.
http://publib.boulder.ibm.com/infocenter/tivihelp/v24r1/topic/com.ibm.itcama.doc_6.2.2/config.htm?path=2_20_1_11_3_2_2#grantpermissionwin

5.4 Agent support update
------------------------
Fix 6.2.1-TIV-ITM_ORA-IF0003 included changes to the agent
support files that need to be installed. If you have already
installed these updates, there are no additional installation
steps. Otherwise, use the following steps to update the Tivoli
Enterprise Monitoring Server, Tivoli Enterprise Portal Server, or
Tivoli Enterprise Portal Desktop.

1. Transfer the appropriate archive file (6.2.1-TIV-ITM_ORA-IF0007.tar
or .zip) to the Tivoli Enterprise Monitoring Servers,
Tivoli Enterprise Portal Servers, or Tivoli Enterprise Portal
Desktops.

2. Expand the archive file using the "tar" command on UNIX systems
or an extract utility on Windows systems. This step creates a
directory structure that contains fixes for all of the supported
platforms.

3. Expand the archive file (kor_tems_teps_tepd_if0007.tar or .zip)
that contains the updates for Tivoli Enterprise Monitoring Server,
Tivoli Enterprise Portal Server, and Tivoli Enterprise Portal
Desktop using the "tar" command on UNIX systems or an extract
utility on Windows systems. This step creates a directory
structure that includes a subdirectory called CD-ROM, with the
necessary updates.

4. Use the Application Support Installer(ASI) GUI or the silent
installation method to install the application support files.

GUI installation option
------------------------
The GUI can be started by using one of the following commands
from within the CD-ROM directory where setup.jar is located.

On UNIX systems:
> ./itmasi.sh [-h <CANDLEHOME>] [-j <JAVAHOME>]

On Windows systems:
> itmasi [-h <CANDLEHOME>] [-j <JAVAHOME>]

When prompted by the Application Support Installer for the
installable media directory, select the CD-ROM directory, not the
component directory. The installer can install updates for
multiple components at the same time.

Silent installation option
--------------------------
To use the silent installation option, use one of the following
commands from within the CD-ROM directory where setup.jar is
located.

Note: Using the silent installation option for Linux(R) and
zLinux operating systems requires the following files contained
in Interim Fix 6.2-TIV-ITM_ASI-IF0001:
- Linux: setupLinux.bin
- zLinux: setupLinux390.bin
Follow the installation instructions contained in the
"6.2-TIV-ITM_ASI-IF0001.README".

On UNIX systems:
> ./itmasi.sh -h <CANDLEHOME>[-silent]
[-r <response file>]
[-j <JAVAHOME>]

On Windows systems:
> itmasi -h <CANDLEHOME> [-silent]
[-r <response file>]
[-j <JAVAHOME>]

where:
-h <CANDLEHOME> - Required. The path to the IBM Tivoli
Monitoring installation directory.

-r <response file> - Optional. Customized response file name.
The default response file "response.txt" in
the CD-ROM directory can be copied and modified
for your environment. Do not update "response.txt".

-j <JAVAHOME> - Optional. The fully-qualified path to the "bin"
directory where Java(R) is installed. The
location of Java on your system might vary.

5. The next panel presented by the Application Support Installer asks
for the selection of which Tivoli Monitoring components you want
to add application support to. For this fix, check or clear the
check boxes as follows:

[checked | unchecked] - Tivoli Enterprise Monitoring Server (TEMS)
[checked | unchecked] - Tivoli Enterprise Portal Server (TEPS)
[checked | unchecked] - Tivoli Enterprise Desktop Client (TEPD)

Continue through the remaining GUI panels selecting the Oracle
06.21.00.07 support to complete the installation.

6. If the Tivoli Enterprise Portal Desktop or Tivoli Enterprise Portal
Browser was running when the update was installed, it must be
restarted.


6.0 Additional installation information
========================
6.1 Installation instructions for agent baroc file
-----------------------------------------------------
There are no updates to the baroc files included in this fix or
any of the superseded fixes. No additional installation steps are
required.

6.2 Additional information on using "itmpatch" command
--------------------------------------------------------------
The "itmpatch" command has the following syntax:

Usage: itmpatch -h <installation home> [OPTIONS]

itmpatch -h <installation home>
-t { <patch_file_directory> | <patch_file> }

itmpatch -h <installation home>
-i { <patch_file_directory> | <patch_file> }

where:
-h Specifies the IBM Tivoli Monitoring installation directory
-i Specifies the path to the directory or patch file to be installed
-t Generates a report of the actions to be taken by the patch


For example, on UNIX systems:
- To preview the fix installation, use the "-t" option:
> <CANDLEHOME>/bin/itmpatch -h <CANDLEHOME> -t <TEMP>

- To install the fix, use the "-i" option:
> <CANDLEHOME>/bin/itmpatch -h <CANDLEHOME> -i <TEMP>

where:
<CANDLEHOME> is the fully qualified IBM Tivoli Monitoring
installation directory. On Windows systems, this path must include
the drive letter.
<TEMP> represents the fully qualified directory specification where
the fix is located. On Windows systems, this must include the drive
letter.

6.3 Verifying the update
----------------------------
1. To verify the agent was updated correctly, use the "tacmd" command
to view the agent's current version after the agent is restarted.
You are required to log in to a Tivoli Enterprise Monitoring
Server prior to viewing the agent version.

For example:
On UNIX systems, where $CANDLEHOME is the IBM Tivoli Monitoring
installation directory, the default location is '/opt/IBM/ITM'.

> $CANDLEHOME/bin/tacmd login -s <server>
-u <itmuser>
-p <password>
> $CANDLEHOME/bin/tacmd listSystems -t or

On Windows systems, where %CANDLE_HOME% is the IBM Tivoli
Monitoring installation directory, the default location
is 'C:\IBM\ITM'.

> %CANDLE_HOME%\bin\tacmd login -s <server>
-u <itmuser>
-p <password>
> %CANDLE_HOME%\bin\tacmd listSystems -t or

Note: The component (-t) for the "tacmd listSystems" command is
specified as two characters (or), not three characters (kor).

When the agent update is successful, the agent version is
06.21.00.07

After the agent is restarted, you can also use the GUI to verify
the agent was successfully updated.

For the agent on Windows systems, the version number is
06.21.00070.
For the agent on UNIX systems, the version number is
06.21.00007.

2. To verify the agent support files were updated correctly, use the
"kincinfo" command on Windows systems or the "cinfo" command on
Linux or UNIX systems. The sample output below shows the versions
of the Tivoli Enterprise Portal Server, Tivoli Enterprise
Monitoring Server, or Tivoli Enterprise Portal Desktop systems
after this fix has been successfully applied.

Note: The displayed date of the build might not be accurate. This
is a known problem.

On UNIX or Linux systems:
-------------------------
To validate that all components have been installed, run the
following command:

./cinfo -i

*********** Thu Sept 2 14:37:42 EDT 2012 *****************
User: root Groups: root bin daemon sys adm disk wheel
Host name : myaixsys Installer Lvl:06.21.00.00
CandleHome: /opt/IBM/ITM
***********************************************************
...Product inventory
.
.
.
Monitoring Agent for Oracle update:

dd Distributed Database common code
li6263 Version: 06.21.00.06

or Monitoring Agent for Oracle
li6263 Version: 06.21.00.07
.
.
.
Tivoli Enterprise Monitoring Server update:

or Monitoring Agent for Oracle
tms Version: 06.21.00.07
.
.
.

On Windows systems:
---------------------
To validate that all components have been installed, run the
following command:

For example:
> %CANDLE_HOME%\InstallITM\kincinfo -i

>kincinfo -i

kincinfo output:

**************** Thursday, June 2, 2011 4:09:02 PM **********
User : Administrator Group : NA
Host Name : TIVSUN18 Installer : Ver: 062100000
CandleHome : C:\IBM\ITM
Installitm : C:\IBM\ITM\InstallITM
*************************************************************
.
.
.
[ Tivoli Enterprise Monitoring Server |
Tivoli Enterprise Portal Server and Tivoli Enterprise Portal Desktop] update:
OR Oracle Support
WINNT Version: 06.21.00.07 Build:

Tivoli Enterprise Portal Server and Tivoli Enterprise Portal
Desktop update:
OR Oracle Support
WINNT Version: 06.21.00.07 Build:

OR Oracle Support
WINNT Version: 06.21.00.07 Build:


Monitoring Agent for Oracle update:
DD Distributed Database Common Code
WINNT Version: 06.21.00.06 Build:

OR Monitoring Agent for Oracle
WINNT Version: 06.21.00.07 Build:


Note:

- The date of the build that is displayed might not be accurate.
This problem is known and is being addressed.
- The kincinfo and cinfo command output examples in the sections
that follow show all components that can be updated. If you do
not have all of these components installed, then components not
installed are not displayed in the output of these commands.


7.0 Known problems and workarounds
==================================
- Problem: If you are installing this fix into a depot on a Windows
computer and WinZip is used to extract this fix, text
files in the depot might contain CTRL-Ms. When this fix is
remotely deployed to a UNIX computer from the IBM Tivoli
Enterprise Monitoring Server or depot on Windows, the
installation fails. The CTRL-Ms are caused by extracting
the fix using WinZip with the "TAR file smart CR/LF conversion"
option enabled. This extraction causes WinZip to put CTRL-Ms
in text files when they are extracted on UNIX through remote
deployment.

Workaround: If you are using WinZip for the fix installation for a
Tivoli Enterprise Monitoring Server on Windows, disable the
default "TAR file smart CR/LF conversion" option.

- Problem: If the Oracle agent is uninstalled after
applying this fix, the KOR and KDD files are removed, but
the KDDWICMA.ver file with patch version remains.
The presence of this KDD .ver file prohibits the Oracle
agent from being successfully installed again.

Workaround: Delete KDDWICMA.ver manually to allow any new KDD to be
installed.

- Problem: After remote deployment by the GUI, it is not clear that the
latest available fix has been installed.
The "Install Updates" button is displayed as enabled
and the text indicates that the latest patch level is not installed.

Workaround: No workaround is needed.

- Problem: For IY98181/IZ03843, after applying this fix, utmpx is still
in a corrupted state.

Workaround: You must nullify the /var/adm/utmpx file manually
to remove the corrupted information in the utmpx file.
Nullify the file only once.

cat /dev/null >/var/adm/utmpx

- Problem: In the Tivoli Enterprise Portal, the instance name is
displayed instead of the host name in the Navigation tree.

For example the Navigation tree might look like this:
MySid
Oracle
Alert Log
...
instead of this,
MyHost
Oracle - MySid
Alert Log
...

If the Navigation tree looks like the example, then the
problem is that the length of the managed
node name, <SID>:<HOSTNAME>:ORA, exceeds the length
supported by the portal. A possible cause is that the
fully qualified host name is being used. If 'uname -n'
on the Oracle agent computer returns a
fully qualified host name, then using the fully qualified
host name is the cause.

Workaround: Override the host name with an appropriate shorter name by
adding the following line to or.config:
export COLL_HOSTNAME=<short name>

- Problem: The Oracle agent receives an ORA-12546 error.
After installing Oracle 10gR2 (10.2.0.1) on Linux/PPC64,
the Oracle agent receives an ORA-12546
error. Also, the root user is unable to log in as any
Oracle user through sqlplus.

Workaround: This problem is caused by a UNIX file permissions error.

References:
SR 5721567.993
Bug 4516865 - Wrong permissions after install of 10gR2
(10.2.0.1)

Install Oracle Patch 4516865


This patch installs a script that relaxes file
permissions in $ORACLE_HOME to solve the problem. You must
first apply the patch using the opatch utility,
which is found at $ORACLE_HOME/OPatch/opatch. After the
patch is applied, you must run the
$ORACLE_HOME/install/changePerm.sh script. More details
are in the README included with the patch.

- Problem: Remote commands are not available on HP-UX 11i V2 on
Integrity. Remote deploy, configure, start, stop, remove,
and restart are not available on HP-UX 11i V2 on Integrity.

Workaround: None.

8.0 Additional product information
==================================
This fix provides a mechanism to make the changes listed in APAR
IY92195 ORACLE AGENT PROCESS USES A HUGE AMOUNT OF MEMORY and defect
132576 CANNOT DISABLE INTERVAL CURSORS IN CONFIG FILE. The
default is that the changes are NOT made. Contact Level 2 support for
further information and recommendations for making these changes
after reading the following detailed information.

Note: If you have changes that were made by Level 2 or Level 3 support
using a modified korcoll.ctl file, this fix resets those changes.
The changes must be made again using the mechanism discussed in
the following paragraphs. Do not merge any previously customized
korcoll.ctl file with this korcoll.ctl file. The method
provided below makes that merge unnecessary.

The cursors that are listed below take longer to return data and
consume excessive system resources in some environments. A cursor is
a mechanism by which a name is assigned to a select statement so that
the SQL statement can be manipulated dynamically. Various SQL changes
have been made to enhance the performance of the data gathering cursor
operations within the agent. You can validate the standard of
performance by running the SQL listed below for each cursor in SQL*Plus
by logging into the Oracle Server with the
Oracle agent database ID.

These changes include nine SQL modifications that can be disabled in
the agent using a new "Extended Parameters" field provided at agent
configuration time. The following values can be assigned in this new
field:

DB3,DB6,TS5,KORSESSB,KORSESSO,KORSESSX

Each comma-delimited, no-white-space value represents a change to the
SQL cursor that is executed during data gathering operations within
the agent. The values are the SQL cursor name. For example, setting
the "Extended Parameters" field to DB3,TS1 means that the DB3 and TS1
SQL cursor is disabled for "Set FREEBYTES to zero", 'Set TSNEXTS to
zero', and 'Set MAXEXTTS to zero'. The SQL cursor name is case
insensitive.

The cursors that are listed below take SQL statements to return data
by interval time by self.

TS2,KORLOCKS,KORPROCS,KORCACHE,KORCACHX,KORSESSS,KORSTASX

Each comma-delimited, no-white-space value represents a change to the
SQL cursor that is executed during data gathering operations within
the agent. The values are the SQL cursor name.

For example, setting the "Extended Parameters" field to TS2
means that the TS2 SQL cursor is disabled for
"Set FREEBYTES to zero", 'Set TSNFILES to zero',
and 'Set RAWTSSIZE to zero'. Setting the "Extended Parameters" field
to KORLOCKS means that the KORLOCKS SQL cursor is disabled for the
'Oracle_Contention_Summary' attribute group.

The "Extended Parameters" values are saved in the following locations
by operating system:

UNIX file: $CANDLEHOME/config/{hostname}_or_{instance name}.cfg
UNIX variable: db_extparms

Windows Registry Entry: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\
Candle\KOR\610\{Oracle instance name}\
Environment\COLL_DISABLE_CURSORS

The new "Extended Parameters" field has been added to the following
configuration operations:

- Remote Deployment - A new GUI field labeled "Extended Parameters" and
a new db_extparms flag on the "tacmd" command. See Section 5.3.
- UNIX remote configuration - CandleManage prompts for a new
"Extended Parameters" field during manual configuration. See
Section 5.3.
- UNIX local configuration - The itmcmd config command (or
CandleConfig) prompts for a new "Extended Parameters" field
during manual configuration.
- Windows Tivoli Enterprise Monitoring Services - "Configure Using
Defaults" has a new "Extended Parameters" field
on the Oracle agent template.

The Oracle agent must be restarted to recognize these
changes to the "Extended Parameters" value.

In the following paragraphs, each SQL cursor is described in detail.
Using the name of the SQL cursor, look in the korcoll.ctl file
for the SQL modification that is made when the SQL cursor is disabled.
The korcoll.ctl file is located in $CANDLEHOME/misc on UNIX systems and
%CANDLE_HOME%\TMAIMT6 for Windows.

When these cursors are disabled, the Oracle agent
displays the default attribute values of these cursors in the Tivoli
Enterprise Portal, meaning that the Oracle agent no longer
monitors the attributes of the disabled cursors. For each cursor,
the workspace and column names that are affected are listed:

SQL cursor: DB3 - ARCHIVE LOG DISPLAY
SQL:
SELECT TABLESPACE_NAME UTSNAME,
SUM(BYTES) FREEBYTES
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME;

Disabled: Set FREEBYTES to zero

Navigation Tree: Databases->Database Summary
Workspace: Oracle_Database/Database Summary->Database Summary
(Bar Chart View)
Oracle_Database/Database Summary->Database Summary
(Table View)
Column : DB Percent Free Space = 0
System TS Percent Free = 0

Navigation Tree : Databases->Enterprise Database Summary
Workspace: Oracle_Statistics_Enterprise/Databases Global->
Database Summary(Bar Chart View)

Oracle_Statistics_Enterprise/Databases Global->
Database Summary(Table View)

Column : System TS Percent Free = 0

Situation: Oracle_DB_PctFree_Space_Low = always true
Oracle_SystemTS_PctFree_Critica = always true
Oracle_SystemTS_PctFree_Warning = always false

--------------------------------------------------------------------

SQL cursor: DB6 - ARCHIVE LOG DISPLAY
SQL:
SELECT /*+RULE*/ COUNT(*) EXTENTS
FROM SYS.DBA_EXTENTS;

Disabled: Set EXTENTS to zero

Navigation Tree : Databases->Database Summary
Workspace: Oracle_Database/Database Summary->Database Summary
(Table View)
Column : Total Extents = 0

Situation : None

--------------------------------------------------------------------

SQL cursor TS5 - TOTAL TEMP SEGMENTS
SQL:
SELECT TS.TABLESPACE_NAME UTSNAME,
COUNT(FREE.BLOCKS) TSNFREEB,
MAX(FREE.BLOCKS) MAXBLOCK,
SUM(FREE.BYTES) SUMBYTES,
MAX(FREE.BYTES) MAXBYTES,
(ROUND(SQRT(MAX(FREE.blocks)/SUM(FREE.blocks))*
(100/SQRT(SQRT(COUNT(FREE.blocks)))),2))*100 TSFSFRAG
FROM SYS.DBA_TABLESPACES TS,
SYS.DBA_FREE_SPACE FREE
WHERE TS.TABLESPACE_NAME = FREE.TABLESPACE_NAME
GROUP BY TS.TABLESPACE_NAME
UNION
SELECT FREE.TABLESPACE_NAME UTSNAME,
COUNT(FREE.BLOCKS) TSNFREEB,
MAX(FREE.BLOCKS) MAXBLOCK,
SUM(FREE.BYTES) SUMBYTES,
MAX(FREE.BYTES) MAXBYTES,
(ROUND(SQRT(MAX(FREE.blocks)/SUM(FREE.blocks))*
(100/SQRT(SQRT(COUNT(FREE.blocks)))),2))*100 TSFSFRAG
FROM V$TEMP_EXTENT_MAP FREE
GROUP BY FREE.TABLESPACE_NAME;

Disabled: Set TSNFREEB to zero
Set MAXBLOCK to zero
Set SUMBYTES to zero
Set MAXBYTES to zero
Set TSFSFRAG to zero

Navigation Tree : Databases->Database Summary
Workspace: Oracle_Tablespaces/Database Summary->Tablespace
(Bar Chart View)
Column : For all Tablespace Names,
Pct Free Space = 0.00
Workspace: Oracle_Tablespaces/Database Summary->Tablespace
(Table View)
Column : Number Free Blocks = 0
Free Space Fragmentation = 0
Largest Free Block(KB) = 0
Largest Pct Free = 0.00
Pct Free Space = 0.00

Situation: Oracle_Free_Space_Frag_Crit = always true
Oracle_Free_Space_Frag_Warn = always false

--------------------------------------------------------------------

SQL cursor KORSESSB - V$ACCESS COUNT
SQL:
SELECT /*+RULE */
v1.sid SID,
count(v2.owner) ACCOBJECTS
FROM v$session v1, v$access v2
WHERE v1.sid = v2.sid(+)
AND v2.owner(+) NOT IN ('SYS','SYSTEM','PUBLIC')
GROUP BY v1.sid;

Disabled : Set ACCOBJECTS to zero

Navigation Tree : None
Workspace: None
Attribute Group/Attribute: Oracle_Session_Detail / Access_Objects
Situation : None

--------------------------------------------------------------------

SQL cursor KORSESSO - V$OPEN_CURSOR COUNT
SQL:
SELECT count(*) TOTOPENCUR,
s.sid SID
FROM v$open_cursor o, v$session s
WHERE s.sid = o.sid(+)
GROUP BY s.sid;

Disabled : Set TOTOPENCUR to zero

Navigation Tree : None
Workspace: None
Attribute Group/Attribute: Oracle_Session_Detail / Total_Open_Cursors
Situation : None

--------------------------------------------------------------------

SQL cursor KORSESSX - V$OPEN_CURSOR COUNT
SQL:
SELECT sess.PADDR PADDR,
COUNT(op.HASH_VALUE) OPENCURS
FROM v$open_cursor op,
v$session sess
WHERE sess.SADDR = op.SADDR(+)
GROUP BY sess.PADDR;

Disabled : Set OPENCURS to zero

Navigation Tree : Session->Session Summary
Workspace: Session Summary / Session Detail (Table View)/Open Cursors
(Column)
Attribute Group/Attribute: Oracle_Session_Detail / Open_Cursors
Situation : None

--------------------------------------------------------------------

SQL cursor TS2 - COUNT TOTAL FILES (TSNFILES) - TOTAL BYTES IN KB (TSSIZE)
SQL:
select tablespace_name UTSNAME,
count(*) TSNFILES,
sum(bytes) RAWTSSIZE
from v$datafile_header
group by tablespace_name
union all
select ts.name UTSNAME,
count(tf.FILE#) TSNFILES,
sum(tf.BYTES) RAWTSSIZE
from v$tempfile tf, sys.ts$ ts
where tf.TS# = ts.ts#
group by ts.name;

Disabled : Set TSNFILES to zero
Set RAWTSSIZE to zero

Navigation Tree : Databases->Database Summary

Workspace: Oracle_Tablespaces/Database Summary->Tablespace
(Bar Chart View)
Column : For all Tablespace Names,
Pct Free Space = 0.00

Workspace: Oracle_Tablespaces/Database Summary->Tablespace
(Table View)
Column : Total Size = 0
Pct Free Space = 0.00
Total Files = 0
Largest Pct Free = 0.00

Situation : Oracle_Free_Tbsp_Crit
Oracle_Free_Tbsp_Warn

--------------------------------------------------------------------

SQL cursor KORLOCKS - GET V$LOCK

pre_cursor KORLOCK1 SQL:
SELECT count(*) TOTSESSD
FROM V$SESSION;

pre_cursor KORLOCK2 SQL:
SELECT count(*) TDMLLCKS
FROM V$LOCK
WHERE type = 'TM';

pre_cursor KORLOCK3 SQL:
SELECT count(TYPE) BLOCKERS
FROM V$LOCK
WHERE block != 0;

pre_cursor KORLOCK4 SQL:
SELECT count(TYPE) WAITERS
FROM V$SESSION
WHERE LOCKWAIT IS NOT NULL;

pre_cursor KORLCON2 SQL:
select s1.ROW_WAIT_OBJ# LOBJID1,
o.name BOBJNAME,
o.type# BOBJTYPE,
lo.SESSION_ID BLOCKSID,
lo.ORACLE_USERNAME UBLOCKUID,
el.SID WAITSID,
s1.USERNAME UWAITUID,
el.REQUEST HOLDMODE,
el.REQUEST REQUMODE,
el.ID2 LOBJID2
from v$enqueue_lock el, v$locked_object lo, v$session s1, sys.obj$ o
where el.type = 'TX'
and el.SID = s1.SID
and s1.ROW_WAIT_OBJ# = o.obj#
and s1.ROW_WAIT_OBJ# = lo.OBJECT_ID
and lo.XIDUSN > 0;

pre_cursor KORLCK05 SQL:
SELECT (max(decode(name, 'consistent gets', value, 0)) -
max(decode(name, 'global lock async converts', value, 0))) /
max(decode(name, 'consistent gets', value, 0)) LOCKHITRAT
FROM v$sysstat
WHERE name in ('consistent gets', 'global lock async converts');(VERSION<10)

SELECT (max(decode(name, 'consistent gets', value, 0)) -
max(decode(name, 'global enqueue gets async', value, 0))) /
max(decode(name, 'consistent gets', value, 0)) LOCKHITRAT
FROM v$sysstat
WHERE name in ('consistent gets', 'global enqueue gets async');(VERSION>=10)

pre_cursor KORLONEW SQL:
select count(decode(type, 'RW', 1)) RWLOCKS,
count(decode(type, 'TX', 1)) TRANLOCKS,
count(decode(type, 'UL', 1)) USUPLOCKS,
count(decode(type, 'BL', 1)) BUFLOCKS,
count(decode(type, 'CF', 1)) CIFLOCKS,
count(decode(type, 'CI', 1)) CILOCKS,
count(decode(type, 'CS', 1)) CSLOCKS,
count(decode(type, 'DF', 1)) DATALOCKS,
count(decode(type, 'DM', 1)) MSLOCKS,
count(decode(type, 'DR', 1)) DRLOCKS,
count(decode(type, 'DX', 1)) DXLOCKS,
count(decode(type, 'FI', 1)) SGALOCKS,
count(decode(type, 'FS', 1)) FILELOCKS,
count(decode(type, 'IR', 1)) INSTLOCKS,
count(decode(type, 'IV', 1)) LIBLOCKS,
count(decode(type, 'LS', 1)) LOGLOCKS,
count(decode(type, 'MB', 1)) MASTLOCKS,
count(decode(type, 'MM', 1)) MNTLOCKS,
count(decode(type, 'MR', 1)) MRLOCKS,
count(decode(type, 'RE', 1)) RELOCKS,
count(decode(type, 'RT', 1)) REDOLOCKS,
count(decode(type, 'SC', 1)) SCLOCKS,
count(decode(type, 'SH', 1)) SHLOCKS,
count(decode(type, 'SN', 1)) SNLOCKS,
count(decode(type, 'SQ', 1)) SQLOCKS,
count(decode(type, 'ST', 1)) SPCLOCKS,
count(decode(type, 'SV', 1)) SVLOCKS,
count(decode(type, 'TA', 1)) GENLOCKS,
count(decode(type, 'TD', 1)) DLLLOCKS,
count(decode(type, 'TE', 1)) TELOCKS,
count(decode(type, 'TS', 1)) TSLOCKS,
count(decode(type, 'TT', 1)) TTLOCKS,
count(decode(type, 'UN', 1)) USRLOCKS,
count(decode(type, 'WL', 1)) WLLOCKS,
count(decode(type, 'WS', 1)) WSLOCKS
from v$lock;

Disabled: Oracle_Contention_Summary

Navigation Tree: Contention->Contention Summary

Workspace: Oracle_Contention_Summary/Contention Summary->Lock Analysis
(Bar Chart View)
Workspace: Oracle_Contention_Summary/Contention Summary->Lock Conflict
(Table View)
Situation: Oracle_Pct_MAX_DML_Locks_Critic
Oracle_Pct_MAX_DML_Lock_Warning
Oracle_Largest_Waiters_Critical
Oracle_Largest_Waiters_Warning

--------------------------------------------------------------------

SQL cursor KORPROCS - GET TOTAL PROCESSES INFORMATION

pre_cursor KORPROC1 SQL:
SELECT VP.ADDR PADDR,
VP.PID PID,
DECODE(VP.SPID,NULL,'0 ',VP.SPID) SPID,
VP.USERNAME UUSERNAME,
VP.TERMINAL TERMINAL,
VB.NAME PROGRAM,
decode(VP.BACKGROUND,1, 'Yes', 'No ') ORASYSPR,
VP.BACKGROUND||' ' TYPE,
VP.LATCHWAIT LATCHWAIT,
VP.LATCHWAIT LATCHADDR,
VP.SERIAL# SERIALNO,
VB.description PRDESC,
substr(VP.ADDR,-8,8) PADDR8
FROM V$PROCESS VP,
V$BGPROCESS VB
WHERE VB.PADDR(+)=VP.ADDR;

pre_cursor KORSHSPC SQL:
SELECT ROUND((COUNT(ss.name)/ GREATEST(pa.value,1))*100,2) SHSVRPR,
pa.value SHSVRMAX
FROM v$parameter pa,
v$shared_server ss
WHERE pa.name = 'max_shared_servers'
GROUP BY pa.value;(VERSION>9)

SELECT ROUND((COUNT(ss.name)/ GREATEST(pa.value,1))*100,2) SHSVRPR,
pa.value SHSVRMAX
FROM v$parameter pa,
v$shared_server ss
WHERE pa.name = 'mts_max_servers'
GROUP BY pa.value;(VERSION<=9)

pre_cursor KORSHSWT SQL:
SELECT ROUND(wait/GREATEST(totalq,1),2) SHSVRWAIT
FROM v$queue
WHERE type = 'COMMON';

Disabled: Oracle_Process_Summary

Navigation Tree : Process->Process Summary

Workspace: Oracle_Process_Summary/Process Summary->Processes
(Bar Chart View)
Workspace: Oracle_Process_Summary/Process Summary->Process Detail
(Table View)
Situation: Oracle_ARCH_Active_Warning
Oracle_CKPT_Active_Warning
Oracle_LGWR_Active_Critical
Oracle_PctMax_Processes_Critica
Oracle_PctMax_Processes_Warning
Oracle_PMON_Active_Critical
Oracle_Processes_Crit
Oracle_Processes_Wait_Latch
Oracle_Processes_Warn
Oracle_SMON_Active_Critical
Oracle_Total_System_Process_CPU
Oracle_Total_Applctn_Proces_CPU

--------------------------------------------------------------------

SQL cursor KORCACHE - Oracle Cache Summary
SQL cursor KORCACHX - Oracle Cache Summary 64bit

pre_cursor LIBCU1 SQL:
SELECT SUM(PINS) TOTPINS,
SUM(PINS) - SUM(RELOADS) TOTPINHITS,
SUM(RELOADS) TOTRELOADS
FROM V$LIBRARYCACHE;(VERSION=8)

SELECT SUM(PINS) TOTPINS,
SUM(PINHITS) TOTPINHITS,
SUM(RELOADS) TOTRELOADS
FROM V$LIBRARYCACHE;(VERSION!=8)

pre_cursor KORLIBCU SQL:
SELECT NAMESPACE UNAMESP,
GETS GETREQ,
GETHITS GETHIT,
GETHITRATIO * 10000 GETHP,
PINS PINS,
PINHITS EXHITS,
PINHITRATIO * 10000 EXHITP,
RELOADS RELOADS,
INVALIDATIONS INVALID
FROM V$LIBRARYCACHE;

pre_cursor CACHE2 SQL:
SELECT COUNT TCACHEE,
USAGE TOTVALC,
FIXED TOTFIXED,
GETS TGET,
GETMISSES TGETMISS,
SCANS TSCANREQ,
SCANMISSES TSCANMISS,
SCANCOMPLETES TSCANC,
MODIFICATIONS TMODS,
FLUSHES TFLUSH
FROM V$ROWCACHE;

pre_cursor CACHE3 SQL:
SELECT GETS WTWGETS,
MISSES WTWMISS,
IMMEDIATE_GETS IMMGETS,
IMMEDIATE_MISSES IMMMISS
FROM V$LATCH;

pre_cursor CACHE4 SQL:
select sum(decode( name, 'consistent gets', value,0)) BUFCGETS,
sum( decode( name, 'db block gets', value, 0)) BUFDBGETS,
sum( decode( name, 'physical reads direct', value, 0)) BUFCPHRD,
sum( decode( name, 'physical reads direct (lob)', value, 0)) BUFCPHRDL,
sum( decode( name, 'session logical reads', value, 0)) BUFCSESSLR
FROM V$SYSSTAT ;

pre_cursor CACHE5 SQL:
SELECT physical_reads KEEPPHYRD,
db_block_gets KEEPDBGETS,
consistent_gets KEEPCGETS,
((1 - (physical_reads / greatest(1, db_block_gets + consistent_gets))) * 100) KEEPHITP
FROM V$BUFFER_POOL_STATISTICS
WHERE name = 'KEEP';

pre_cursor CACHE6 SQL:
SELECT physical_reads RCLPHYRD,
db_block_gets RCLDBGETS,
consistent_gets RCLCGETS,
((1 - (physical_reads / greatest(1, db_block_gets + consistent_gets))) * 100) RCLHITP
FROM V$BUFFER_POOL_STATISTICS
WHERE name = 'RECYCLE';

Disabled: Oracle_Cache_Totals

Navigation Tree: Cache Totals->Cache Totals Summary

Workspace: Oracle_Cache_Totals/Cache Totals Summary->Cache Totals Summary
(Bar Chart View)
Workspace: Oracle_Cache_Totals/Cache Totals Summary->Cache Totals Summary
(Table View)
Situation : Oracle_Dictionary_Cache_Hit_Cri
Oracle_Dictionary_Cache_Hit_War
Oracle_Library_Reloads_Pct_Crit
Oracle_Library_Reloads_Pct_Warn
Oracle_Redo_Immediate_Warning
Oracle_Redo_Miss_Warning

--------------------------------------------------------------------

SQL cursor KORSESSS - TOTAL SESSIONS - SESSCURR

pre_cursor KORSESSA SQL:
select s.sid,
TO_CHAR(S.LOGON_TIME, 'YYYYMMDDHH24MISS') LOGONTIME,
nvl2(s.LOCKWAIT,sw.SECONDS_IN_WAIT,0) LOCKWAITT
from v$session s,
v$session_wait sw
where s.SID=sw.SID(+);

pre_cursor KORSESSB SQL:
SELECT v1.sid SID,
count(v2.owner) ACCOBJECTS
FROM v$session v1,
v$access v2
WHERE v1.sid = v2.sid(+)
AND v2.owner(+) NOT IN ('SYS','SYSTEM','PUBLIC')
GROUP BY v1.sid;

pre_cursor KORSESSC SQL:
select value MAXCURSORS
from v$parameter
where name ='open_cursors';

pre_cursor KORSESSO SQL:
SELECT count(*) TOTOPENCUR,
s.sid SID
FROM v$open_cursor o, v$session s
WHERE s.sid = o.sid(+)
GROUP BY s.sid;

pre_cursor KORSESSP SQL:
SELECT sw.seconds_in_wait LOCKCONVW,
s.sid SID
FROM v$session_wait sw,
v$session s
WHERE sw.event = 'lock element cleanup'
AND sw.sid = s.sid
AND sw.state = 'WAITING';

pre_cursor KORSESSR SQL:
SELECT ((SYSDATE - TO_DATE(T.START_TIME, 'MM/DD/RR HH24:MI:SS')) * 24 * 60 * 60) RUNTIME,
S.SID SID
FROM V$SESSION S, V$TRANSACTION T
WHERE S.TADDR = T.ADDR
ORDER BY S.SID;

pre_cursor KORSESSW SQL:
select sessions_warning SESSWARNL
from v$license;

pre_cursor KORSESSX SQL:
SELECT sess.PADDR PADDR,
COUNT(op.HASH_VALUE) OPENCURS
from v$open_cursor op,
v$session sess
where sess.SADDR = op.SADDR(+)
group by sess.PADDR;

pre_cursor KORSESSD SQL:
SELECT
SESS.SID SID,
SESS.SERIAL# SERALNO,
SESS.SERVER SERVER,
SESS.USERNAME USESSUSER,
SESS.OSUSER UOSUSER,
SESS.PROCESS PROCESS,
SESS.MACHINE MACHINE,
SESS.TERMINAL TERMINAL,
SESS.PROGRAM PROGRAM,
PROC.PROGRAM PROGRAM2,
SESS.TYPE SESSTYPE,
SESS.SCHEMA# SCHEMANO,
SESS.SCHEMANAME USCHEMANAM,
SESS.PADDR PADDR,
substr(SESS.PADDR,-8,8) PADDR8,
SESS.LOCKWAIT LOCKWAIT,
SESS.LOCKWAIT WAITADDR,
SESS.STATUS SESSTAT,
SESS.SQL_ADDRESS SQLADDR,
SESS.SQL_HASH_VALUE SQLHASHV,
SESSIO.BLOCK_GETS BLOCKGETS,
SESSIO.CONSISTENT_GETS CONSTGETS,
SESSIO.PHYSICAL_READS PHYSREADS,
nvl(((SESSIO.BLOCK_GETS+SESSIO.CONSISTENT_GETS)/decode(SESSIO.BLOCK_GETS+SESSIO.CONSISTENT_GETS+SESSIO.PHYSICAL_READS,0,1,
SESSIO.BLOCK_GETS+SESSIO.CONSISTENT_GETS+SESSIO.PHYSICAL_READS)*10000),0) SESSHITPER,
SESSIO.BLOCK_CHANGES BLKCHGS,
SESSIO.CONSISTENT_CHANGES CONSCHNGS,
SESSW.WAIT_TIME||'00' CURRENTW,
SESSW.EVENT UCURWEVENT,
SESS.COMMAND COMMAND
FROM V$SESSION SESS,
V$SESS_IO SESSIO,
v$SESSION_WAIT SESSW,
V$PROCESS PROC
WHERE SESS.SID = SESSIO.SID
AND SESS.SID = SESSW.SID
AND SESS.PADDR = PROC.ADDR;

Disabled: Oracle_Session_Summary

Navigation Tree: Sessions->Session Summary

Workspace: Oracle_Session_Summary/Session Summary->Session Summary
(Bar Chart View)
Workspace: Oracle_Session_Summary/Session Summary->Session Summary
(Table View)
Situation: Oracle_PctMax_Sessions_Critical
Oracle_PctMax_Sessions_Warning
Oracle_Total_Sessions_Killed

--------------------------------------------------------------------

SQL cursor KORSTASX - Statistics Summary

pre_cursor SRVRTIME SQL:
SELECT (SYSDATE - OPEN_TIME) * 24 * 60 LIFE
FROM V$THREAD
WHERE THREAD# = 1;

pre_cursor FREELW SQL:
SELECT count FREELISTC
FROM v$waitstat
WHERE class = 'free list';

pre_cursor CONTROW SQL:
SELECT round((TFCRow.value / (TFBRowid.value + TSRGotten.value)*10000),0) PCTCONTROW
FROM v$sysstat TFCRow,
v$sysstat TFBRowid,
v$sysstat TSRGotten
WHERE TFCRow.name = 'table fetch continued row' AND
TFBRowid.name = 'table fetch by rowid' AND
TSRGotten.name = 'table scan rows gotten';

pre_cursor REDOLOG SQL:
SELECT count(*) REDOLOGN
FROM v$log a,
v$thread b
WHERE a.thread# = b.thread# AND
a.archived = 'NO';

pre_cursor BACKDEST SQL:
SELECT DECODE(SUBSTR(DEST.VALUE,1,1),
'?',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'/'),INSTR(DEST.VALUE,'/',-1,1) - INSTR(DEST.VALUE,'/',1)),
'%',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'\'),INSTR(DEST.VALUE,'\',-1,1) - INSTR(DEST.VALUE,'\',1)),
DEST.VALUE) FILESYSNM
FROM V$PARAMETER DEST
WHERE DEST.NAME = 'background_dump_dest';

pre_cursor COREDEST SQL:
SELECT DECODE(SUBSTR(DEST.VALUE,1,1),
'?',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'/'),INSTR(DEST.VALUE,'/',-1,1) - INSTR(DEST.VALUE,'/',1)),
'%',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'\'),INSTR(DEST.VALUE,'\',-1,1) - INSTR(DEST.VALUE,'\',1)),
DEST.VALUE) FILESYSNM
FROM V$PARAMETER DEST
WHERE DEST.NAME = 'core_dump_dest';

pre_cursor USERDEST SQL:
SELECT DECODE(SUBSTR(DEST.VALUE,1,1),
'?',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'/'),INSTR(DEST.VALUE,'/',-1,1) - INSTR(DEST.VALUE,'/',1)),
'%',[KORV.ORAHOME || SUBSTR(DEST.VALUE,INSTR(DEST.VALUE,'\'),INSTR(DEST.VALUE,'\',-1,1) - INSTR(DEST.VALUE,'\',1)),
DEST.VALUE) FILESYSNM
FROM V$PARAMETER DEST
WHERE DEST.NAME = 'user_dump_dest';

pre_cursor STATLTRN SQL:
select max(ctime) BLKTRANS
from v$enqueue_lock
where type='TX'
and lmode=0
and request=6;

pre_cursor STATATRN SQL:
SELECT ROUND((COUNT(vt.addr)/GREATEST(vp.value,1))*100,2) ACTTRAN
FROM v$transaction vt,
v$parameter vp
WHERE vp.name = 'transactions'
GROUP BY vp.value;

pre_cursor STATBCPT SQL:
SELECT ROUND((BChanges.value/Ucalls.value),2) BLKCHPERTR
FROM v$sysstat BChanges, v$sysstat UCalls
WHERE BChanges.name = 'db block changes'
AND UCalls.name = 'user calls';

pre_cursor STATREDO SQL:
SELECT ROUND((RSize.value/GREATEST(REntries.value,1)),2) AVGREDOSZ
FROM v$sysstat RSize, v$sysstat REntries
WHERE RSize.name = 'redo size'
AND REntries.name = 'redo entries';

pre_cursor STATCALL SQL:
SELECT (RCalls.value + UCalls.value) CALLRATE
FROM v$sysstat RCalls, v$sysstat UCalls
WHERE RCalls.name = 'recursive calls'
AND UCalls.name = 'user calls';

pre_cursor STATCRPT SQL:
SELECT ROUND((UCalls.value/GREATEST(UCommits.value,1)),2) AVGCRPERTR
FROM v$sysstat UCalls, v$sysstat UCommits
WHERE UCalls.name = 'user calls'
AND UCommits.name = 'user commits';

pre_cursor STATRUCR SQL:
SELECT ROUND(RCalls.value/UCalls.value,2) RECUSR
FROM v$sysstat RCalls, v$sysstat UCalls
WHERE RCalls.name = 'recursive calls'
AND UCalls.name = 'user calls';

pre_cursor STATBRAT SQL:
SELECT ROUND((BChanges.value/(BGets.value+CGets.value))*100,2) CHBLK
FROM v$sysstat BChanges,
v$sysstat BGets,
v$sysstat CGets
WHERE BChanges.name = 'db block changes'
AND BGets.name = 'db block gets'
AND CGets.name = 'consistent gets';

pre_cursor STATCKTP SQL:
SELECT value CMPLBGCKPT
FROM v$sysstat
WHERE name = 'background checkpoints completed';

pre_cursor STATDBWR SQL:
SELECT value DBWRCKPTRQ
FROM v$sysstat
WHERE name = 'DBWR checkpoints';

pre_cursor STATKRAT SQL:
SELECT ROUND((CGets.value / CScans.value),2) CLKEY
FROM v$sysstat CGets,
v$sysstat CScans
WHERE CGets.name = 'cluster key scan block gets'
AND CScans.name = 'cluster key scans';

pre_cursor STATCRAT SQL:
SELECT ROUND((CChanges.value/CGets.value)*100,2) CONCH
FROM v$sysstat CChanges,
v$sysstat CGets
WHERE CChanges.name = 'consistent changes'
AND CGets.name = 'consistent gets';

pre_cursor STATFTSX SQL:
select ROUND(((LongScans.value - to_number([KORV.LTSCNX ) )/
decode(((LongScans.value - to_number([KORV.LTSCNX))+(ShortScans.value - to_number([KORV.STSCNX))),0,1
,((LongScans.value - to_number([KORV.LTSCNX))+(ShortScans.value - to_number([KORV.STSCNX)))))*100,2) LTFTSCNX,
nvl(LongScans.value,0) LTSCNX,
nvl(ShortScans.value,0) STSCNX
from v$sysstat LongScans,
v$sysstat ShortScans
where LongScans.name = 'table scans (long tables)'
and ShortScans.name = 'table scans (short tables)';

pre_cursor STATDLCK SQL:
SELECT value DEADLOCKS
FROM v$sysstat
WHERE name = 'enqueue deadlocks';

pre_cursor STATROWR SQL:
SELECT ROUND((TSRGotten.value /GREATEST((TFBRowid.value+TSRGotten.value),1))*100,2) ROWSRC
FROM v$sysstat TSRGotten,
v$sysstat TFBRowid
WHERE TSRGotten.name = 'table scan rows gotten'
AND TFBRowid.name = 'table fetch by rowid';

pre_cursor STATWRAT SQL:
SELECT round(nvl(a.average_wait, 0) /
(SELECT nvl(SUM(VALUE), 1)
FROM v$sysstat
WHERE name IN ('consistent gets', 'db block gets')) * 100,
2) DATAWT
FROM v$system_event a
WHERE a.event = 'buffer busy waits';

pre_cursor STATRLAT SQL:
SELECT ROUND(misses/GREATEST(gets,1)*100,2) REDOAL
FROM v$latch
WHERE name = 'redo allocation';

pre_cursor STATCLAT SQL:
SELECT (ROUND(misses/GREATEST(gets,1)*100,2) +
ROUND(immediate_misses/GREATEST(immediate_gets,1)*100,2)) REDOCL
FROM v$latch
WHERE name = 'redo copy';

pre_cursor STATSLAT SQL:
SELECT ROUND((REntries.value/GREATEST(SCopies.value,1))*100,2) REDOSC
FROM v$sysstat REntries,
v$sysstat SCopies
WHERE REntries.name = 'redo entries linearized'
AND SCopies.name = 'redo small copies';

pre_cursor STATPNGF SQL:
SELECT (((a.value/(b.counter + c.counter + d.counter)) - 1) /
(a.value/(b.counter+ c.counter + d.counter)))*100,
a.value/(b.counter + c.counter + d.counter),
((a.value/(b.counter + c.counter + d.counter)) - 1) FALSEPIP
FROM v$sysstat a,
v$lock_activity b,
v$lock_activity c,
v$lock_activity d
WHERE b.from_val = 'X'
AND b.to_val = 'NULL'
AND c.from_val = 'X'
AND c.to_val = 'S'
AND d.from_val = 'X'
AND d.to_val = 'SSX'
AND a.name = 'DBWR cross instance writes';

pre_cursor STATPNGR SQL:
SELECT a.value/(b.counter + c.counter + d.counter) PINGRATE
FROM v$sysstat a,
v$lock_activity b,
v$lock_activity c,
v$lock_activity d
WHERE b.from_val = 'X'
AND b.to_val = 'NULL'
AND c.from_val = 'X'
AND c.to_val = 'S'
AND d.from_val = 'X'
AND a.name = 'DBWR cross instance writes';

pre_cursor STATSORT SQL:
SELECT ROUND(SDisk.value/GREATEST((Smemory.value+SDisk.value),1),4) SRTOVFLRAT
FROM v$sysstat SDisk,
v$sysstat Smemory
WHERE SDisk.name = 'sorts (disk)'
AND Smemory.name = 'sorts (memory)';

pre_cursor STATPGF SQL:
SELECT value FALSEPI
FROM v$sysstat
WHERE name = 'DBWR cross instance writes';

pre_cursor STATRCUR SQL:
SELECT value CURRECCALL
FROM v$sysstat
WHERE name = 'recursive calls';

pre_cursor STATCRT SQL:
SELECT TO_CHAR(created,'YYYYMMDDHH24MISS') DBCREATE
FROM v$database;

pre_cursor STATBGR SQL:
SELECT ROUND((BGets.value + CGets.value) / ((sysdate - startup_time) * 86400),2) BLOCKGET,
BGets.value DBBLOCKGCT,
CGets.value CONSISTGCT
FROM v$sysstat BGets, v$sysstat CGets, v$instance
WHERE BGets.name = 'db block gets'
AND CGets.name = 'consistent gets';

pre_cursor STATPGAC SQL:
SELECT 0 PGACOMPA
FROM v$instance;(VERSION=8)

SELECT to_number(decode(PGA3.value, 0, -1, PGA1.value - PGA2.value)) PGACOMPA
FROM v$pgastat PGA3, v$pgastat PGA1, v$pgastat PGA2
WHERE PGA3.name = 'aggregate PGA target parameter'
AND PGA1.name = 'total PGA allocated'
AND PGA2.name = 'total PGA used for auto workareas';(VERSION!=8)

pre_cursor STATPGAM SQL:
SELECT (count(*) - count(*)) PGAMPEXE
FROM v$instance;(VERSION=8)

SELECT cnt PGAMPEXE
FROM (SELECT name, value cnt, (sum(value) over()) total
FROM v$sysstat
WHERE name = 'workarea executions - multipass');(VERSION!=8)

pre_cursor STATPGAO SQL:
SELECT SUM(CASE WHEN name LIKE 'workarea executions - optimal' THEN value ELSE 0 end * 100)
/ decode(SUM(CASE WHEN name like 'workarea executions - optimal' THEN value ELSE 0 end)
+ SUM(CASE WHEN name LIKE 'workarea executions - onepass' THEN value ELSE 0 end)
+ SUM(CASE WHEN name LIKE 'workarea executions - multipass' THEN value ELSE 0 end), 0, 1,
SUM(CASE WHEN name like 'workarea executions - optimal' THEN value ELSE 0 end)
+ SUM(CASE WHEN name LIKE 'workarea executions - onepass' THEN value ELSE 0 end)
+ SUM(CASE WHEN name LIKE 'workarea executions - multipass' THEN value ELSE 0 end))*100 PGAOPTP
FROM v$sysstat
WHERE name LIKE 'workarea executions - %';

pre_cursor STATPGAS SQL:
SELECT 0 PGAWAMAX
FROM v$sysstat
WHERE name ='session pga memory';(VERSION=8)

SELECT value PGAWAMAX
FROM v$pgastat
WHERE name = 'global memory bound';(VERSION!=8)

pre_cursor STATPGAW SQL:
SELECT 0 PGAWAPCT
FROM v$sysstat
WHERE name ='session pga memory';(VERSION=8)

SELECT TO_NUMBER(DECODE(PGA2.value, 0, -1, PGA.value/PGA2.value * 10000)) PGAWAPCT
FROM v$pgastat PGA, v$pgastat PGA2
WHERE PGA.name = 'aggregate PGA auto target'
AND PGA2.name = 'aggregate PGA target parameter';(VERSION!=8)

pre_cursor STATRBHW SQL:
SELECT round(avg(waits)/avg(gets)*100,2)*100 RBHDRWP
FROM v$rollstat;

pre_cursor STATET SQL:
SELECT value ENQTIMEO
FROM v$sysstat
WHERE name = 'enqueue timeouts';

pre_cursor STATBBW SQL:
SELECT count(*) BUFBSYW
FROM v$session_wait
WHERE state='WAITING'
AND event ='buffer busy waits'
GROUP BY event;

pre_cursor CACHE5 SQL:
SELECT physical_reads KEEPPHYRD,
db_block_gets KEEPDBGETS,
consistent_gets KEEPCGETS,
((1 - (physical_reads / greatest(1, db_block_gets + consistent_gets))) * 100) KEEPHITP
FROM V$BUFFER_POOL_STATISTICS
WHERE name = 'KEEP';

pre_cursor CACHE6 SQL:
SELECT physical_reads RCLPHYRD,
db_block_gets RCLDBGETS,
consistent_gets RCLCGETS,
((1 - (physical_reads / greatest(1, db_block_gets + consistent_gets))) * 100) RCLHITP
FROM V$BUFFER_POOL_STATISTICS
WHERE name = 'RECYCLE';

Disabled: Oracle_Statistics_Summary

Navigation Tree: None
Workspace: None
Situation: Oracle_Bkgd_Dump_Space_Crit
Oracle_Bkgd_Dump_Space_Warn
Oracle_Buf_Cache_Hit_Int_Crit
Oracle_Buf_Cache_Hit_Int_Warn
Oracle_Cont_Row_Crit
Oracle_Cont_Row_Warn
Oracle_Cursors_Per_Tran_High
Oracle_Data_Cache_Inefficient
Oracle_Deadlocks_Timeouts_High
Oracle_Enqueue_Waits_High
Oracle_FreeList_Wait_Ratio_Crit
Oracle_FreeList_Wait_Ratio_Warn
Oracle_Redo_Log_Spc_Waits_Crit
Oracle_Redo_Log_Spc_Waits_Warn
Oracle_Redo_Log_Waits_Critical
Oracle_Redo_Log_Waits_Warning
Oracle_Time_Between_Checkpoints
Oracle_Too_Many_Rollbacks

9.0 Copyright and trademark information
==================================
A current list of IBM trademarks is available on the Web at "Copyright
and trademark information" at www.ibm.com/legal/copytrade.shtml.


10.0 Notices
=======

INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION
"AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
Some jurisdictions do not allow disclaimer of express or implied
warranties in certain transactions, therefore, this statement may not
apply to you.

This information could include technical inaccuracies or typographical
errors. Changes are periodically made to the information herein; these
changes will be incorporated in new editions of the publication. IBM
may make improvements and/or changes in the product(s) and/or the
program(s) described in this publication at any time without notice.

Microsoft, Windows, and Windows Server are trademarks of Microsoft
Corporation in the United States, other countries, or both.

Java and all Java-based trademarks and logos are trademarks or
registered trademarks of Oracle and/or its affiliates.

UNIX is a registered trademark of The Open Group in the United States
and other countries.

Linux is a registered trademark of Linus Torvalds in the United States,
other countries, or both.

Other company, product, or service names may be trademarks or service
marks of others.

Third-Party License Terms and Conditions, Notices and Information
-----------------------------------------------------------------
The license agreement for this product refers you to this file for
details concerning terms and conditions applicable to third party
software code included in this product, and for certain notices and
other information IBM must provide to you under its license to
certain software code. The relevant terms and conditions, notices and
other information are provided or referenced below. Please note that
any non-English version of the licenses below is unofficial and is
provided to you for your convenience only. The English version of the
licenses below, provided as part of the English version of this file,
is the official version.

Notwithstanding the terms and conditions of any other agreement you
may have with IBM or any of its related or affiliated entities
(collectively "IBM"), the third party software code identified below
are "Excluded Components" and are subject to the following terms and
conditions:

- the Excluded Components are provided on an "AS IS" basis
- IBM DISCLAIMS ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND
CONDITIONS WITH RESPECT TO THE EXCLUDED COMPONENTS, INCLUDING, BUT
NOT LIMITED TO, THE WARRANTY OF NON-INFRINGEMENT OR INTERFERENCE
AND THE IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE
- IBM will not be liable to you or indemnify you for any claims
related to the Excluded Components
- IBM will not be liable for any direct, indirect, incidental,
special, exemplary, punitive or consequential damages with respect
to the Excluded Components.


Created/Revised by Date of Creation/Update Summary of Changes
IBM 2/19/2013 To supplement the new agent configure option which was introduced by APAR IV16897.

Download package


Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
What is Fix Central (FC)?
6.2.1-TIV-ITM_ORA-IF0007.README 7 Nov 2012 English 119196 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.DEU.README 7 Nov 2012 Dutch 134521 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.FRE.README 7 Nov 2012 French 127713 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.JPN.README 7 Nov 2012 Japanese 132101 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.PTB.README 7 Nov 2012 Brazilian Portuguese 121389 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.SPA.README 7 Nov 2012 Spanish 128831 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.tar 7 Nov 2012 English 234803200 FC FTP
6.2.1-TIV-ITM_ORA-IF0007.zip 7 Nov 2012 English 70115892 FC FTP

Problems (APARS) fixed
IZ44045, IZ52073, IZ54861, IZ58688, IZ59224, IZ60378, IZ63540, IZ63561, IZ66890, IZ67268, IZ67453, IZ68097, IZ68232, IZ69132, IZ74822, IZ75900, IZ76587, IZ76694, IZ77124, IZ77391, IZ77623, IZ80107, IZ83209, IZ85003, IZ87012, IZ87057, IZ87098, IZ88683, IZ89677, IZ89679, IZ89729, IZ90133, IZ90912, IZ91459, IZ95117, IZ95350, IZ97870, IZ98041, IZ99037, IZ99177, IZ99668, IV01226, IV03899, IV13722, IV16897, IV22048, IV24791

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Composite Application Manager for Applications
ITCAM Agent for Oracle - 5724B96OO

Software version:

6.2.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

4033217

Modified date:

2014-04-02

Translate my page

Machine Translation

Content navigation