undo tablespace的命中率

undo_segment.sh:

#!/bin/sh
# Oracle specific environment settings
export ORACLE_BASE=/ora01
export ORACLE_HOME=$ORACLE_BASE/9i
export ORACLE_SID=srm

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:.

datadate=`date +%D`
datatime=`date +%R`
datapath=/backup/scrīpt/tunning/undo_segment
data=undo_segment.data-`date +%Y-%m`
sqlplus '/as sysdba' @$datapath/undo_segment.sql >$datapath/undo_segment.log
#/bin/cat $datapath/undo_segment.log |egrep -v "SQL|Oracle|JServer|With|Disconnect|Connect|Total|-|rows"|sed '/^$/d' >>$datapath/$data
/bin/cat $datapath/undo_segment.log |egrep -v "SQL|Oracle|JServer|onnect|Total"|sed '/^$/d' >>$datapath/$data
#echo $datadate $datatime $values >> $datapath/$data

undo_segment.sql:

set heading off;
set feedback off;
alter session set nls_date_format='DD-MON-yyyy HH24:MI:SS';
col name for a20;
select current_date,name, waits, gets, waits/gets "Ratio" from v$rollstat a, v$rollname b where a.usn = b.usn;
exit;