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