{ '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'}, ], }
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
The name of the Oracle instance to monitor.
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.
The directory where the Oracle instance runs out of. This value is used to construct the proper environment to run sqlplus in.