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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(12 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
#!/bin/ksh
 
#!/bin/ksh
 
###################################################################
 
###################################################################
−
# SQWareProduction for Oracle module of dbSQWare is developped with GPL License 3.0 :
+
# SQWareProduction for Oracle module of dbSQWare
−
#
 
−
# 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,
 
# dbSQWare is distributed in the hope that it will be useful,
 
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
−
# GNU General Public License for more details.
+
# CGU/CGA for more details.
 
#  
 
#  
−
# You should have received a copy of the GNU General Public License
+
# You should have received a copy of the CGU/CGA
−
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
 
#  
 
#  
 
# For information : contact@dbsqware.com or www.dbsqware.com
 
# For information : contact@dbsqware.com or www.dbsqware.com
 
###################################################################
 
###################################################################
 
## @Synopsis var for RMAN duplicate scripts
 
## @Synopsis var for RMAN duplicate scripts
−
## @Copyright Copyright 2010-2012, OctopusDBA
+
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
−
## @License GPL v3
 
−
## SVN : $URL$
 
−
## SVN : $Id$
 
  
 
export gvsqw_Stat_estimate_percent=10
 
export gvsqw_Stat_estimate_percent=10
 
export gvsqw_Stat_block_sample=TRUE
 
export gvsqw_Stat_block_sample=TRUE
 
export gvsqw_Stat_method_opt="FOR ALL INDEXED COLUMNS SIZE REPEAT"
 
export gvsqw_Stat_method_opt="FOR ALL INDEXED COLUMNS SIZE REPEAT"
−
export gvsqw_Stat_sys_method_opt="FOR COLUMNS SIZE SKEWONLY"
+
export gvsqw_Stat_sys_method_opt="FOR ALL COLUMNS SIZE SKEWONLY"
 
export gvsqw_Stat_degree=1
 
export gvsqw_Stat_degree=1
 
export gvsqw_Stat_granularity="ALL"
 
export gvsqw_Stat_granularity="ALL"
Line 45: Line 37:
  
 
# For not normed environnement
 
# For not normed environnement
−
[ -r $HOME/edtConfig/sqwora_DbmsStats.cfg ] && . $HOME/edtConfig/sqwora_DbmsStats.cfg
+
[ -r $HOME/sqwConfig/sqwora_DbmsStats.cfg ] && . $HOME/sqwConfig/sqwora_DbmsStats.cfg
 
</pre>
 
</pre>
 
<br>
 
<br>

Latest revision as of 21:19, 25 February 2024

Configuration file $gvsqw_OraBin/../etc/sqwora_DbmsStats.cfg:
var for RMAN duplicate scripts


File content: 

#!/bin/ksh
###################################################################
# SQWareProduction for Oracle module of dbSQWare
# 
# 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
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	var for RMAN duplicate scripts
## @Copyright	Copyright 2010-2024, dbSQWare (www.dbsqware.com)

export gvsqw_Stat_estimate_percent=10
export gvsqw_Stat_block_sample=TRUE
export gvsqw_Stat_method_opt="FOR ALL INDEXED COLUMNS SIZE REPEAT"
export gvsqw_Stat_sys_method_opt="FOR ALL COLUMNS SIZE SKEWONLY"
export gvsqw_Stat_degree=1
export gvsqw_Stat_granularity="ALL"
export gvsqw_Stat_cascade=TRUE
export gvsqw_Stat_options="GATHER AUTO"
export gvsqw_Stat_sys_options="GATHER"
export gvsqw_Stat_gather_sys=FALSE

# Source custom
[ -r $gvsqw_OraBin/../etc_cust/sqwora_DbmsStats.cfg ] && . $gvsqw_OraBin/../etc_cust/sqwora_DbmsStats.cfg

# For not normed environnement
[ -r $HOME/sqwConfig/sqwora_DbmsStats.cfg ] && . $HOME/sqwConfig/sqwora_DbmsStats.cfg


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