#!/bin/bash

export LiveExtents=`ls /usr/ts53/db | sed 's/^.*\.d//' | sort -rn | head -1`
export TrainExtents=`ls /usr/ts53/traindb | sed 's/^.*\.d//' | sort -rn | head -1`

echo "Live Database Info"
echo "------------------"
echo -n "Live Database Free Space: "
df -h | awk '/db$/{print $4}'
echo -n "Live BI Free Space: "
df -h | awk '/bi$/{print $4}'

echo -n "Extents in Live: "
echo $LiveExtents
echo -n "Size of Largest Extent: "
ls -lh /usr/ts53/db/domdata_10.d`echo $LiveExtents` | awk '{print $5}'

echo
echo "Training Database Info"
echo "----------------------"
echo -n "Training Database Free Space: "
df -h | awk '/\/$/{print $3}'

echo -n "Extents in Training: "
echo $TrainExtents
echo -n "Size of Largest Extent: "
ls -lh /usr/ts53/traindb/domdata_10.d`echo $TrainExtents` | awk '{print $5}'