SQWareProduction:oracle:etc:sqwora IndicatorsVar.cfg
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
