Below script is for finding the Apex Page Time
**********************************************************************************************************
/home/oracle/backup/scripts/pagetime.sh
. /home/oracle/db.env
export SC_LOG=/Backup/pagetime/fms_`date +%d_%b_%Y_%H_%M`.log
sqlplus -s <<EOF >>/usr/tmp/tmp2.log
connect /as sysdba
spool \$SC_LOG
select flow_id,step_id,sum(elap)/count(*) “Average” from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG where flow_id=100 group by flow_id,step_id order by 3 desc;
spool off
quit
EOF
rm -rf /usr/tmp/tmp2.log
**********************************************************************************************************
Recent Posts