Preparing for Exadata - Oracle Exadata Recipes: A Problem-Solution Approach - page 147

echo "3. Data: High, Reco: High"
echo "4. Data: High, Reco: Normal"
read asmpick
case $asmpick in
1) dc='echo "scale=2; $data_raw_sz/2"| bc'
rc='echo "scale=2; $reco_raw_sz/2"| bc'
dbc='echo "scale=2; $raw_sz_dbfs/2"| bc' ;;
2) dc='echo "scale=2; $data_raw_sz/2"| bc'
rc='echo "scale=2; $reco_raw_sz/3"| bc'
dbc='echo "scale=2; $raw_sz_dbfs/3"| bc';;
3) dc='echo "scale=2; $data_raw_sz/3"| bc'
rc='echo "scale=2; $reco_raw_sz/3"| bc'
dbc='echo "scale=2; $raw_sz_dbfs/3"| bc';;
4) dc='echo "scale=2; $data_raw_sz/3"| bc'
rc='echo "scale=2; $reco_raw_sz/2"| bc'
dbc='echo "scale=2; $raw_sz_dbfs/3"| bc';;
*) failme
esac
}
choose_config
choose_reco_pct
choose_asm
echo "Exadata Storage Sizing Details"
echo "=============================="
echo "Initial raw capacity is $raw_sz TB"
echo "Final DATA usable capacity is $dc TB"
echo "Final RECO usable capacity is $rc TB"
echo "Final DBFS_DG usable capacity is $dbc TB"
If you run the script, the output will look like this:
Macintosh-7:source jclarke$ ./ lst06-01-storageplan.sh
Choose Exadata Configuration
1. Quarter Rack High Performance
2. Quarter Rack High Capacity
3. Half Rack High Performance
4. Half Rack High Capacity
5. Full Rack High Performance
6. Full Rack High Capacity
4
Enter % allocation for RECO storage (i.e., 40 = 40%): 20
Choose ASM Configuration
1. Data: Normal, Reco: Normal
2. Data: Normal, Reco: High
3. Data: High, Reco: High
4. Data: High, Reco: Normal
3
Exadata Storage Sizing Details
==============================