Template:SQWareProduction sqwora IndicatorsVar.cfg content

From Wiki_dbSQWare
Revision as of 13:27, 2 January 2011 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


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