diff options
Diffstat (limited to 'collectors/python.d.plugin/oracledb/README.md')
| -rw-r--r-- | collectors/python.d.plugin/oracledb/README.md | 73 |
1 files changed, 37 insertions, 36 deletions
diff --git a/collectors/python.d.plugin/oracledb/README.md b/collectors/python.d.plugin/oracledb/README.md index 2e5972a05..708f261d9 100644 --- a/collectors/python.d.plugin/oracledb/README.md +++ b/collectors/python.d.plugin/oracledb/README.md @@ -3,46 +3,48 @@ Module monitor oracledb performance and health metrics. **Requirements:** - - `cx_Oracle` package. - - Oracle Client (using `cx_Oracle` requires Oracle Client libraries to be installed). + +- `cx_Oracle` package. +- Oracle Client (using `cx_Oracle` requires Oracle Client libraries to be installed). It produces following charts: - - session activity - - Session Count - - Session Limit Usage - - Logons - - disk activity - - Physical Disk Reads/Writes - - Sorts On Disk - - Full Table Scans - - database and buffer activity - - Database Wait Time Ratio - - Shared Pool Free Memory - - In-Memory Sorts Ratio - - SQL Service Response Time - - User Rollbacks - - Enqueue Timeouts - - cache - - Cache Hit Ratio - - Global Cache Blocks Events - - activities - - Activities - - wait time - - Wait Time - - tablespace - - Size - - Usage - - Usage In Percent - -### prerequisite + +- session activity + - Session Count + - Session Limit Usage + - Logons +- disk activity + - Physical Disk Reads/Writes + - Sorts On Disk + - Full Table Scans +- database and buffer activity + - Database Wait Time Ratio + - Shared Pool Free Memory + - In-Memory Sorts Ratio + - SQL Service Response Time + - User Rollbacks + - Enqueue Timeouts +- cache + - Cache Hit Ratio + - Global Cache Blocks Events +- activities + - Activities +- wait time + - Wait Time +- tablespace + - Size + - Usage + - Usage In Percent + +## prerequisite To use the Oracle module do the following: -1. Install `cx_Oracle` package ([link](https://cx-oracle.readthedocs.io/en/latest/installation.html#install-cx-oracle)). +1. Install `cx_Oracle` package ([link](https://cx-oracle.readthedocs.io/en/latest/installation.html#install-cx-oracle)). -2. Install Oracle Client libraries ([link](https://cx-oracle.readthedocs.io/en/latest/installation.html#install-oracle-client)). +2. Install Oracle Client libraries ([link](https://cx-oracle.readthedocs.io/en/latest/installation.html#install-oracle-client)). -3. Create a read-only netdata user with proper access to your Oracle Database Server. +3. Create a read-only `netdata` user with proper access to your Oracle Database Server. Connect to your Oracle database with an administrative user and execute: @@ -53,8 +55,7 @@ CREATE USER netdata IDENTIFIED BY <PASSWORD>; GRANT CONNECT TO netdata; GRANT SELECT_CATALOG_ROLE TO netdata; - -``` +``` ### configuration @@ -74,4 +75,4 @@ remote: All parameters are required. Without them module will fail to start. -[]() +[](<>) |