Difference between revisions of "Plugin:Oracle"
From collectd Wiki
(Created initial page.) |
m (→Description: Fix a grammatical incorrect sentence.) |
||
| Line 3: | Line 3: | ||
The <em>Oracle</em> interface uses the "Oracle call interface" (OCI) to connect to one or more Oracle database systems, execute SQL statements on them and read back the result. Depending on the configuration, the returned values are then converted into collectd "value lists" (the data structure used internally to pass statistics around). It is a very generic plugin, so reading [http://collectd.org/documentation/manpages/collectd.conf.5.shtml#plugin_oracle the collectd.conf(5) manpage] is a must. | The <em>Oracle</em> interface uses the "Oracle call interface" (OCI) to connect to one or more Oracle database systems, execute SQL statements on them and read back the result. Depending on the configuration, the returned values are then converted into collectd "value lists" (the data structure used internally to pass statistics around). It is a very generic plugin, so reading [http://collectd.org/documentation/manpages/collectd.conf.5.shtml#plugin_oracle the collectd.conf(5) manpage] is a must. | ||
| − | The configuration syntax of the <em>Oracle</em>, [[Plugin:DBI|DBI]], and [[Plugin:PostgreSQL|PostgreSQL]] plugins is very similar, because | + | The configuration syntax of the <em>Oracle</em>, [[Plugin:DBI|DBI]], and [[Plugin:PostgreSQL|PostgreSQL]] plugins is very similar, because the configuration of those plugins is handled by the same module. Also, we tried to keep the syntax similar to that of the [[Plugin:SNMP|SNMP]] plugin. So if you use any of those plugins already, most of the following will look familiar. |
= Synopsis = | = Synopsis = | ||
Revision as of 23:03, 26 February 2009
Description
The Oracle interface uses the "Oracle call interface" (OCI) to connect to one or more Oracle database systems, execute SQL statements on them and read back the result. Depending on the configuration, the returned values are then converted into collectd "value lists" (the data structure used internally to pass statistics around). It is a very generic plugin, so reading the collectd.conf(5) manpage is a must.
The configuration syntax of the Oracle, DBI, and PostgreSQL plugins is very similar, because the configuration of those plugins is handled by the same module. Also, we tried to keep the syntax similar to that of the SNMP plugin. So if you use any of those plugins already, most of the following will look familiar.
Synopsis
<Plugin oracle>
<Query "out_of_stock">
Statement "SELECT category, COUNT(*) AS value FROM products WHERE in_stock = 0 GROUP BY category"
<Result>
Type "gauge"
# InstancePrefix "foo"
InstancesFrom "category"
ValuesFrom "value"
</Result>
</Query>
<Database "product_information">
ConnectID "db01"
Username "oracle"
Password "secret"
Query "out_of_stock"
</Database>
</Plugin>
Example graph
None yet. Add one now!
Dependencies
- OCI
-
libclntsh
(An Oracle library with a mystic name. Should be part of OCI.)
