#!/usr/bin/ksh 
# program :smenu_wait_stat.sh
# author B. Polarski

if [ "$1" = "-h" ];then

   cat <<EOF

    Show System waitstat figures (v\$waitstat)

    Usage :       ws 

   
    Note : Starting 10g, event 'buffer busy wait' in v\$session_waits shows for argument p3
           the class number instead of the reason code ( metalink Note:34405.1) 
           This class number, is in fact the rownum of v$waistat. For this reason the pseudo
           column class# has been added here.

EOF
exit
fi


. $SBIN/scripts/passwd.env
. ${GET_PASSWD} $S_USER $ORACLE_SID
if [  "x-$CONNECT_STRING" = "x-" ];then
      echo "could no get a the password of $S_USER"
      exit 0
fi

sqlplus -s "$CONNECT_STRING" <<EOF

set linesize 80
ttitle skip 2 'MACHINE $HOST - ORACLE_SID : $ORACLE_SID '  right 'Page:' format 999 sql.pno skip 2
column nline newline
set pagesize 66
set termout on
set embedded on
set verify off
set heading off pause off
 
select 'Date              -  '||to_char(sysdate,'Day Ddth Month YYYY  HH24:MI:SS'),
       'Username          -  '||USER  nline ,
       'Show System waitstat figures (v\$waitstat)' nline
from sys.dual
/   
set head on pause off feed off
set linesize 80

column wait head "Class"
column count head "Count"
column time head "Time"

select
 rownum as class#, class, count , Time
from
  sys.v_\$waitstat  
/
prompt
EOF