ORATS

Explanation

ORATS is the enclosing tag for all oracle tablespace-entries.

Parent

OSAGENT

allowed values

• TABLESPACE

Count

0 or 1. If you don't define ORATS, no orats check will run.

Example

<ORATS>
  <TABLESPACE>
    <ORACLE_SID>osmart</ORACLE_SID>
    <TABLESPACENAME>SYSTEM</TABLESPACENAME>
    <VALUE>80</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TABLESPACE>
  <TABLESPACE>
    <ORACLE_SID>osmart</ORACLE_SID>
    <TABLESPACENAME>SYSTEM</TABLESPACENAME>
    <VALUE>90</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TABLESPACE>

  <TABLESPACE>
    <ORACLE_SID>osmart</ORACLE_SID>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>30</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TABLESPACE>
  <TABLESPACE>
    <ORACLE_SID>osmart</ORACLE_SID>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>35</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TABLESPACE>
</ORATS>
        

TABLESPACE

Explanation

For every Tablespace in every Oracle Instance you want to check, you define a TABLESPACE-entry.

Parent

• ORATS

• ORAAX

• DB2TS

allowed values

• TABLESPACENAME

• VALUE

• FORMULA

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

For Oracle Tablespaces (checks: ORATS and ORAAX):

• ORACLE_SID

For DB2 DMS Tablespaces (check: DB2TS):

• DB2ALIAS

• DB2PROFILE

Count

As many as you want

Example

Look at ORATS and DB2TS

TABLESPACENAME

Explanation

Name of the tablespace to be checked.

Parent

TABLESPACE

allowed values

regexes for tablespaces in the oracle instance or the DB2 database.

Count

1

Example

Look at ORATS and DB2TS

ORACLE_SID

Explanation

Which Oracle Instance on your server ?

Parent

TABLESPACE

allowed values

Any existing Oracle SID

Count

1

Example

Look at ORATS