9.35. Configuration for the orasessions check

9.35. Configuration for the orasessions check
Prev	Chapter 9. Configure the OpenSMART agents	Next

Check your oracle database for the maximum number of active sessions.

Active sessions will be identified by:

select count(*) from v$session

The maximum number of possible sessions is identified by max_processes parameter.

You can define thresholds (in percent).

ORASESSIONS

Explanation

ORASESSIONS is the enclosing tag for all databases to check.

Parent

OSAGENT

allowed values

DATABASE

Count

0 or 1. If you don't define ORASESSIONS, no orasessions check will run.

Example

<ORASESSIONS>
  <DATABASE>
    <ORACLE_HOME>/usr/local/oracle/product/9.2.0</ORACLE_HOME>
    <ORACLE_SID>osmart</ORACLE_SID>
    <THRESHOLD>
      <PERCENT>70</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase max_sessions parameter</DESCRIPTION>
    </THRESHOLD>
    <THRESHOLD>
      <PERCENT>90</PERCENT>
      <ERRORLEVEL>ERROR</PERCENT>
    </THRESHOLD>
  </DATABASE>
  <DATABASE>
    <ORACLE_HOME>/usr/local/oracle/product/9.2.0</ORACLE_HOME>
    <ORACLE_SID>osmart2</ORACLE_SID>
    <THRESHOLD>
      <PERCENT>80</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase max_sessions parameter</DESCRIPTION>
    </THRESHOLD>
  </DATABASE>
</ORASESSIONS>

DATABASE

Explanation

for every database you want to check you you define the DATABASE-pair

Parent

ORASESSIONS

allowed values

THRESHOLD
ORACLE_HOME
ORACLE_SID
The common XML tags as described in Section 9.8, “Tags Common to All Checks and/or Checkpoints”

Count

As many as you like.

Example

Look at ORASESSIONS

THRESHOLD

Explanation

This entity describes a threshold pair (percentage sessions are in use)

Parent

DATABASE

allowed values

Count

1 or more.

Example

<ORASESSIONS>
  <DATABASE>
    <ORACLE_HOME>/usr/local/oracle/product/9.2.0</ORACLE_HOME>
    <ORACLE_SID>osmart</ORACLE_SID>
    <THRESHOLD>
      <PERCENT>70</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase max_sessions parameter</DESCRIPTION>
    </THRESHOLD>
    <THRESHOLD>
      <PERCENT>90</PERCENT>
      <ERRORLEVEL>ERROR</PERCENT>
    </THRESHOLD>
  </DATABASE>
  <DATABASE>
    <ORACLE_HOME>/usr/local/oracle/product/9.2.0</ORACLE_HOME>
    <ORACLE_SID>osmart2</ORACLE_SID>
    <THRESHOLD>
      <PERCENT>80</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase max_sessions parameter</DESCRIPTION>
    </THRESHOLD>
  </DATABASE>
</ORASESSIONS>

Prev	Up	Next
9.34. Configuration for the orainvobj check.	Home	9.36. Configuration for the oratnsping check