API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 15th, 2017
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 13.67 KB | None | 0 0
raw download clone embed print report
  1. these are snippets
  2. capsd-configuration.xml
  3.      <protocol-plugin protocol="Oracle-SQL-SCD" class-name="org.opennms.netmgt.capsd.plugins.JDBCQueryPlugin" scan="on" user-defined="false">
  4.         <property key="user"     value="opennms"/>
  5.         <property key="password" value="d0n0tus3"/>
  6.         <property key="driver"   value="oracle.jdbc.driver.OracleDriver"/>
  7.         <property key="retry"    value="1"/>
  8.         <property key="timeout"  value="5000"/>
  9.         <property key="url"      value="jdbc:oracle:thin:@OPENNMS_JDBC_HOSTNAME:1521:SCD"/>
  10.         <property key="query"    value="select * from dual"/>
  11.     </protocol-plugin>
  12.  
  13.  
  14. collectd-configuration.xml
  15.         <package name="oracle-scd-status">
  16.            <filter>IPADDR != '0.0.0.0'</filter>
  17.            <include-range begin="10.4.2.0" end="10.4.3.254"/>
  18.            <service name="Oracle-SQL-SCD" interval="300000"
  19.                    user-defined="false" status="on">
  20.                <parameter key="jdbc-collection" value="oracle-scd-status"/>
  21.                <parameter key="retry"      value="2"/>
  22.                <parameter key="timeout"    value="2000"/>
  23.                <parameter key="url"        value="jdbc:oracle:thin:@OPENNMS_JDBC_HOSTNAME:1521:SCD"/>
  24.                <parameter key="user"       value="opennms"/>
  25.                <parameter key="password"   value="d0n0tus3"/>
  26.                <parameter key="driver"     value="oracle.jdbc.driver.OracleDriver"/>
  27.            </service>
  28.         </package>
  29.        
  30.         <collector service="Oracle-SQL-SCD" class-name="org.opennms.netmgt.collectd.JdbcCollector"/>
  31.        
  32.  
  33.  poller-configuration.xml
  34.     <service name="Oracle-SQL-SCD" status="on" user-defined="false" interval="300000">
  35.       <parameter key="user" value="opennms" />
  36.       <parameter key="password" value="d0n0tus3" />
  37.       <parameter key="driver" value="oracle.jdbc.driver.OracleDriver" />
  38.       <parameter key="retry" value="1" />
  39.       <parameter key="timeout" value="5000" />
  40.       <parameter key="url" value="jdbc:oracle:thin:@OPENNMS_JDBC_HOSTNAME:1521:SCD" />
  41.       <parameter key="query" value="select * from dual;" />
  42.       <parameter key="service-name" value="Oracle-SQL-SCD" />
  43.     </service>
  44.     <monitor service="Oracle-SQL-SCD" class-name="org.opennms.netmgt.poller.monitors.JDBCQueryMonitor"/>
  45.    
  46.    
  47. jdbc-datacollection-config.xml
  48.     <jdbc-collection name="oracle-scd-status">
  49.         <rrd step="300">
  50.             <rra>RRA:AVERAGE:0.5:1:2016</rra>
  51.             <rra>RRA:AVERAGE:0.5:12:1488</rra>
  52.             <rra>RRA:AVERAGE:0.5:288:366</rra>
  53.             <rra>RRA:MAX:0.5:288:366</rra>
  54.             <rra>RRA:MIN:0.5:288:366</rra>
  55.         </rrd>
  56.         <queries>
  57.             <query name="oracle-tablespace-total-size" ifType="ignore" >
  58.                 <statement>
  59.                     <queryString>select sum(bytes/1073741824) from dba_data_files</queryString>
  60.                 </statement>
  61.                 <columns>
  62.                     <column name="SUM(BYTES/1073741824)" data-source-name="tablespacesize" alias="orcl.tblsp.size" type="GAUGE"/>
  63.                 </columns>
  64.             </query>
  65.             <query name="oracle-tablespace-free" ifType="ignore" >
  66.                 <statement>
  67.                     <queryString>select sum(bytes/1073741824) from dba_free_space</queryString>
  68.                 </statement>
  69.                 <columns>
  70.                     <column name="SUM(BYTES/1073741824)" data-source-name="tablespacefree" alias="orcl.tblsp.free" type="GAUGE"/>
  71.                 </columns>
  72.             </query>
  73.             <query name="oracle-tablespace-total-max" ifType="ignore" >
  74.                 <statement>
  75.                     <queryString>select sum(maxbytes/1073741824) from dba_data_files</queryString>
  76.                 </statement>
  77.                 <columns>
  78.                     <column name="SUM(MAXBYTES/1073741824)" data-source-name="tablespacemax" alias="orcl.tblsp.max" type="GAUGE"/>
  79.                 </columns>
  80.             </query>
  81.             <query name="oracle-sga-fixed" ifType="ignore" >
  82.                 <statement>
  83.                     <queryString>select bytes from v$sgainfo where upper(name) like '%FIXED SGA%'</queryString>
  84.                 </statement>
  85.                 <columns>
  86.                     <column name="BYTES" data-source-name="sgafixed" alias="orcl.sga.fx" type="GAUGE"/>
  87.                 </columns>
  88.             </query>
  89.             <query name="oracle-sga-redo" ifType="ignore" >
  90.                 <statement>
  91.                     <queryString>select bytes from v$sgainfo where upper(name) like '%REDO%'</queryString>
  92.                 </statement>
  93.                 <columns>
  94.                     <column name="BYTES" data-source-name="sgaredo" alias="orcl.sga.redo" type="GAUGE"/>
  95.                 </columns>
  96.             </query>
  97.             <query name="oracle-sga-buff-cache" ifType="ignore" >
  98.                 <statement>
  99.                     <queryString>select bytes from v$sgainfo where upper(name) like '%BUFFER CACHE%'</queryString>
  100.                 </statement>
  101.                 <columns>
  102.                     <column name="BYTES" data-source-name="sgabcache" alias="orcl.sga.bcache" type="GAUGE"/>
  103.                 </columns>
  104.             </query>
  105.             <query name="oracle-sga-sharedpool" ifType="ignore" >
  106.                 <statement>
  107.                     <queryString>select bytes from v$sgainfo where upper(name) like '%SHARED POOL SIZE%'</queryString>
  108.                 </statement>
  109.                 <columns>
  110.                     <column name="BYTES" data-source-name="sgaspool" alias="orcl.sga.spool" type="GAUGE"/>
  111.                 </columns>
  112.             </query>
  113.             <query name="oracle-sga-largepool" ifType="ignore" >
  114.                 <statement>
  115.                     <queryString>select bytes from v$sgainfo where upper(name) like '%LARGE%'</queryString>
  116.                 </statement>
  117.                 <columns>
  118.                     <column name="BYTES" data-source-name="sgalpool" alias="orcl.sga.lpool" type="GAUGE"/>
  119.                 </columns>
  120.             </query>
  121.             <query name="oracle-sga-javapool" ifType="ignore" >
  122.                 <statement>
  123.                     <queryString>select bytes from v$sgainfo where upper(name) like '%JAVA%'</queryString>
  124.                 </statement>
  125.                 <columns>
  126.                     <column name="BYTES" data-source-name="sgajpool" alias="orcl.sga.jpool" type="GAUGE"/>
  127.                 </columns>
  128.             </query>
  129.             <query name="oracle-sga-streamspool" ifType="ignore" >
  130.                 <statement>
  131.                     <queryString>select bytes from v$sgainfo where upper(name) like '%STREAMS%'</queryString>
  132.                 </statement>
  133.                 <columns>
  134.                     <column name="BYTES" data-source-name="sgastrmpool" alias="orcl.sga.strmpool" type="GAUGE"/>
  135.                 </columns>
  136.             </query>
  137.             <query name="oracle-sga-granule" ifType="ignore" >
  138.                 <statement>
  139.                     <queryString>select bytes from v$sgainfo where upper(name) like '%GRANULE%'</queryString>
  140.                 </statement>
  141.                 <columns>
  142.                     <column name="BYTES" data-source-name="sgagranule" alias="orcl.sga.granule" type="GAUGE"/>
  143.                 </columns>
  144.             </query>
  145.             <query name="oracle-sga-max" ifType="ignore" >
  146.                 <statement>
  147.                     <queryString>select bytes from v$sgainfo where upper(name) like '%MAXIMUM SGA%'</queryString>
  148.                 </statement>
  149.                 <columns>
  150.                     <column name="BYTES" data-source-name="sgamax" alias="orcl.sga.max" type="GAUGE"/>
  151.                 </columns>
  152.             </query>
  153.             <query name="oracle-sga-overhead" ifType="ignore" >
  154.                 <statement>
  155.                     <queryString>select bytes from v$sgainfo where upper(name) like '%OVERHEAD%'</queryString>
  156.                 </statement>
  157.                 <columns>
  158.                     <column name="BYTES" data-source-name="sgaspooloverhead" alias="orcl.sga.spool.overhead" type="GAUGE"/>
  159.                 </columns>
  160.             </query>
  161.             <query name="oracle-sga-numa" ifType="ignore" >
  162.                 <statement>
  163.                     <queryString>select bytes from v$sgainfo where upper(name) like '%NUMA%'</queryString>
  164.                 </statement>
  165.                 <columns>
  166.                     <column name="BYTES" data-source-name="sganuma" alias="orcl.sga.spool.numa" type="GAUGE"/>
  167.                 </columns>
  168.             </query>
  169.             <query name="oracle-sga-free" ifType="ignore" >
  170.                 <statement>
  171.                     <queryString>select bytes from v$sgainfo where upper(name) like '%FREE SGA%'</queryString>
  172.                 </statement>
  173.                 <columns>
  174.                     <column name="BYTES" data-source-name="sgafree" alias="orcl.sga.free" type="GAUGE"/>
  175.                 </columns>
  176.             </query>
  177.             <query name="oracle-session-active" ifType="ignore" >
  178.                 <statement>
  179.                     <queryString>select count(*) from v$session  where upper(status)='ACTIVE' and username is not null</queryString>
  180.                 </statement>
  181.                 <columns>
  182.                     <column name="COUNT(*)" data-source-name="sessionactive" alias="orcl.sess.active" type="GAUGE"/>
  183.                 </columns>
  184.             </query>
  185.             <query name="oracle-session-zombie" ifType="ignore" >
  186.                 <statement>
  187.                     <queryString>select count(*) from v$session  where username is null</queryString>
  188.                 </statement>
  189.                 <columns>
  190.                     <column name="COUNT(*)" data-source-name="sessionzombie" alias="orcl.sess.zombie" type="GAUGE"/>
  191.                 </columns>
  192.             </query>
  193.             <query name="oracle-session-inactive" ifType="ignore" >
  194.                 <statement>
  195.                     <queryString>select count(*) from v$session  where upper(status)='INACTIVE' and username is not null</queryString>
  196.                 </statement>
  197.                 <columns>
  198.                     <column name="COUNT(*)" data-source-name="sessioninactive" alias="orcl.sess.inactive" type="GAUGE"/>
  199.                 </columns>
  200.             </query>
  201.             <query name="oracle-session-cached" ifType="ignore" >
  202.                 <statement>
  203.                     <queryString>select count(*) from v$session  where upper(status)='CACHED' and username is not null</queryString>
  204.                 </statement>
  205.                 <columns>
  206.                     <column name="COUNT(*)" data-source-name="sessioncached" alias="orcl.sess.cached" type="GAUGE"/>
  207.                 </columns>
  208.             </query>
  209.             <query name="oracle-session-killed" ifType="ignore" >
  210.                 <statement>
  211.                     <queryString>select count(*) from v$session  where upper(status)='KILLED' and username is not null</queryString>
  212.                 </statement>
  213.                 <columns>
  214.                     <column name="COUNT(*)" data-source-name="sessionkilled" alias="orcl.sess.killed" type="GAUGE"/>
  215.                 </columns>
  216.             </query>
  217.             <query name="oracle-session-sniped" ifType="ignore" >
  218.                 <statement>
  219.                     <queryString>select count(*) from v$session  where upper(status)='SNIPED' and username is not null</queryString>
  220.                 </statement>
  221.                 <columns>
  222.                     <column name="COUNT(*)" data-source-name="sessionsniped" alias="orcl.sess.sniped" type="GAUGE"/>
  223.                 </columns>
  224.             </query>
  225.             <query name="oracle-locks-rowshare" ifType="ignore" >
  226.                 <statement>
  227.                     <queryString>select count(*) from dba_lock where upper(mode_held) like '%(SS)%'</queryString>
  228.                 </statement>
  229.                 <columns>
  230.                     <column name="COUNT(*)" data-source-name="locksrowshare" alias="orcl.locks.rowshare" type="GAUGE"/>
  231.                 </columns>
  232.             </query>
  233.             <query name="oracle-locks-rowexcl" ifType="ignore" >
  234.                 <statement>
  235.                     <queryString>select count(*) from dba_lock where upper(mode_held) like '%(SX)%'</queryString>
  236.                 </statement>
  237.                 <columns>
  238.                     <column name="COUNT(*)" data-source-name="locksrowexcl" alias="orcl.locks.rowexcl" type="GAUGE"/>
  239.                 </columns>
  240.             </query>
  241.             <query name="oracle-locks-share" ifType="ignore" >
  242.                 <statement>
  243.                     <queryString>select count(*) from dba_lock where upper(mode_held) like '%(S)%'</queryString>
  244.                 </statement>
  245.                 <columns>
  246.                     <column name="COUNT(*)" data-source-name="locksshare" alias="orcl.locks.share" type="GAUGE"/>
  247.                 </columns>
  248.             </query>
  249.             <query name="oracle-locks-excl" ifType="ignore" >
  250.                 <statement>
  251.                     <queryString>select count(*) from dba_lock where upper(mode_held) like '%(SSX)%'</queryString>
  252.                 </statement>
  253.                 <columns>
  254.                     <column name="COUNT(*)" data-source-name="locksexcl" alias="orcl.locks.excl" type="GAUGE"/>
  255.                 </columns>
  256.             </query>
  257.             <query name="oracle-locks-none" ifType="ignore" >
  258.                 <statement>
  259.                     <queryString>select count(*) from dba_lock where upper(mode_held) like '%NULL%'</queryString>
  260.                 </statement>
  261.                 <columns>
  262.                     <column name="COUNT(*)" data-source-name="locksnone" alias="orcl.locks.none" type="GAUGE"/>
  263.                 </columns>
  264.             </query>
  265.         </queries>
  266.     </jdbc-collection>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!