OraTbSpc

Name

OraTbSpc -- Check Oracle tablespace usage

Synopsis

{ 'type'    : 'OraTbSpc' ,
  'status'  : 'on' ,
  'OraSID'       : 'instance' ,
  'OraUserPass'  : 'oracleuser/password' ,
  'OraHome'      : '/home/oracle/product/8.0.5' ,
  'triggers': [{ 'level' : 'info',     'trigger' : '90'}, 
               { 'level' : 'critical', 'trigger' : '94'}, ],
}

Description

The OraTbSpc Entity monitors usage of Oracle tablespaces. If the tablespace fills, the database will halt, and usage over 90% can cause performance degredation. The Entity reports the bytes used, free, and available, and the percent usage for each table. This Entity restricts its checks to once per hour.

OraTbSpc uses the file Entities/Base/dbspace.sql as the query.

Fields

OraSID

The name of the Oracle instance to monitor.

OraUserPass

The Oracle username and password to login to the database. The username and password should be separated by a slash. Since this data is sent IN THE CLEAR, use an account with restricted access to the database.

OraHome

The directory where the Oracle instance runs out of. This value is used to construct the proper environment to run sqlplus in.

Trigger

The Trigger fires if any tablespace's usage percent increases beyond the trigger level, or if the query to obtain the usage runs longer than 15 seconds.