Max datafiles check

Name:	Max datafiles check
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:	From Oracle 9i, an attempt to add a file whose number is greater than MAXDATAFILES (‘hard limit’), but less than or equal to DB_FILES (‘soft limit’), causes the Oracle control file to expand automatically. Within the ora parameter ‘db_files’ applies to the ‘soft limit’. The maxdatafiles value stored in the Oracle control files applies to the ‘hard limit’.
Version:	2.7
Default schedule:	15 5,17 * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _priv_read_v_controlfile_record_section = ‘1’ & _priv_read_v_parameter = ‘1’]]]

Feedback