SQWareProduction:oracle:etc:sqwora IndicatorsVar.cfg

From Wiki_dbSQWare
Revision as of 21:30, 24 May 2011 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search

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 dbSQWare is developped with GPL Licence 3.0 :
#
# 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