Max datafiles


Job details

Name: Max datafiles
Platform: Oracle
Category: Availability
Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Long description:
Version: 1.0
Default schedule: 45m
Requires engine install: No
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]

Parameters

Name Default value Description
warning_threshold 20 Number of database files left until max datafiles (db_files) is reached in order to generate warning
alarm_threshold 5 Number of database files left until max datafiles (db_files) is reached in order to generate alarm

Job Summary

select to_number(p.value) "Max datafiles", to_number(d.cnt) "Current datafiles"
from v$parameter p, (select count(*) as cnt from v$datafile d) 
where upper(name) like 'DB_FILES';

Monitoring Logic

The specified SQL queries and Javascript processing logic within the monitoring job operates as follows:

Output Handling

Integration and Compatibility

In summary, this job efficiently monitors crucial parameters related to datafile usage in Oracle databases, provides actionable intelligence through alarms, and reports, all of which assist in maintaining optimal database performance and avoiding potential outages.