check DBF autoextended Oracle

Project Notes

check for dbf autoextended files or for dbf size in tablespace. This check compares two values : 1) The occupancy rate of every DBF in comparison with their max size. 2) The real size of DBF with its max size. No need to specify DBF name. The check will search all the autoextended DBF existing in the tablespace parameter ############################################################## ### [email protected] ### ### V1.1 -> 01/11/2009 ### ###--------------------------------------------------------### ### LISTE DES PARAMETRES ### ### -u/-U user ### ### -p/-P Password ### ### -l/-L Listener ### ### -t/-T Nom du tablespace ### ###--------------------------------------------------------### ### -m/-M a vide (Optionel) ### ### -m pour checker tous les DBF du TBS en parametre ### ### -m Utilise la requete check_autoextend_multi.sql ### ### sinon Utilise la requete check_autoextend.sql ### ###--------------------------------------------------------### ##############################################################