@see http://discus-hamburg.cocolog-nifty.com/mac_de_oracle/2014/08/pivotsqlpluss-1.html

gistfile1.sh

#!/bin/bash
#
(
echo "conn scott/tiger"
echo "set timi off time off sqlp \"\" feed off lines 9999 trims on tab off"
echo "set numformat 999999999999999999999999999999"
while :
do
  t=$(date +'%DT%T')
  echo "SELECT '${t:0:8}' as logged_date, '${t:9}' as logged_time,db_time,db_cpu,bg_time,bg_cpu FROM (SELECT stat_name,value FROM v\$sys
_time_model) PIVOT (MAX(value) FOR stat_name IN ('DB time' AS db_time,'DB CPU' AS db_cpu,'background elapsed time' AS bg_time,'backgroun
d cpu time' AS bg_cpu));"
  echo "set head off newp none"
  sleep ${SLEEP:-10}
done

) | sqlplus /nolog