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}}
<br>
+
{{SQWareProduction_sqwora_IndicatorsVar.cfg_content}}
<br>
+
{{SQWareProduction_sqwora_IndicatorsVar.cfg_explanation}}
File content:
 
<pre>
 
export gvsqw_NbDaysInc=3
 
export gvsqw_NbDaysInc=2
 
export gvsqw_NbDaysFull=7
 
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
 
</pre>
 
<br>
 
<br>
 
Variable explanation:
 
<pre>
 
gvsqw_NbDaysFull =>
 
gvsqw_NbDaysInc =>
 
gvsqw_NbDaysInc =>
 
gvsqw_PurgeAwrBufferGetsAft112 =>
 
gvsqw_PurgeAwrBufferGetsBef111 =>
 
gvsqw_PurgeAwrCpu111 =>
 
gvsqw_PurgeAwrCpuAft112 =>
 
gvsqw_PurgeAwrCpuBef111 =>
 
gvsqw_PurgeAwrElapsedAft112 =>
 
gvsqw_PurgeAwrElapsedBef111 =>
 
gvsqw_PurgeAwrExecutionsAft112 =>
 
gvsqw_PurgeAwrExecutionsBef111 =>
 
gvsqw_PurgeAwrHits =>
 
gvsqw_PurgeAwrMonitorHits =>
 
gvsqw_PurgeAwrMonitorWkl =>
 
gvsqw_PurgeAwrPhysicalReadsAft112 =>
 
gvsqw_PurgeAwrPhysicalReadsBef111 =>
 
gvsqw_PurgeAwrUnOptimizedReads =>
 
gvsqw_PurgeAwrWkl =>
 
gvsqw_PurgeCheckInstance =>
 
gvsqw_PurgeFra =>
 
gvsqw_PurgeGenHisto =>
 
gvsqw_PurgeGenInfos =>
 
gvsqw_PurgeJobsExec =>
 
gvsqw_PurgeMaxLog =>
 
gvsqw_PurgeParameters =>
 
gvsqw_PurgeVolArchlogs =>
 
gvsqw_PurgeVolArchlogsInst =>
 
gvsqw_PurgeVolBackups =>
 
gvsqw_PurgeVolBackupsMonitoring =>
 
gvsqw_PurgeVolDb =>
 
gvsqw_PurgeVolFs =>
 
gvsqw_PurgeVolSchema =>
 
gvsqw_PurgeVolSegments =>
 
gvsqw_PurgeVolTbs =>
 
</pre>
 
 
{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_IndicatorsVar.cfg}}
 
{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_IndicatorsVar.cfg}}
 
<br>
 
<br>

Revision as of 22:25, 17 December 2012

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-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'"


Variables explanation:

gvsqw_NbDaysFull => Number of days to Checkstorage succeded full backup
gvsqw_NbDaysInc => Number of days to Checkstorage succeded inc backup

gvsqw_AwrBufferGetsAft112 => Number of days to purge tsqw_AwrBufferGetsAft112
gvsqw_AwrBufferGetsBef111 => Number of days to purge tsqw_AwrBufferGetsBef111
gvsqw_AwrCpu111 => Number of days to purge tsqw_AwrCpu111
gvsqw_AwrCpuAft112 => Number of days to purge tsqw_AwrCpuAft112
gvsqw_AwrCpuBef111 => Number of days to purge tsqw_AwrCpuBef111
gvsqw_AwrElapsedAft112 => Number of days to purge tsqw_AwrElapsedAft112
gvsqw_AwrElapsedBef111 => Number of days to purge tsqw_AwrElapsedBef111
gvsqw_AwrExecutionsAft112 => Number of days to purge tsqw_AwrExecutionsAft112
gvsqw_AwrExecutionsBef111 => Number of days to purge tsqw_AwrExecutionsBef111
gvsqw_AwrHits => Number of days to purge tsqw_AwrHits
gvsqw_AwrPhysicalReadsAft112 => Number of days to purge tsqw_AwrPhysicalReadsAft112
gvsqw_AwrPhysicalReadsBef111 => Number of days to purge tsqw_AwrPhysicalReadsBef111
gvsqw_AwrUnOptimizedReads => Number of days to purge tsqw_AwrUnOptimizedReads
gvsqw_CheckInstance => Number of days to purge tsqw_CheckInstance
gvsqw_GenHisto => Number of days to purge tsqw_GenHisto
gvsqw_GenInfos => Number of days to purge tsqw_GenInfos
gvsqw_JobsExec => Number of days to purge tsqw_JobsExec
gvsqw_VolArchlogs => Number of days to purge tsqw_VolArchlogs
gvsqw_VolBackups => Number of days to purge tsqw_VolBackups
gvsqw_VolBackupsMonitoring => Number of days to purge tsqw_VolBackupsMonitoring
gvsqw_VolDb => Number of days to purge tsqw_VolDb
gvsqw_VolSchema => Number of days to purge tsqw_VolSchema
gvsqw_VolSegments => Number of days to purge tsqw_VolSegments
gvsqw_VolTbs => Number of days to purge tsqw_VolTbs
Nuvola apps information.png
Note:
You can overload variables contain in $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg

by the same variables in $gvsqw_OraBin/../etc_cust/sqwora_IndicatorsVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwora_IndicatorsVar.cfg specifically for this user.