AIX Oracle
AIX Oracle input executes SQL through sqlplus to collect database status, sessions, tablespaces, ASM, FRA, wait events, and advanced metrics.
Configuration¶
[inputs]
# Global switch for middleware inputs.
enabled = true
[[inputs.oracle]]
# Instance name, reported as the `instance` tag.
name = "orcl"
# Whether to enable this Oracle instance collection.
enabled = true
# Collection interval.
interval = "60s"
# Optional file loaded before collection to set instance environment variables.
env_file = ""
# Whether to collect advanced metrics such as DataGuard, instance information, and invalid objects.
collect_advanced = false
# Optional custom metric command. Each output line should be `key=value`.
deep_metrics_command = ""
# Oracle environment and connection information.
oracle_home = "/u01/app/oracle/product/19c/dbhome_1"
oracle_sid = "ORCL"
sqlplus = "/u01/app/oracle/product/19c/dbhome_1/bin/sqlplus"
user = "datakitaix"
# Password is read from an environment variable and is not written to the configuration file.
password_env = "DATAKITAIX_ORACLE_PASSWORD"
If user is empty, connect / as sysdba is used. Otherwise, the password is read from the environment variable specified by password_env.
Command Dependencies¶
| Command | Description |
|---|---|
sqlplus -s /nolog |
Execute Oracle SQL. |
deep_metrics_command |
Custom command that outputs key=value lines for custom metrics. |
Metrics¶
All metrics append host, input=oracle, and instance=<name> tags.
oracle¶
| Tags & Fields | Description |
|---|---|
| oracle_sid ( tag) |
Oracle SID. |
| open_mode ( tag) |
Database open mode. |
| up | Whether SQL execution succeeded. Type: int | (gauge) |
| open | Whether the database is in READ WRITE or READ ONLY mode. Type: int | (gauge) |
| sessions | Current session count. Type: float/int | (gauge) Unit: count |
| processes | Current process count. Type: float/int | (gauge) Unit: count |
| archive_errors | Archive destination error count. Type: float/int | (gauge) Unit: count |
| redo_log_groups | redo log group count. Type: float/int | (gauge) Unit: count |
oracle_tablespace¶
| Tags & Fields | Description |
|---|---|
| oracle_sid ( tag) |
Oracle SID. |
| tablespace ( tag) |
Tablespace name. |
| used_pct | Tablespace usage percentage. Type: float | (gauge) Unit: percent |
oracle_asm_diskgroup¶
| Tags & Fields | Description |
|---|---|
| diskgroup ( tag) |
ASM diskgroup name. |
| total_mb | Total capacity. Type: float | (gauge) Unit: MB |
| free_mb | Free capacity. Type: float | (gauge) Unit: MB |
| used_pct | Usage percentage. Type: float | (gauge) Unit: percent |
oracle_recovery_area¶
| Tags & Fields | Description |
|---|---|
| area ( tag) |
FRA name, defaulting to default. |
| space_limit_mb | FRA limit. Type: float/int | (gauge) Unit: MB |
| space_used_mb | FRA used space. Type: float/int | (gauge) Unit: MB |
| reclaimable_mb | Reclaimable space. Type: float/int | (gauge) Unit: MB |
| used_pct | Usage percentage. Type: float/int | (gauge) Unit: percent |
oracle_wait_class¶
| Tags & Fields | Description |
|---|---|
| wait_class ( tag) |
Wait class. |
| waits | Wait count. Type: int | (count) Unit: count |
| time_waited_cs | Wait time in centiseconds. Type: int | (count) Unit: cs |
oracle_datafile_status¶
| Tags & Fields | Description |
|---|---|
| status ( tag) |
datafile state. |
| count | Number of data files in the corresponding status. Type: int | (gauge) Unit: count |
oracle_dataguard¶
| Tags & Fields | Description |
|---|---|
| oracle_sid ( tag) |
Oracle SID. |
| name ( tag) |
DataGuard metric name. |
| unit ( tag) |
Metric unit. |
| value | Numeric DataGuard metric value. Type: int/float | (gauge) |
| value_seconds | DataGuard interval metric value. Type: float | (gauge) Unit: second |
| count | Placeholder for non-numeric DataGuard metrics. Type: int | (gauge) Unit: count |
oracle_instance¶
| Tags & Fields | Description |
|---|---|
| oracle_sid ( tag) |
Oracle SID. |
| instance ( tag) |
RAC/GV$INSTANCE instance name. |
| host ( tag) |
Host where the instance runs. |
| status ( tag) |
Instance status. |
| parallel ( tag) |
Instance parallel state. |
| up | Whether the instance status is OPEN. Type: int | (gauge) |
oracle_invalid_objects¶
| Tags & Fields | Description |
|---|---|
| oracle_sid ( tag) |
Oracle SID. |
| owner ( tag) |
Object owner. |
| count | Number of non-VALID objects. Type: int/float | (gauge) Unit: count |
Custom Metrics¶
Custom metric fields are determined by deep_metrics_command output. Fields listed in the table are used as tags; numeric values in other key=value pairs are reported as int/float | (gauge) fields, and non-numeric values are reported as tags. If no numeric field exists, count=1 is added with unit count.
| Measurement | Tags | Description |
|---|---|---|
oracle_awr_metric |
metric, unit, oracle_sid |
Custom AWR metrics. |
oracle_ash_wait |
event, wait_class, oracle_sid |
Custom ASH wait metrics. |
oracle_sql |
sql_id, module, schema, oracle_sid |
Custom SQL metrics. |
oracle_segment |
segment, owner, segment_type, tablespace, oracle_sid |
Custom segment metrics. |
oracle_deep_metric |
metric, unit, oracle_sid |
Generic Oracle custom metrics. |