Difference between revisions of "Template:SQWareProduction sqwora IndicatorsVar.cfg content"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 22: Line 22:
 
###################################################################
 
###################################################################
 
## @Synopsis Global var for indicators scripts
 
## @Synopsis Global var for indicators scripts
−
## @Copyright Copyright 2010-2013, OctopusDBA
+
## @Copyright Copyright 2010-2014, OctopusDBA (www.octopusdba.com)
 
## @License GPL v3
 
## @License GPL v3
−
## SVN : $URL$
 
−
## SVN : $Id$
 
  
−
#for check backup rman
+
#for Checkstorage backup rman
 
if [ "$(date +'%a')" = "Mon" ]
 
if [ "$(date +'%a')" = "Mon" ]
 
then
 
then
Line 35: Line 33:
 
fi
 
fi
 
export gvsqw_NbDaysFull=7
 
export gvsqw_NbDaysFull=7
−
 
+
export gvsqw_RmanCheckStatus="'ON','DIST','MIX'"
−
#for purge indicators tables (in number of days)
 
−
export gvsqw_PurgeAwrHits=60
 
−
export gvsqw_PurgeAwrWkl=60
 
−
export gvsqw_PurgeAwrMonitorHits=60
 
−
export gvsqw_PurgeAwrMonitorWkl=60
 
−
export gvsqw_PurgeAwrBufferGetsBef111=60
 
−
export gvsqw_PurgeAwrBufferGetsAft112=60
 
−
export gvsqw_PurgeAwrExecutionsBef111=60
 
−
export gvsqw_PurgeAwrExecutionsAft112=60
 
−
export gvsqw_PurgeAwrPhysicalReadsBef111=60
 
−
export gvsqw_PurgeAwrPhysicalReadsAft112=60
 
−
export gvsqw_PurgeAwrUnOptimizedReads=60
 
−
export gvsqw_PurgeAwrElapsedBef111=60
 
−
export gvsqw_PurgeAwrElapsedAft112=60
 
−
export gvsqw_PurgeAwrCpuBef111=60
 
−
export gvsqw_PurgeAwrCpu111=60
 
−
export gvsqw_PurgeAwrCpuAft112=60
 
−
export gvsqw_PurgeGenInfos=700
 
−
export gvsqw_PurgeGenHisto=800
 
−
export gvsqw_PurgeJobsExec=120
 
−
export gvsqw_PurgeVolBackupsMonitoring=120
 
−
export gvsqw_PurgeVolArchlogs=120
 
−
export gvsqw_PurgeVolArchlogsInst=120
 
−
export gvsqw_PurgeMaxLog=120
 
−
export gvsqw_PurgeFra=120
 
−
export gvsqw_PurgeVolBackups=120
 
−
export gvsqw_PurgeCheckInstance=120
 
−
export gvsqw_PurgeVolDb=700
 
−
export gvsqw_PurgeVolTbs=700
 
−
export gvsqw_PurgeVolSchema=700
 
−
export gvsqw_PurgeVolSegments=700
 
−
export gvsqw_PurgeVolFs=700
 
−
export gvsqw_PurgeParameters=120
 
−
 
 
−
# 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
 
 
</pre>
 
</pre>

Latest revision as of 17:48, 5 April 2014


File content: 

#!/bin/ksh
###################################################################
# SQWareProduction for Oracle module of dbSQWare is developped with GPL License 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.
# 
# dbSQWare 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-2014, OctopusDBA (www.octopusdba.com)
## @License	GPL v3

#for Checkstorage backup rman
if [ "$(date +'%a')" = "Mon" ]
then
	export gvsqw_NbDaysInc=3
else
	export gvsqw_NbDaysInc=2
fi
export gvsqw_NbDaysFull=7
export gvsqw_RmanCheckStatus="'ON','DIST','MIX'"
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_IndicatorsVar.cfg_content&oldid=4606"