SQWareProduction:oracle:etc:sqwora IndicatorsVar.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg:
Global var for indicators scripts
It contains the operating variables of SQWareProduction.
File content:
#!/bin/ksh ################################################################### # SQWareProduction for Oracle module of expdbTools is developped with GPL Licence 3.0 : # trademark => dbSQWare� # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. # # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### ## @Synopsis Global var for indicators scripts ## @Copyright Copyright 2010-2011, Michel PAYAN ## @License GPL v3 ## SVN : $URL$ ## SVN : $Id$ #for check backup rman if [ "$(date +'%a')" = "Mon" ] then export gvsqw_NbDaysInc=3 else export gvsqw_NbDaysInc=2 fi export gvsqw_NbDaysFull=7 #for purge indicators tables (in number of days) export gvsqw_AwrHits=60 export gvsqw_AwrBufferGetsBef111=60 export gvsqw_AwrBufferGetsAft112=60 export gvsqw_AwrExecutionsBef111=60 export gvsqw_AwrExecutionsAft112=60 export gvsqw_AwrPhysicalReadsBef111=60 export gvsqw_AwrPhysicalReadsAft112=60 export gvsqw_AwrUnOptimizedReads=60 export gvsqw_AwrElapsedBef111=60 export gvsqw_AwrElapsedAft112=60 export gvsqw_AwrCpuBef111=60 export gvsqw_AwrCpu111=60 export gvsqw_AwrCpuAft112=60 export gvsqw_GenInfos=700 export gvsqw_GenHisto=800 export gvsqw_JobsExec=120 export gvsqw_VolBackupsMonitoring=120 export gvsqw_VolArchlogs=120 export gvsqw_VolBackups=120 export gvsqw_CheckInstance=120 export gvsqw_VolDb=700 export gvsqw_VolTbs=700 export gvsqw_VolSchema=700 export gvsqw_VolSegments=700 export gvsqw_VolTbs=700 # Source custom [ -r $gvsqw_OraBin/../etc_cust/sqwora_IndicatorsVar.cfg ] && . $gvsqw_OraBin/../etc_cust/sqwora_IndicatorsVar.cfg # For not normed environnement [ -r $HOME/edtConfig/sqwora_IndicatorsVar.cfg ] && . $HOME/edtConfig/sqwora_IndicatorsVar.cfg