Script for V$flash_recovery_area_usage Post: 302529049

Sponsored Content

Top Forums Shell Programming and Scripting Script for V$flash_recovery_area_usage Post 302529049 by radoulov on Wednesday 8th of June 2011 11:33:38 AM

06-08-2011

Registered User

You could use something like this:

Code:

#!/bin/bash


ORACLE_HOME=<your_oracle_home>
ORACLE_SID=<your_oracle_sid>
ORAENV_ASK=NO
export ORACLE_HOME ORACLE_SID ORAENV_ASK

. "$ORACLE_HOME"/bin/oraenv

_limit=80
_mailto=<your_email_address>
_mail_subject="FRA usage for $ORACLE_SID on $HOSTNAME"
_today=$(
  date '+%Y-%m-%d %H:%M:%S'
  )
_yesterday=$(
  date -d yesterday +'%Y-%m-%d 00:00:00'
  )

_my_result=$(
  adrci exec="
    set home $ORACLE_SID;
    show alert -term -P \\\"MESSAGE_TEXT like '%ORA-19815%' and ORIGINATING_TIMESTAMP between '$_yesterday' and '$_today'\\\"
   "
  )


_my_percentil=$(
  sed -rn '/ORA-19815/s/.*is ([0-9]+).?[0-9]*% used.*/\1/p' <<< "$_my_result"
  )

((${_my_percentil:-0} > _limit)) &&
   mailx -s "$_mail_subject" "$_mailto" <<< "$_my_result"

The interval is the day before from 00:00:00 until the moment the script is executed, you may need to adjust it.

radoulov

View Public Profile for radoulov

Find all posts by radoulov

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table...

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ...

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"...

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"...

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My...

LEARN ABOUT DEBIAN

fra

FRA(1)							      General Commands Manual							    FRA(1)

NAME

       FRA - Example of using QuantLib

SYNOPSIS

       FRA

DESCRIPTION

       FRA is an example of using the QuantLib interest-rate model framework.

       FRA values a forward-rate agreement (FRA) at different forward dates under two yield curve assumptions. It thereby illustrates how set up a
       term structure, and to use it to price a simple forward-rate agreement.

SEE ALSO

       The source code FRA.cpp, BermudanSwaption(1), Bonds(1), CallableBonds(1), CDS(1), ConvertibleBonds(1), DiscreteHedging(1), EquityOption(1),
       FittedBondCurve(1),   MarketModels(1),	Replication(1),   Repo(1),   SwapValuation(1),	 the   QuantLib   documentation   and  website	at
       http://quantlib.org.

AUTHORS

       The QuantLib Group (see Authors.txt).

       This manual page was added by Dirk Eddelbuettel <edd@debian.org>, the Debian GNU/Linux maintainer for QuantLib.

QuantLib							    07 Jul 2006 							    FRA(1)