check_oracle_tbs

Project Notes

This little perl script is able to check Oracle tablespaces usage. You can also specify a regex to exclude tablespaces if you do not want to check all tablespaces (example : UNDO tablespaces in Oracle 10g are usually close to full)

Usage : {{$0 -SID= -dbuser= -dbpassword= -w= -c= -e=(regex) -wauto=
-SID : Oracle SID
-dbuser : Oracle user
-dbpassword : Oracle password
-w : usage percent for warning
-c : usage percent for critical alert
-wauto : usage percent for warning on autoext tablespaces
-e=(regex) : regex for tablespace exclusion (example : -e='UNDOTBS0-9')
}}
If you do not use the -wauto option, autoext tablespaces are treated as same as non-autoext tablespaces