Below script is for finding the Apex page hits
**********************************************************************************************************
/home/oracle/backup/scripts/pagehits.sh
. /home/oracle/db.env
export SC_LOG=/Backup/pagehits/fms_`date +%d_%b_%H_%M_%Y`.log
sqlplus -s <<EOF >>/usr/tmp/tmp1.log
connect /as sysdba
spool \$SC_LOG
select flow_id,step_id,count(*) 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/tmp1.log
**********************************************************************************************************
Recent Posts