oracle daily check script

select 1-(phy.value/(cur.value+con.value)) "data_buffer"
from v$sysstat cur,v$sysstat con,v$sysstat phy
where cur.name='db block gets'
and   con.name='consistent gets'
and   phy.name='physical reads';
~

select 1-((SELECT value FROM v$sysstat WHERE name ='redo buffer allocation retri
es')/(SELECT value FROM v$sysstat WHERE name ='redo entries')) as "LogBuffer"
from dual;

select max(sequence#) from v$log_history;

select f.tablespace_name,a.total||'M' TOTAL,u.used||'M' USED,f.free||'M' FREE,ro
und((u.used/a.total)*100) "% used",round((f.free/a.total)*100) "% Free" from
(select tablespace_name, sum(bytes/(1024*1024)) total from dba_data_files group
by tablespace_name) a,
(select tablespace_name, round(sum(bytes/(1024*1024))) used from dba_extents gro
up by tablespace_name) u,
(select tablespace_name, round(sum(bytes/(1024*1024))) free from dba_free_space
group by tablespace_name) f
WHERE a.tablespace_name = f.tablespace_name
and a.tablespace_name = u.tablespace_name
order by 5;

select sysdate "Date grow ",
sum(bytes)/1024/1024/(to_number(to_char(sysdate,'dd'))) "Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-1;

select sum(pins) "shared pool",
       sum(reloads) "Cache Misses",
       (1-sum(reloads)/sum(pins))*100 "Ratio"
from v$librarycache;

select f.tablespace_name,a.total||'M' TOTAL,u.used||'M' USED,f.free||'M' FREE,ro
und((u.used/a.total)*100) "% used",round((f.free/a.total)*100) "% Free" from
(select tablespace_name, sum(bytes/(1024*1024)) total from dba_data_files group
by tablespace_name) a,
(select tablespace_name, round(sum(bytes/(1024*1024))) used from dba_extents gro
up by tablespace_name) u,
(select tablespace_name, round(sum(bytes/(1024*1024))) free from dba_free_space
group by tablespace_name) f
WHERE a.tablespace_name = f.tablespace_name
and a.tablespace_name = u.tablespace_name
order by 5;

select count(*), 1-(sum(waits)/sum(gets)) "rollback"
from sys.v_$rollstat;

sqlplus '/as sysdba' <<EOF1
@/dbmpe/daily_check/data_buffer.sql;
@/dbmpe/daily_check/rollback.sql;
@/dbmpe/daily_check/shared_pool.sql;
@/dbmpe/daily_check/log_buffer.sql;
@/dbmpe/daily_check/data_grow.sql;
@/dbmpe/daily_check/log_buffer.sql;
@/dbmpe/daily_check/Standby.sql;
@/dbmpe/daily_check/tablespace.sql;
exit;
EOF1
bdf
uptime
SELECT se.sid,se.serial#,pr.SPID,se.username,se.status,se.terminal,se.program,se.MODULE,、se.sql_address,st.event,st.p1text,si.physical_reads,si.block_changes FROM v$session se,v$session_wait st,v$sess_io si,v$process pr WHERE st.sid=se.sid AND st.sid=si.sid AND se.PADDR=pr.ADDR AND se.sid>6 AND st.wait_time=0 AND st.event NOT LIKE '%SQL%' ORDER BY physical_reads DESC