Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shell script to pull out value of tablespace used %age...

441858Mar 27 2009 — edited Apr 2 2009

Oracle 11gR1 RHEL5

Hi all,

I'm sure there is something out there, but I was wondering if anyone knew an easy way to create a script the will take a value from a sql script and then if is a certain value or greater, then it will email me. So basically I'm trying to figure out how I can get a shell script to read sql output (tablespace free space) and grab let's say any tablespace that is more than 80% full, and then send me an email with the tablespace name. I have some references but just can't seem to figrue out the reading the value part. I'm still kinda new to the shell scripting world...but eager to learn.

Thanks.

This post has been answered by jpiwowar on Mar 31 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2009

Added on Mar 27 2009

#generic-linux, #linux

19 comments

4,858 views