Difference between revisions of "SQWareProduction:oracle:etc:sqwora IndicatorsVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg:<br>
 
Configuration file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg:<br>
 
{{SQWareProduction_sqwora_IndicatorsVar.cfg_presentation}}
 
{{SQWareProduction_sqwora_IndicatorsVar.cfg_presentation}}
−
{{SQWareProduction_sqwora_IndicatorsVar.cfg_content}}
+
<br>
−
{{SQWareProduction_sqwora_IndicatorsVar.cfg_explanation}}
+
<br>
−
{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_IndicatorsVar.cfg}}
+
File content:
 +
<pre>
 +
#!/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-2012, OctopusDBA
 +
## @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
 +
</pre>
 
<br>
 
<br>

Revision as of 11:48, 26 November 2011

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 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-2012, OctopusDBA
## @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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:oracle:etc:sqwora_IndicatorsVar.cfg&oldid=2652"