SQWareProduction:oracle:etc:sqwora IndicatorsVar.cfg: Difference between revisions
Jump to navigation
Jump to 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> | |||
<br> | |||
File content: | |||
<pre> | |||
#!/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 | |||
</pre> | |||
<br> | <br> |
Revision as of 22:43, 12 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 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