Template:SQWareProduction sqwora IndicatorsVar.cfg content
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_PurgeAwrHits=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_PurgeVolBackups=120 export gvsqw_PurgeCheckInstance=120 export gvsqw_PurgeVolDb=700 export gvsqw_PurgeVolTbs=700 export gvsqw_PurgeVolSchema=700 export gvsqw_PurgeVolSegments=700 export gvsqw_PurgeVolTbs=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