LISTING 12: This script, dbMajor.usr, is a configuration file used by dbAdmCron.sh (Listing 10). It provides a list of major database users and the analysis method to be used for each one.

# Filename : dbMajor.usr
# Purpose  : Provides a list of database major users, so the dbms_admin can
#	look up the SID in /etc/oratab and find out which user's schema should
#	be analyzed.
# Format   : SID 	USER 	ANALYZE_METHOD min_Extents	 hostname
# Usage    : egrep "^$SID " dbMajor.usr
# NOTE !!  :  ADM@betty and BKT@fred needn't be analyzed
# 	COST 	  : use V.1 analyze method, see dbAdmCron.sh
# 	HISTOGRAM : use V.2 analyze method, see dbAdmCron.sh
#          RULE: use rule-based method
# ==============================================================
LWSN	    LAWSON	 COST		  0      wilma
LAWT	    LAWSON	 COST		50      barney
RAMPR	   RAMS41	 HISTOGRAM   50      wilma

# RAMQA   RAMS41    
RAMT    RAMS41	 HISTOGRAM   50      barney

# 	SDGB    SDGTEST	50barney  -> has been erased Dec, 1996
# SDG has changed to Rule-based in Dec. 1996
SDGT	   SDGTEST	 RULE        50      barney 
SDGPR	   SDG		 RULE        50      fred
SDGQA   SDG		 RULE        50      fred