Oracle Application Database Monitoring Scripts R12

Monitoring Scrip Server

Oracle R12 Application Monitoring Scripts

Database Free Space And All Space on The Server

df -h

cd /d01/oracle/VIS/db/tech_st/11.1.0

echo "Set env in Database Tier"

. VIS_servername.env

sqlplus "/as sysdba"

echo "Total size of Database"

SELECT ROUND(SUM(bytes/1024/1024/1024)) FROM dba_data_files;

echo "Free size of database"

SELECT /*+ FIRST_ROWS*/ROUND(SUM(bytes/1024/1024/1024)) FROM dba_free_space;

echo "Total Blocking Session"

SELECT count(*) FROM v$lock WHERE BLOCK='1';

echo "Total Locked objects"

SELECT COUNT(*) FROM v$locked_object;

echo "Total no of session"

SELECT count(*) FROM v$session;

echo "Total no of Process"

SELECT COUNT (*) FROM v$process;

echo "Total no of concurrent Process"

SELECT COUNT(*) FROM fnd_concurrent_processes;

echo "Total no of concurrent request"

SELECT COUNT(*) FROM fnd_concurrent_requests;

echo "Running Concurrent Requests and scheduled Concurrent Requests"

SELECT phase_code,COUNT(*) FROM apps.fnd_concurrent_requests WHERE phase_code IN('P','R') GROUP BY phase_code ORDER BY 1 DESC;

echo "Last day total no. of concurrent requests"

SELECT sysdate -1 , count(*)
FROM apps.fnd_concurrent_requests
WHERE to_char(actual_completion_date,'YYYYMMDD') =
(SELECT to_char(sysdate -1,'YYYYMMDD') FROM dual);

echo "-----------------------------Database Size----------------------------------"

select tablespace_name,sum(bytes/1024/1024) from dba_data_files group by tablespace_name order by 1;

echo "------------------------------Database free Size----------------------------"

select tablespace_name,sum(bytes/1024/1024) from dba_free_space group by tablespace_name order by 1;

exit

ps -ef | grep frmweb |wc -l

 Done Monitoring Application Server R12



Regards
Goraknath Rathod