Manual compilation of INVALID objects in Oracle

#TO Compile Package 

ALTER PACKAGE schema.package COMPILE;

#To Compile Package Body 

ALTER PACKAGE schema.package COMPILE BODY;

#To Compile Synonym

ALTER SYNONYM schema.synonym compile;

#To Compile Procedure 

ALTER PROCEDURE schema.procedure COMPILE;

#To compile Function 

ALTER FUNCTION schema.function COMPILE;

#To Compile Trigger 

ALTER TRIGGER my_trigger COMPILE;

#To Compile View 

ALTER VIEW schema.view COMPILE;

#To Compile Materialized view

ALTER MATERIALIZED VIEW schema.view compile; 

#To Compile Public Synonym

ALTER PUBLIC SYNONYM my_synonym compile;

Script to check number of user hits on a Oracle EBS server on Monthly Basis

Script to check number of user hits on a Oracle EBS server on Monthly Basis:-

monthly_hits.sh

TIME=`date +%y%m%d%H`
export TIME
file_name=VIS_$TIME.txt
export file_name
touch $file_name
touch $ip_files.txt
SCR_DIR=/u01/oracle/VIS/inst/apps/VIS_hostname/logs/ora/10.1.3/Apache
curmth=`date +%m`
curyr=`date +%Y`
prevyr=$((curyr - 1))
echo $curmth
echo $curyr
echo $prevyr

mth=('Dec' 'Jan' 'Feb' 'Mar' 'Apr' 'May' 'Jun' 'Jul' 'Aug' 'Sep' 'Oct' 'Nov')
export MONTH='Jan'

ls -lrt $SCR_DIR|grep "access_log*"|grep "$MONTH"|awk '{print $9}'|sed -e "s/^/\/u01\/oracle\/VIS\/inst\/apps\/VIS_hostname\/logs\/ora\/10.1.3\/Apache\//g" >ip_files_$MONTH.txt
#ls -lrt $SCR_DIR|grep "access_log*"|grep "Apr"|awk '{print $9}'|sed -e "s/^/\/h
if [ $curmth == 01 ]
then
 for i in `cat ip_files_$MONTH.txt`
        do
        cat "$i"|grep "AppsLocalLogin"|grep "$MONTH"|grep $prevyr|awk '{print $1 $4}'|sed -e 's/:/ /g'|sed -e 's/\[/ /g'|sed -e 's/\//-/g'|awk '{print $2"," $1 ",VIS,EBS,US,EBS Sandbox"}'>>$file_name
        done

else
        for i in `cat ip_files_$MONTH.txt`
        do
 cat "$i"|grep "AppsLocalLogin"|grep "$MONTH"|grep $curyr|awk '{print $1 $4}'|sed -e 's/:/ /g'|sed -e 's/\[/ /g'|sed -e 's/\//-/g'|awk '{print $2 "," $1 ",VIS,EBS,US,EBS  Sandbox"}'>>$file_name
        done
fi