[Xymon] xym-oracle.sh script

[Benjamin P. August]

My oracle tablespace monitoring query (I stole it from the old bb-roracle.sh script) is this:

$SQLPLUS -s $DBUSER/$DBPASS@$ORACLE_SID <<EOF > $TEMPFILE 2>&1
(sqlplus variables go here)
select d.tablespace_name "Tablespace Name", round((d.bytes / 1048576),1) "Size (M)", round((d.maxbytes / 1048576),0) "Max Size (M)", round((d.bytes / d.maxbytes) * 100,0) "% Used", autoextensible "AutoExtend ?"
from dba_data_files d
where d.tablespace_name NOT LIKE '%ROLLBACK%'
order by 1;
exit;
EOF

Then the logic in the script checks for a NO in the last column and a number larger than 96 in the next to last column like so: 

if test `grep -c "[97 98 99 100] NO" $TEMPFILE` -gt 0;
then
        COLOR=red
        MSG="There is a full, non-extensible tablespace"
fi

(I am sure someone is going to come up with a better regex up there :D )

----- Original Message -----
From: "Paul Root" <Paul.Root at CenturyLink.com>
To: xymon at xymon.com
Sent: Thursday, June 21, 2012 10:11:28 AM
Subject: [Xymon] xym-oracle.sh script

Hi,
        I'm bringing up the xym-oracle script, version 1 from April 25, 2012. And it has one issue. Our dba have table spaces set to AUTOEXTEND, and so SYSTEM and SYSAUX were above 94%.   Is there a way in the script to see if they are set in AUTOEXTEND.

Thanks,
Paul.

Paul Root    - Senior Engineer
Managed Services Systems - CenturyLink




This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly
prohibited and may be unlawful.  If you have received this communication
in error, please immediately notify the sender by reply e-mail and destroy
all copies of the communication and any attachments.
_______________________________________________
Xymon mailing list
Xymon at xymon.com
http://lists.xymon.com/mailman/listinfo/xymon