a collection of scripts to ease the day-to-day work of an Oracle DBA
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

56 lines
2.0 KiB

#!/bin/bash
# $Id$
#
# =============================================================================
# Global configuration for tabmove.sh, idxmove.sh, idxrebuild.sh and
# analobj.sh
# -----------------------------------------------------------------------------
# Itzchak Rehberg
#
# =========================================================[ Global values ]===
# login information
user=""
password=""
# Oracle SID
export ORACLE_SID=$1
# Prefix for the log file to write to. The parameters passed to the script will
# be used to make the output name somehow unique. So with PREFIX set to DEFAULT,
# an example file name has the syntax "tabmov-$1-$2-$3.spool" for the script
# tabmove.sh
# Valid values are:
# OFF -- no log file will be written
# DEFAULT -- script name will be used as prefix
# all other values will be understand literally. Since we use SQL*Plus and
# its SPOOL facility, existing files will be overwritten without warning!
PREFIX=DEFAULT
# Directory to store the output (Spool) files. Leave empty for current dir
SPOOLDIR=out
# ====================================================[ analobj & tabreorg ]===
# restrictions: what are the minimal settings to display?
NUMROWS=1000
CHAINCNT=10
# estimate or compute statistics?
CALCSTAT=COMPUTE
# Log all (analyze/detail) statements as well (1) or only results/progress (0)?
LOGALL=0
# ==============================================================[ tabreorg ]===
# which value to add to PCTUSED
TR_USEDINC=0
# which value to add to PCTFREE
TR_FREEINC=10
# min pct of chained rows a table must have to be re-organized
TR_CHAINPCT=7
# ==============================================[ tabreorg & idxrebuild_all ]===
# Adjust initial extent size according index size (if not called w/ "--noadjust"):
# small <= 256k; medium <= 5M; large <= 100M <= xxl
INIT_SMALL="64k"
NEXT_SMALL="64k"
INIT_MEDIUM="512k"
NEXT_MEDIUM="128k"
INIT_LARGE="10M"
NEXT_LARGE="1M"
INIT_XXL="100M"
NEXT_XXL="10M"