Differences

This shows you the differences between two versions of the page.

--- check_remote_oracle [2013/10/10 17:03] – [Testing] dodger
+++ oracle:check_remote_oracle [2018/04/27 08:55] – dodger
@@ Line 1: / Line 1: @@
+====== [SCRIPT] Nagios check plugin for oracle ======
 ====== Description ======
 Script used as plugin for Nagios to remotely check Oracle.
@@ Line 26: / Line 28: @@
 grant CONNECT, SELECT_CATALOG_ROLE to "NAGIOS" ;
 </code>
+Control specific grants:
+  * SGA:
+<code sql>
+GRANT SELECT ON SYS.V_$SGASTAT TO VOXELADMIN ;
+</code>
 For a better understand of the usage, this script will do something like:
@@ Line 176: / Line 186: @@
 <code SQL>
 SELECT * FROM V$DATAGUARD_STATS WHERE NAME LIKE '%lag' ;
+</code>
+==== --redogen ====
+Daily REDO generation statistics.
+Something like that:
+<code SQL>
+SELECT A.DAY, Round(A.COUNT#*B.AVG#/1024/1024) Daily_Avg_Mb
+FROM
+    (
+    SELECT To_Char(First_Time,'YYYY-MM-DD') DAY, COUNT(1) COUNT#, MIN(RECID) MIN#, MAX(RECID) MAX#
+    FROM v$log_history
+    GROUP BY To_Char(First_Time,'YYYY-MM-DD')
+    ORDER BY 1 DESC
+    ) A,
+    (
+    SELECT Avg(BYTES) AVG#
+    FROM v$log
+    ) B
+    ORDER BY DAY
+/
 </code>