Oracle

Collect Oracle Audit Log, Performance metrics, Tablespace metrics, Sysmetrics metrics, System statistics metrics, memory metrics from Oracle database.

What is an Elastic integration?


Version	1.25.0 (View all)
Compatible Kibana version(s)	8.10.2 or higher
Supported Serverless project types What's this?	Security Observability
Subscription level What's this?	Basic
Level of support What's this?	Elastic

This integration is for ingesting Audit Trail logs and fetching performance, tablespace and sysmetric metrics from Oracle Databases.

The integration expects an *.aud audit file that is generated from Oracle Databases by default. If this has been disabled then please see the Oracle Database Audit Trail Documentation.

Requirements

Connectivity to Oracle can be facilitated in two ways either by using official Oracle libraries or by using a JDBC driver. Facilitation of the connectivity using JDBC is not supported currently with Metricbeat. Connectivity can be facilitated using Oracle libraries and the detailed steps to do the same are mentioned below.

Oracle Database Connection Pre-requisites

To get connected with the Oracle Database ORACLE_SID, ORACLE_BASE, ORACLE_HOME environment variables should be set.

For example: Let’s consider Oracle Database 21c installation using RPM manually by following the Oracle Installation instructions. Environment variables should be set as follows: ORACLE_SID=ORCLCDB ORACLE_BASE=/opt/oracle/oradata ORACLE_HOME=/opt/oracle/product/21c/dbhome_1 Also, add $ORACLE_HOME/bin to the PATH environment variable.

Oracle Instant Client

Oracle Instant Client enables development and deployment of applications that connect to Oracle Database. The Instant Client libraries provide the necessary network connectivity and advanced data features to make full use of Oracle Database. If you have OCI Oracle server which comes with these libraries pre-installed, you don't need a separate client installation.

The OCI library install few Client Shared Libraries that must be referenced on the machine where Metricbeat is installed. Please follow the Oracle Client Installation link link for OCI Instant Client set up. The OCI Instant Client is available with the Oracle Universal Installer, RPM file or ZIP file. Download links can be found at the Oracle Instant Client Download page.

If Elastic Agent is running as a systemd service and not using ldconfig is an option, to update the links to the shared libraries, you can use the LD_LIBRARY_PATH environment variable instead. Follow these steps to ensure Elastic Agent and its spawned processes respect the LD_LIBRARY_PATH environment variable.

Prerequisites: Ensure that you have administrative privileges to modify the Elastic Agent systemd service configuration.

Steps:

Check the status of the Elastic Agent systemd service by running the following command: systemctl status elastic-agent.service Take note of the path to the elastic-agent.service file, which is typically located in the systemd service directory. Example path: /etc/systemd/system/elastic-agent.service
Open the elastic-agent.service file in your preferred text editor, find the EnvironmentFile key (commonly found at /etc/sysconfig/elastic-agent), and verify its contents, as these configurations are essential for the elastic-agent's runtime environment initialization. If the EnvironmentFile is absent, create it and set the necessary permissions to ensure the elastic-agent has full access.
Add the LD_LIBRARY_PATH environment variable to the configured EnvironmentFile. You can set it to the directory where libraries (libclntsh.so) are located. For example, if your libraries are in the /opt/oracle/instantclient_21_1 directory, add the following line to the EnvironmentFile (i.e. /etc/systemd/system/elastic-agent.service)

LD_LIBRARY_PATH=/opt/oracle/instantclient_21_1
Save the changes made to the configured EnvironmentFile.
Restart the Elastic Agent systemd service to apply the changes by running the following command:

systemctl restart elastic-agent.service

Note: Ensure that you replace /opt/oracle/instantclient_21_1 with the actual path to the directory where the required libraries (libclntsh.so) are located. This will set the library search path for the Elastic Agent service to include the specified directory, allowing it to locate the required libraries.

Enable Listener

The Oracle listener is a service that runs on the database host and receives requests from Oracle clients. Make sure that Listener is be running. To check if the listener is running or not, run:

lsnrctl STATUS

If the listener is not running, use the command to start:

lsnrctl START

Then, Metricbeat can be launched.

Oracle DSN Configuration

The following two configuration formats are supported:

oracle://<user>:<password>@<connection_string>
user="<user>" password="<password>" connectString="<connection_string>" sysdba=<true|false>

Example values are:

oracle://sys:Oradoc_db1@0.0.0.0:1521/ORCLCDB.localdomain?sysdba=1
user="sys" password="Oradoc_db1" connectString="0.0.0.0:1521/ORCLCDB.localdomain" sysdba=true

In the first, URL-based format, special characters should be URL encoded.

In the seoncd, logfmt-encoded DSN format, if the password contains a backslash character (\), it must be escaped with another backslash. For example, if the password is my\_password, it must be written as my\\_password.

Compatibility

This integration has been tested with Oracle Database 19c, and should work for 18c as well though it has not been tested.

Audit Log

The database_audit dataset collects Oracle Audit logs.

Exported fields

Field	Description	Type
@timestamp	Event timestamp.	date
client.address	Some event client addresses are defined ambiguously. The event will sometimes list an IP, a domain or a unix socket. You should always store the raw address in the `.address` field. Then it should be duplicated to `.ip` or `.domain`, depending on which one it is.	keyword
client.domain	The domain name of the client system. This value may be a host name, a fully qualified domain name, or another host naming format. The value may derive from the original event or be added from enrichment.	keyword
client.ip	IP address of the client (IPv4 or IPv6).	ip
client.user.id	Unique identifier of the user.	keyword
client.user.name	Short name or login of the user.	keyword
client.user.name.text	Multi-field of `client.user.name`.	match_only_text
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host is running.	keyword
cloud.image.id	Image ID for the cloud instance.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.instance.name	Instance name of the host machine.	keyword
cloud.machine.type	Machine type of the host machine.	keyword
cloud.project.id	Name of the project in Google Cloud.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host is running.	keyword
container.id	Unique container id.	keyword
container.image.name	Name of the image the container was built on.	keyword
container.labels	Image labels.	object
container.name	Container name.	keyword
data_stream.dataset	Data stream dataset.	constant_keyword
data_stream.namespace	Data stream namespace.	constant_keyword
data_stream.type	Data stream type.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
error.message	Error message.	match_only_text
event.action	The action captured by the event. This describes the information in the event. It is more specific than `event.category`. Examples are `group-add`, `process-started`, `file-created`. The value is normally defined by the implementer.	keyword
event.category	This is one of four ECS Categorization Fields, and indicates the second level in the ECS category hierarchy. `event.category` represents the "big buckets" of ECS categories. For example, filtering on `event.category:process` yields all events relating to process activity. This field is closely related to `event.type`, which is used as a subcategory. This field is an array. This will allow proper categorization of some events that fall in multiple categories.	keyword
event.dataset	Event dataset	constant_keyword
event.ingested	Timestamp when an event arrived in the central data store. This is different from `@timestamp`, which is when the event originally occurred. It's also different from `event.created`, which is meant to capture the first time an agent saw the event. In normal conditions, assuming no tampering, the timestamps should chronologically look like this: `@timestamp` < `event.created` < `event.ingested`.	date
event.kind	This is one of four ECS Categorization Fields, and indicates the highest level in the ECS category hierarchy. `event.kind` gives high-level information about what type of information the event contains, without being specific to the contents of the event. For example, values of this field distinguish alert events from metric events. The value of this field can be used to inform how these kinds of events should be handled. They may warrant different retention, different access control, it may also help understand whether the data coming in at a regular interval or not.	keyword
event.module	Event module	constant_keyword
event.original	Raw text message of entire event. Used to demonstrate log integrity or where the full log message (before splitting it up in multiple parts) may be required, e.g. for reindex. This field is not indexed and doc_values are disabled. It cannot be searched, but it can be retrieved from `_source`. If users wish to override this and index this field, please see `Field data types` in the `Elasticsearch Reference`.	keyword
event.outcome	This is one of four ECS Categorization Fields, and indicates the lowest level in the ECS category hierarchy. `event.outcome` simply denotes whether the event represents a success or a failure from the perspective of the entity that produced the event. Note that when a single transaction is described in multiple events, each event may populate different values of `event.outcome`, according to their perspective. Also note that in the case of a compound event (a single event that contains multiple logical events), this field should be populated with the value that best captures the overall success or failure from the perspective of the event producer. Further note that not all events will have an associated outcome. For example, this field is generally not populated for metric events, events with `event.type:info`, or any events for which an outcome does not make logical sense.	keyword
event.type	This is one of four ECS Categorization Fields, and indicates the third level in the ECS category hierarchy. `event.type` represents a categorization "sub-bucket" that, when used along with the `event.category` field values, enables filtering events down to a level appropriate for single visualization. This field is an array. This will allow proper categorization of some events that fall in multiple event types.	keyword
host.architecture	Operating system architecture.	keyword
host.containerized	If the host is a container.	boolean
host.domain	Name of the domain of which the host is a member. For example, on Windows this could be the host's Active Directory domain or NetBIOS domain name. For Linux this could be the domain of the host's LDAP provider.	keyword
host.hostname	Hostname of the host. It normally contains what the `hostname` command returns on the host machine.	keyword
host.id	Unique host id. As hostname is not always unique, use values that are meaningful in your environment. Example: The current usage of `beat.name`.	keyword
host.ip	Host ip addresses.	ip
host.mac	Host mac addresses.	keyword
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
host.os.build	OS build information.	keyword
host.os.codename	OS codename, if any.	keyword
host.os.family	OS family (such as redhat, debian, freebsd, windows).	keyword
host.os.kernel	Operating system kernel version as a raw string.	keyword
host.os.name	Operating system name, without the version.	keyword
host.os.name.text	Multi-field of `host.os.name`.	text
host.os.platform	Operating system platform (such centos, ubuntu, windows).	keyword
host.os.version	Operating system version as a raw string.	keyword
host.type	Type of host. For Cloud providers this can be the machine type like `t2.medium`. If vm, this could be the container, for example, or other information meaningful in your environment.	keyword
input.type	Input type	keyword
log.file.device_id	ID of the device containing the filesystem where the file resides.	keyword
log.file.fingerprint	The sha256 fingerprint identity of the file when fingerprinting is enabled.	keyword
log.file.idxhi	The high-order part of a unique identifier that is associated with a file. (Windows-only)	keyword
log.file.idxlo	The low-order part of a unique identifier that is associated with a file. (Windows-only)	keyword
log.file.inode	Inode number of the log file.	keyword
log.file.path	Full path to the log file this event came from, including the file name. It should include the drive letter, when appropriate. If the event wasn't read from a log file, do not populate this field.	keyword
log.file.vol	The serial number of the volume that contains a file. (Windows-only)	keyword
log.flags	related log flags
log.offset	Log offset	long
message	human-readable summary of the event	text
oracle.database_audit.action	The action performed during the audit event. This could for example be the raw query.	keyword
oracle.database_audit.action_number	Action is a numeric value representing the action the user performed. The corresponding name of the action type is in the AUDIT_ACTIONS table. For example, action 100 refers to LOGON.	keyword
oracle.database_audit.client.address	The IP Address or Domain used by the client.	keyword
oracle.database_audit.client.terminal	If available, the client terminal type, for example "pty".	keyword
oracle.database_audit.client.user	The user running the client or connection to the database.	keyword
oracle.database_audit.comment_text	Additional comments about the related audit record.	text
oracle.database_audit.database.host	Client host machine name.	keyword
oracle.database_audit.database.id	Database identifier calculated when the database is created. It corresponds to the DBID column of the V$DATABASE data dictionary view.	keyword
oracle.database_audit.database.user	The database user used to authenticate.	keyword
oracle.database_audit.entry.id	Indicates the current audit entry number, assigned to each audit trail record. The audit entry.id sequence number is shared between fine-grained audit records and regular audit records.	long
oracle.database_audit.length	Refers to the total number of bytes used in this audit record. This number includes the trailing newline bytes (\n), if any, at the end of the audit record.	long
oracle.database_audit.obj_creator	The owner of the object, equivalent field in DBA_AUDIT_Trail is OWNER.	keyword
oracle.database_audit.obj_name	The name of the object.	keyword
oracle.database_audit.os_userid	The related OS user.	keyword
oracle.database_audit.privilege	The privilege group related to the database user.	keyword
oracle.database_audit.returncode	Indicates if the audited action was successful. 0 indicates success. If the action fails, the return code lists the Oracle Database error number.	keyword
oracle.database_audit.ses_actions	Defines the type of action performed using 12 characters, each position indicates the result of an action. They are: ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, and FLASHBACK.	keyword
oracle.database_audit.ses_tid	The ID of the object related to the audit event.	keyword
oracle.database_audit.session_id	Indicates the audit session ID number.	keyword
oracle.database_audit.statement	The statement ID related to the audit event.	keyword
oracle.database_audit.status	Database Audit Status.	keyword
oracle.database_audit.terminal	The terminal identifier.	keyword
process.pid	Process id.	long
related.hosts	All hostnames or other host identifiers seen on your event. Example identifiers include FQDNs, domain names, workstation names, or aliases.	keyword
related.ip	All of the IPs seen on your event.	ip
related.user	All the user names or other user identifiers seen on the event.	keyword
server.address	Some event server addresses are defined ambiguously. The event will sometimes list an IP, a domain or a unix socket. You should always store the raw address in the `.address` field. Then it should be duplicated to `.ip` or `.domain`, depending on which one it is.	keyword
server.domain	The domain name of the server system. This value may be a host name, a fully qualified domain name, or another host naming format. The value may derive from the original event or be added from enrichment.	keyword
server.ip	IP address of the server (IPv4 or IPv6).	ip
server.user.name	Short name or login of the user.	keyword
server.user.name.text	Multi-field of `server.user.name`.	match_only_text
tags	List of keywords used to tag each event.	keyword
user.name	Short name or login of the user.	keyword
user.name.text	Multi-field of `user.name`.	match_only_text
user.roles	Array of user roles at the time of the event.	keyword
user.target.domain	Name of the directory the user is a member of. For example, an LDAP or Active Directory domain name.	keyword
user.target.name	Short name or login of the user.	keyword
user.target.name.text	Multi-field of `user.target.name`.	match_only_text

An example event for database_audit looks as following:

{
    "@timestamp": "2020-10-07T14:57:51.000Z",
    "agent": {
        "ephemeral_id": "c8ada4ef-14e4-462f-b998-dd8c711b4ec7",
        "id": "50560b92-4232-4158-b79d-9e6be7098c58",
        "name": "docker-fleet-agent",
        "type": "filebeat",
        "version": "8.10.2"
    },
    "client": {
        "user": {
            "name": "oracle"
        }
    },
    "data_stream": {
        "dataset": "oracle.database_audit",
        "namespace": "ep",
        "type": "logs"
    },
    "ecs": {
        "version": "8.6.0"
    },
    "elastic_agent": {
        "id": "50560b92-4232-4158-b79d-9e6be7098c58",
        "snapshot": false,
        "version": "8.10.2"
    },
    "event": {
        "action": "database_audit",
        "agent_id_status": "verified",
        "category": [
            "database"
        ],
        "dataset": "oracle.database_audit",
        "ingested": "2023-10-05T12:18:05Z",
        "kind": "event",
        "outcome": "success",
        "timezone": "-04:00",
        "type": [
            "access"
        ]
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-fleet-agent",
        "id": "efe661d97f0c4d9883075c393da6b0d8",
        "ip": [
            "172.28.0.7"
        ],
        "mac": [
            "02-42-AC-1C-00-07"
        ],
        "name": "docker-fleet-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.15.90.1-microsoft-standard-WSL2",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.6 LTS (Focal Fossa)"
        }
    },
    "input": {
        "type": "filestream"
    },
    "log": {
        "file": {
            "device_id": 2080,
            "inode": 827222,
            "path": "/tmp/service_logs/ORCLCDB_ora_13765_20201007105751904399925443.aud.log"
        },
        "flags": [
            "multiline"
        ],
        "offset": 858
    },
    "oracle": {
        "database_audit": {
            "action": "CONNECT",
            "action_number": "100",
            "client": {
                "terminal": "pts/0"
            },
            "length": 253,
            "session_id": "4294967295",
            "status": "0"
        }
    },
    "process": {
        "pid": 13765
    },
    "related": {
        "hosts": [
            "testlab.local"
        ],
        "user": [
            "/",
            "oracle"
        ]
    },
    "server": {
        "address": "testlab.local",
        "domain": "testlab.local",
        "user": {
            "name": "/"
        }
    },
    "tags": [
        "oracle-database_audit"
    ],
    "user": {
        "roles": [
            "SYSDBA"
        ]
    }
}

Tablespace Metrics

Tablespace metrics describes the tablespace usage metrics of all types of tablespaces in the oracle database.

To collect the Tablespace metrics, Oracle integration relies on a specific set of views. Make sure that the user configured within the Oracle DSN configuration has READ access permissions to the following views:

SYS.DBA_DATA_FILES
SYS.DBA_TEMP_FILES
DBA_FREE_SPACE

Exported fields

Field	Description	Type	Unit	Metric Type
@timestamp	Event timestamp.	date
agent.id	Unique identifier of this agent (if one exists). Example: For Beats this would be beat.id.	keyword
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
data_stream.dataset	Data stream dataset.	constant_keyword
data_stream.namespace	Data stream namespace.	constant_keyword
data_stream.type	Data stream type.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
event.dataset	Event module	constant_keyword
event.module	Event module	constant_keyword
host.ip	Host ip addresses.	ip
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
oracle.tablespace.data_file.id	Tablespace unique identifier.	long
oracle.tablespace.data_file.name	Filename of the data file	keyword
oracle.tablespace.data_file.online_status	Last known online status of the data file. One of SYSOFF, SYSTEM, OFFLINE, ONLINE or RECOVER.	keyword
oracle.tablespace.data_file.size.bytes	Size of the file in bytes	long	byte	gauge
oracle.tablespace.data_file.size.free.bytes	The size of the file available for user data. The actual size of the file minus this value is used to store file related metadata.	long	byte	gauge
oracle.tablespace.data_file.size.max.bytes	Maximum file size in bytes	long	byte	gauge
oracle.tablespace.data_file.status	File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)	keyword
oracle.tablespace.name	Tablespace name	keyword
oracle.tablespace.space.free.bytes	Tablespace total free space available, in bytes.	long	byte	gauge
oracle.tablespace.space.total.bytes	Tablespace total size, in bytes.	long	byte	gauge
oracle.tablespace.space.used.bytes	Tablespace used space, in bytes.	long	byte	gauge
service.address	Address where data about this service was collected from. This should be a URI, network address (ipv4:port or [ipv6]:port) or a resource path (sockets).	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

An example event for tablespace looks as following:

{
    "@timestamp": "2022-11-09T04:35:44.955Z",
    "agent": {
        "ephemeral_id": "06655b4a-84cd-4c99-857e-4410a887f89f",
        "id": "3316e565-c560-428d-8d26-638ac33c2dce",
        "name": "docker-custom-agent",
        "type": "metricbeat",
        "version": "8.4.3"
    },
    "cloud": {
        "account": {
            "id": "elastic-obs-integrations-dev"
        },
        "availability_zone": "asia-south1-c",
        "instance": {
            "id": "3010911784348669868",
            "name": "service-integration-dev-idc-01"
        },
        "machine": {
            "type": "n1-standard-8"
        },
        "project": {
            "id": "elastic-obs-integrations-dev"
        },
        "provider": "gcp",
        "service": {
            "name": "GCE"
        }
    },
    "data_stream": {
        "dataset": "oracle.tablespace",
        "namespace": "ep",
        "type": "metrics"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "elastic_agent": {
        "id": "3316e565-c560-428d-8d26-638ac33c2dce",
        "snapshot": false,
        "version": "8.4.3"
    },
    "event": {
        "agent_id_status": "verified",
        "dataset": "oracle.tablespace",
        "duration": 263268207,
        "ingested": "2022-11-09T04:35:46Z",
        "module": "sql"
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-custom-agent",
        "id": "702b305d5bf3433b8efe81033888bd28",
        "ip": [
            "172.29.0.3",
            "192.168.240.4"
        ],
        "mac": [
            "02:42:ac:1d:00:03",
            "02:42:c0:a8:f0:04"
        ],
        "name": "docker-custom-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.4.0-1078-gcp",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.5 LTS (Focal Fossa)"
        }
    },
    "metricset": {
        "name": "query",
        "period": 60000
    },
    "oracle": {
        "tablespace": {
            "data_file": {
                "id": 3,
                "name": "/u02/app/oracle/oradata/ORCL/sysaux01.dbf",
                "online_status": "ONLINE",
                "size": {
                    "bytes": 723517440,
                    "free": {
                        "bytes": 722468864
                    },
                    "max": {
                        "bytes": 34359721984
                    }
                },
                "status": "AVAILABLE"
            },
            "name": "SYSAUX",
            "space": {
                "free": {
                    "bytes": 23920640
                },
                "total": {
                    "bytes": 1712324608
                },
                "used": {
                    "bytes": 723517440
                }
            }
        }
    },
    "service": {
        "address": "oracle:1521",
        "type": "sql"
    }
}

Sysmetrics

The system metrics value captured for the most current time interval for the long duration (60-seconds) are listed in the following table.

To collect the Sysmetrics metrics, Oracle integration relies on a specific set of views. Make sure that the user configured within the Oracle DSN configuration has READ access permissions to the following view:

V$SYSMETRIC

Exported fields

Field	Description	Type	Unit	Metric Type
@timestamp	Date/time when the event originated. This is the date/time extracted from the event, typically representing when the event was generated by the source. If the event source has no original timestamp, this value is typically populated by the first time the event was received by the pipeline. Required field for all events.	date
agent.id	Unique identifier of this agent (if one exists). Example: For Beats this would be beat.id.	keyword
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.project.id	The cloud project identifier. Examples: Google Cloud Project id, Azure Project id.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
data_stream.dataset	The field can contain anything that makes sense to signify the source of the data. Examples include `nginx.access`, `prometheus`, `endpoint` etc. For data streams that otherwise fit, but that do not have dataset set we use the value "generic" for the dataset value. `event.dataset` should have the same value as `data_stream.dataset`. Beyond the Elasticsearch data stream naming criteria noted above, the `dataset` value has additional restrictions: * Must not contain `-` * No longer than 100 characters	constant_keyword
data_stream.namespace	A user defined namespace. Namespaces are useful to allow grouping of data. Many users already organize their indices this way, and the data stream naming scheme now provides this best practice as a default. Many users will populate this field with `default`. If no value is used, it falls back to `default`. Beyond the Elasticsearch index naming criteria noted above, `namespace` value has the additional restrictions: * Must not contain `-` * No longer than 100 characters	constant_keyword
data_stream.type	An overarching type for the data stream. Currently allowed values are "logs" and "metrics". We expect to also add "traces" and "synthetics" in the near future.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
event.dataset	Event module	constant_keyword
event.module	Event module	constant_keyword
host.ip	Host ip addresses.	ip
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
oracle.sysmetric.active_parallel_sessions	Active parallel sessions	double		gauge
oracle.sysmetric.active_serial_sessions	Active serial sessions.	double		gauge
oracle.sysmetric.average_active_sessions	Average active sessions.	double		gauge
oracle.sysmetric.average_synchronous_single-block_read_latency	Average synchronous single-block read latency.	double		gauge
oracle.sysmetric.background_checkpoints_per_sec	Background checkpoints per second.	double		gauge
oracle.sysmetric.background_cpu_usage_per_sec	Background CPU usage per sec	double		gauge
oracle.sysmetric.background_time_per_sec	Background time per second.	double		gauge
oracle.sysmetric.branch_node_splits_per_sec	Branch node splits per second.	double		gauge
oracle.sysmetric.branch_node_splits_per_txn	Branch node splits per transaction.	double		gauge
oracle.sysmetric.buffer_cache_hit_ratio	Buffer cache hit ratio	double		gauge
oracle.sysmetric.captured_user_calls	Captured user calls.	double		gauge
oracle.sysmetric.cell_physical_io_interconnect_bytes	Cell physical io interconnect bytes.	double		gauge
oracle.sysmetric.consistent_read_changes_per_sec	Consistent read changes per second.	double		gauge
oracle.sysmetric.consistent_read_changes_per_txn	Consistent read changes per transaction.	double		gauge
oracle.sysmetric.consistent_read_gets_per_sec	Consistent read gets per second.	double		gauge
oracle.sysmetric.consistent_read_gets_per_txn	Consistent read gets per transaction.	double		gauge
oracle.sysmetric.cpu_usage_per_sec	CPU usage per second.	double		gauge
oracle.sysmetric.cpu_usage_per_txn	CPU usage per transaction.	double		gauge
oracle.sysmetric.cr_blocks_created_per_sec	Cr blocks created per second.	double		gauge
oracle.sysmetric.cr_blocks_created_per_txn	Cr blocks created per transaction.	double		gauge
oracle.sysmetric.cr_undo_records_applied_per_sec	Cr undo records applied per second.	double		gauge
oracle.sysmetric.cr_undo_records_applied_per_txn	Cr undo records applied per transaction.	double		gauge
oracle.sysmetric.current_logons_count	Current logons count.	double		gauge
oracle.sysmetric.current_open_cursors_count	Current open cursors count	double		gauge
oracle.sysmetric.current_os_load	Current os load	double		gauge
oracle.sysmetric.cursor_cache_hit_ratio	Cursor cache hit ratio.	double		gauge
oracle.sysmetric.database_cpu_time_ratio	Database CPU time ratio	double		gauge
oracle.sysmetric.database_time_per_sec	Database time per second.	double		gauge
oracle.sysmetric.database_wait_time_ratio	Database wait time ratio.	double		gauge
oracle.sysmetric.db_block_changes_per_sec	Db block changes per second.	double		gauge
oracle.sysmetric.db_block_changes_per_txn	Db block changes per transaction.	double		gauge
oracle.sysmetric.db_block_changes_per_user_call	Db block changes per user call.	double		gauge
oracle.sysmetric.db_block_gets_per_sec	Db block gets per sec	double		gauge
oracle.sysmetric.db_block_gets_per_txn	Db block gets per transaction	double		gauge
oracle.sysmetric.db_block_gets_per_user_call	Db block gets per user call.	double		gauge
oracle.sysmetric.dbwr_checkpoints_per_sec	Dbwr checkpoints per sec.	double		gauge
oracle.sysmetric.ddl_statements_parallelized_per_sec	Ddl statements parallelized per sec	double		gauge
oracle.sysmetric.disk_sort_per_sec	Disk sort per second.	double		gauge
oracle.sysmetric.disk_sort_per_txn	Disk sort per transaction.	double		gauge
oracle.sysmetric.dml_statements_parallelized_per_sec	Dml statements parallelized per sec	double		gauge
oracle.sysmetric.enqueue_deadlocks_per_sec	Enqueue deadlocks per sec	double		gauge
oracle.sysmetric.enqueue_deadlocks_per_txn	Enqueue deadlocks per transaction.	double		gauge
oracle.sysmetric.enqueue_requests_per_sec	Enqueue requests per second.	double		gauge
oracle.sysmetric.enqueue_requests_per_txn	Enqueue requests per transaction	double		gauge
oracle.sysmetric.enqueue_timeouts_per_sec	Enqueue timeouts per second.	double		gauge
oracle.sysmetric.enqueue_timeouts_per_txn	Enqueue timeouts per transaction.	double		gauge
oracle.sysmetric.enqueue_waits_per_sec	Enqueue waits per second.	double		gauge
oracle.sysmetric.enqueue_waits_per_txn	Enqueue waits per transaction.	double		gauge
oracle.sysmetric.execute_without_parse_ratio	Execute without parse ratio	double		gauge
oracle.sysmetric.executions_per_sec	Executions per second.	double		gauge
oracle.sysmetric.executions_per_txn	Executions per transaction.	double		gauge
oracle.sysmetric.executions_per_user_call	Executions per user call	double		gauge
oracle.sysmetric.full_index_scans_per_sec	Full index scans per second.	double		gauge
oracle.sysmetric.full_index_scans_per_txn	Full index scans per transaction.	double		gauge
oracle.sysmetric.gc_cr_block_received_per_second	Gc cr block received per second.	double		gauge
oracle.sysmetric.gc_cr_block_received_per_txn	Gc cr block received per transaction.	double		gauge
oracle.sysmetric.gc_current_block_received_per_second	Gc current block received per second.	double		gauge
oracle.sysmetric.gc_current_block_received_per_txn	Gc current block received per transaction	double		gauge
oracle.sysmetric.global_cache_average_cr_get_time	Global cache average cr get time.	double		gauge
oracle.sysmetric.global_cache_average_current_get_time	Global cache average current get time	double		gauge
oracle.sysmetric.global_cache_blocks_corrupted	Global cache blocks corrupted.	double		gauge
oracle.sysmetric.global_cache_blocks_lost	Global cache blocks lost.	double		gauge
oracle.sysmetric.hard_parse_count_per_sec	Hard parse count per sec	double		gauge
oracle.sysmetric.hard_parse_count_per_txn	Hard parse count per transaction.	double		gauge
oracle.sysmetric.host_cpu_usage_per_sec	Host CPU usage per sec.	double		gauge
oracle.sysmetric.host_cpu_utilization_pct	Host CPU utilization percentage.	double	percent	gauge
oracle.sysmetric.io_megabytes_per_second	IO megabytes per second	double		gauge
oracle.sysmetric.io_requests_per_second	IO requests per second	double		gauge
oracle.sysmetric.leaf_node_splits_per_sec	Leaf node splits per second.	double		gauge
oracle.sysmetric.leaf_node_splits_per_txn	Leaf node splits per transaction.	double		gauge
oracle.sysmetric.library_cache_hit_ratio	Library cache hit ratio.	double		gauge
oracle.sysmetric.library_cache_miss_ratio	Library cache miss ratio.	double		gauge
oracle.sysmetric.logical_reads_per_sec	Logical reads per sec.	double		gauge
oracle.sysmetric.logical_reads_per_txn	Logical reads per transaction.	double		gauge
oracle.sysmetric.logical_reads_per_user_call	Logical reads per user call.	double		gauge
oracle.sysmetric.logons_per_sec	Logons per sec	double		gauge
oracle.sysmetric.logons_per_txn	Logons per transaction.	double		gauge
oracle.sysmetric.long_table_scans_per_sec	Long table scans per second.	double		gauge
oracle.sysmetric.long_table_scans_per_txn	Long table scans per transaction.	double		gauge
oracle.sysmetric.memory_sorts_ratio	Memory sorts ratio.	double		gauge
oracle.sysmetric.network_traffic_volume_per_sec	Network traffic volume per second.	double		gauge
oracle.sysmetric.open_cursors_per_sec	Open cursors per sec	double		gauge
oracle.sysmetric.open_cursors_per_txn	Open cursors per transaction	double		gauge
oracle.sysmetric.parse_failure_count_per_sec	Parse failure count per sec	double		gauge
oracle.sysmetric.parse_failure_count_per_txn	Parse failure count per transaction.	double		gauge
oracle.sysmetric.pga_cache_hit_pct	Pga cache hit percentage.	double	percent	gauge
oracle.sysmetric.physical_read_bytes_per_sec	Physical read bytes per second.	double		gauge
oracle.sysmetric.physical_read_io_requests_per_sec	Physical read io requests per second.	double		gauge
oracle.sysmetric.physical_read_total_bytes_per_sec	Physical read total bytes per second.	double		gauge
oracle.sysmetric.physical_read_total_io_requests_per_sec	Physical read total io requests per sec	double		gauge
oracle.sysmetric.physical_reads_direct_lobs_per_sec	Physical reads direct lobs per second.	double		gauge
oracle.sysmetric.physical_reads_direct_lobs_per_txn	Physical reads direct lobs per transaction.	double		gauge
oracle.sysmetric.physical_reads_direct_per_sec	Physical reads direct per second.	double		gauge
oracle.sysmetric.physical_reads_direct_per_txn	Physical reads direct per transaction.	double		gauge
oracle.sysmetric.physical_reads_per_sec	Physical reads per second.	double		gauge
oracle.sysmetric.physical_reads_per_txn	Physical reads per transaction.	double		gauge
oracle.sysmetric.physical_write_bytes_per_sec	Physical write bytes per second.	double		gauge
oracle.sysmetric.physical_write_io_requests_per_sec	Physical write io requests per second.	double		gauge
oracle.sysmetric.physical_write_total_bytes_per_sec	Physical write total bytes per second.	double		gauge
oracle.sysmetric.physical_write_total_io_requests_per_sec	Physical write total io requests per second.	double		gauge
oracle.sysmetric.physical_writes_direct_lobs__per_txn	Physical writes direct lobs per transaction	double		gauge
oracle.sysmetric.physical_writes_direct_lobs_per_sec	Physical writes direct lobs per sec	double		gauge
oracle.sysmetric.physical_writes_direct_per_sec	Physical writes direct per second.	double		gauge
oracle.sysmetric.physical_writes_direct_per_txn	Physical writes direct per transaction.	double		gauge
oracle.sysmetric.physical_writes_per_sec	Physical writes per second.	double		gauge
oracle.sysmetric.physical_writes_per_txn	Physical writes per transaction.	double		gauge
oracle.sysmetric.pq_qc_session_count	Pq qc session count.	double		gauge
oracle.sysmetric.pq_slave_session_count	Pq slave session count.	double		gauge
oracle.sysmetric.process_limit_pct	Process limit percentage.	double	percent	gauge
oracle.sysmetric.px_downgraded_1_to_25pct_per_sec	Px downgraded 1 to 25 percentage per second.	double	percent	gauge
oracle.sysmetric.px_downgraded_25_to_50pct_per_sec	Px downgraded 25 to 50 percentage per sec	double	percent	gauge
oracle.sysmetric.px_downgraded_50_to_75pct_per_sec	Px downgraded 50 to 75 percentage per second.	double	percent	gauge
oracle.sysmetric.px_downgraded_75_to_99pct_per_sec	Px downgraded 75 to 99 percentage per second.	double	percent	gauge
oracle.sysmetric.px_downgraded_to_serial_per_sec	Px downgraded to serial per sec.	double		gauge
oracle.sysmetric.px_operations_not_downgraded_per_sec	Px operations not downgraded per second.	double		gauge
oracle.sysmetric.queries_parallelized_per_sec	Queries parallelized per second.	double		gauge
oracle.sysmetric.recursive_calls_per_sec	Recursive calls per second.	double		gauge
oracle.sysmetric.recursive_calls_per_txn	Recursive calls per transaction.	double		gauge
oracle.sysmetric.redo_allocation_hit_ratio	Redo allocation hit ratio.	double		gauge
oracle.sysmetric.redo_generated_per_sec	Redo generated per second.	double		gauge
oracle.sysmetric.redo_generated_per_txn	Redo generated per transaction	double		gauge
oracle.sysmetric.redo_writes_per_sec	Redo writes per second.	double		gauge
oracle.sysmetric.redo_writes_per_txn	Redo writes per transaction.	double		gauge
oracle.sysmetric.replayed_user_calls	Replayed user calls	double		gauge
oracle.sysmetric.response_time_per_txn	Response time per transaction.	double		gauge
oracle.sysmetric.row_cache_hit_ratio	Row cache hit ratio.	double		gauge
oracle.sysmetric.row_cache_miss_ratio	Row cache miss ratio.	double		gauge
oracle.sysmetric.rows_per_sort	Rows per sort.	double		gauge
oracle.sysmetric.run_queue_per_sec	Run queue per second.	double		gauge
oracle.sysmetric.session_count	Session count.	double		gauge
oracle.sysmetric.session_limit_pct	"Session limit percentage."	double	percent	gauge
oracle.sysmetric.shared_pool_free_pct	Shared pool free percentage.	double	percent	gauge
oracle.sysmetric.soft_parse_ratio	Soft parse ratio.	double		gauge
oracle.sysmetric.sql_service_response_time	Sql service response time	double		gauge
oracle.sysmetric.streams_pool_usage_percentage	Streams pool usage percentage.	double		gauge
oracle.sysmetric.temp_space_used	Temp space used	double		gauge
oracle.sysmetric.total_index_scans_per_sec	Total index scans per second.	double		gauge
oracle.sysmetric.total_index_scans_per_txn	Total index scans per transaction.	double		gauge
oracle.sysmetric.total_parse_count_per_sec	Total parse count per sec	double		gauge
oracle.sysmetric.total_parse_count_per_txn	Total parse count per transaction.	double		gauge
oracle.sysmetric.total_pga_allocated	Total pga allocated.	double		gauge
oracle.sysmetric.total_pga_used_by_sql_workareas	Total pga used by sql workareas	double		gauge
oracle.sysmetric.total_sorts_per_user_call	Total sorts per user call.	double		gauge
oracle.sysmetric.total_table_scans_per_sec	Total table scans per second.	double		gauge
oracle.sysmetric.total_table_scans_per_txn	Total table scans per transaction.	double		gauge
oracle.sysmetric.total_table_scans_per_user_call	Total table scans per user call.	double		gauge
oracle.sysmetric.txns_per_logon	transactions per logon.	double		gauge
oracle.sysmetric.user_calls_per_sec	User calls per second.	double		gauge
oracle.sysmetric.user_calls_per_txn	User calls per transaction	double		gauge
oracle.sysmetric.user_calls_ratio	User calls ratio	double		gauge
oracle.sysmetric.user_commits_per_sec	User commits per sec	double		gauge
oracle.sysmetric.user_commits_percentage	User commits percentage.	double		gauge
oracle.sysmetric.user_limit_pct	User limit percentage.	double	percent	gauge
oracle.sysmetric.user_rollback_undo_records_applied_per_txn	User rollback undo records applied per transaction.	double		gauge
oracle.sysmetric.user_rollback_undorec_applied_per_sec	User rollback undorec applied per second.	double		gauge
oracle.sysmetric.user_rollbacks_per_sec	User rollbacks per second.	double		gauge
oracle.sysmetric.user_rollbacks_percentage	User rollbacks percentage.	double		gauge
oracle.sysmetric.user_transaction_per_sec	User transaction per second.	double		gauge
oracle.sysmetric.vm_in_bytes_per_sec	Vm in bytes per sec	double		gauge
oracle.sysmetric.vm_out_bytes_per_sec	Vm out bytes per second.	double		gauge
oracle.sysmetric.workload_capture_and_replay_status	Workload capture and replay status.	double		gauge
service.address	Address where data about this service was collected from. This should be a URI, network address (ipv4:port or [ipv6]:port) or a resource path (sockets).	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

An example event for sysmetric looks as following:

{
    "@timestamp": "2022-11-09T04:28:12.009Z",
    "agent": {
        "ephemeral_id": "4d613e69-65ae-4c3a-9f60-8b600554574c",
        "id": "f4169ed3-d5c6-4775-bcad-5f4c0cca8a9f",
        "name": "docker-custom-agent",
        "type": "metricbeat",
        "version": "8.4.3"
    },
    "cloud": {
        "account": {
            "id": "elastic-obs-integrations-dev"
        },
        "availability_zone": "asia-south1-c",
        "instance": {
            "id": "3010911784348669868",
            "name": "service-integration-dev-idc-01"
        },
        "machine": {
            "type": "n1-standard-8"
        },
        "project": {
            "id": "elastic-obs-integrations-dev"
        },
        "provider": "gcp",
        "service": {
            "name": "GCE"
        }
    },
    "data_stream": {
        "dataset": "oracle.sysmetric",
        "namespace": "ep",
        "type": "metrics"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "elastic_agent": {
        "id": "f4169ed3-d5c6-4775-bcad-5f4c0cca8a9f",
        "snapshot": false,
        "version": "8.4.3"
    },
    "event": {
        "agent_id_status": "verified",
        "dataset": "oracle.sysmetric",
        "duration": 81013699,
        "ingested": "2022-11-09T04:28:12Z",
        "module": "sql"
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-custom-agent",
        "id": "702b305d5bf3433b8efe81033888bd28",
        "ip": [
            "172.27.0.3",
            "192.168.240.4"
        ],
        "mac": [
            "02:42:ac:1b:00:03",
            "02:42:c0:a8:f0:04"
        ],
        "name": "docker-custom-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.4.0-1078-gcp",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.5 LTS (Focal Fossa)"
        }
    },
    "metricset": {
        "name": "query",
        "period": 60000
    },
    "oracle": {
        "sysmetric": {
            "active_parallel_sessions": 0,
            "active_serial_sessions": 1,
            "average_active_sessions": 1.3158911021814,
            "average_synchronous_single-block_read_latency": 2.48382983655964,
            "background_checkpoints_per_sec": 0,
            "background_cpu_usage_per_sec": 5.41525258323766,
            "background_time_per_sec": 0.349192881745121,
            "branch_node_splits_per_sec": 0,
            "branch_node_splits_per_txn": 0,
            "buffer_cache_hit_ratio": 95.3592643642205,
            "captured_user_calls": 0,
            "cell_physical_io_interconnect_bytes": 2304267631,
            "consistent_read_changes_per_sec": 221.622655951014,
            "consistent_read_changes_per_txn": 214.481481481481,
            "consistent_read_gets_per_sec": 5360.58170685036,
            "consistent_read_gets_per_txn": 5187.85185185185,
            "cpu_usage_per_sec": 19.6512265595101,
            "cpu_usage_per_txn": 19.0180203703704,
            "cr_blocks_created_per_sec": 4.07577497129736,
            "cr_blocks_created_per_txn": 3.94444444444444,
            "cr_undo_records_applied_per_sec": 219.077688480674,
            "cr_undo_records_applied_per_txn": 212.018518518519,
            "current_logons_count": 58,
            "current_open_cursors_count": 23,
            "current_os_load": 2.939453125,
            "cursor_cache_hit_ratio": 290.424008021773,
            "database_cpu_time_ratio": 14.9337787351351,
            "database_time_per_sec": 131.58911021814,
            "database_wait_time_ratio": 85.0662212648649,
            "db_block_changes_per_sec": 631.094527363184,
            "db_block_changes_per_txn": 610.759259259259,
            "db_block_changes_per_user_call": 85.0025773195876,
            "db_block_gets_per_sec": 511.844623038653,
            "db_block_gets_per_txn": 495.351851851852,
            "db_block_gets_per_user_call": 68.9407216494845,
            "dbwr_checkpoints_per_sec": 0.0574052812858783,
            "ddl_statements_parallelized_per_sec": 0,
            "disk_sort_per_sec": 0,
            "disk_sort_per_txn": 0,
            "dml_statements_parallelized_per_sec": 0,
            "enqueue_deadlocks_per_sec": 0,
            "enqueue_deadlocks_per_txn": 0,
            "enqueue_requests_per_sec": 343.073096058171,
            "enqueue_requests_per_txn": 332.018518518519,
            "enqueue_timeouts_per_sec": 0.0765403750478377,
            "enqueue_timeouts_per_txn": 0.0740740740740741,
            "enqueue_waits_per_sec": 0.68886337543054,
            "enqueue_waits_per_txn": 0.666666666666667,
            "execute_without_parse_ratio": 57.5272325686462,
            "executions_per_sec": 762.380405663988,
            "executions_per_txn": 737.814814814815,
            "executions_per_user_call": 102.685567010309,
            "full_index_scans_per_sec": 13.4711060084194,
            "full_index_scans_per_txn": 13.037037037037,
            "gc_cr_block_received_per_second": 0,
            "gc_cr_block_received_per_txn": 0,
            "gc_current_block_received_per_second": 0,
            "gc_current_block_received_per_txn": 0,
            "global_cache_average_cr_get_time": 0,
            "global_cache_average_current_get_time": 0,
            "global_cache_blocks_corrupted": 0,
            "global_cache_blocks_lost": 0,
            "hard_parse_count_per_sec": 56.6398775353999,
            "hard_parse_count_per_txn": 54.8148148148148,
            "host_cpu_usage_per_sec": 118.637581324148,
            "host_cpu_utilization_pct": 14.8453213293746,
            "io_megabytes_per_second": 42.0398009950249,
            "io_requests_per_second": 209.395331037122,
            "leaf_node_splits_per_sec": 0.0765403750478377,
            "leaf_node_splits_per_txn": 0.0740740740740741,
            "library_cache_hit_ratio": 85.9758358371156,
            "library_cache_miss_ratio": 14.0241641628844,
            "logical_reads_per_sec": 5872.42632988902,
            "logical_reads_per_txn": 5683.2037037037,
            "logical_reads_per_user_call": 790.961340206186,
            "logons_per_sec": 2.39188672024493,
            "logons_per_txn": 2.31481481481481,
            "long_table_scans_per_sec": 0,
            "long_table_scans_per_txn": 0,
            "memory_sorts_ratio": 100,
            "network_traffic_volume_per_sec": 258.036739380023,
            "open_cursors_per_sec": 662.456946039036,
            "open_cursors_per_txn": 641.111111111111,
            "parse_failure_count_per_sec": 0.516647531572905,
            "parse_failure_count_per_txn": 0.5,
            "pga_cache_hit_pct": 100,
            "physical_read_bytes_per_sec": 2234538.07883659,
            "physical_read_io_requests_per_sec": 154.994259471871,
            "physical_read_total_bytes_per_sec": 23205621.1251435,
            "physical_read_total_io_requests_per_sec": 196.19211634137,
            "physical_reads_direct_lobs_per_sec": 0.0191350937619594,
            "physical_reads_direct_lobs_per_txn": 0.0185185185185185,
            "physical_reads_direct_per_sec": 0.248756218905473,
            "physical_reads_direct_per_txn": 0.240740740740741,
            "physical_reads_per_sec": 272.770761576732,
            "physical_reads_per_txn": 263.981481481481,
            "physical_write_bytes_per_sec": 3918.86720244929,
            "physical_write_io_requests_per_sec": 0.478377344048986,
            "physical_write_total_bytes_per_sec": 20886756.0466896,
            "physical_write_total_io_requests_per_sec": 34.7110600841944,
            "physical_writes_direct_lobs__per_txn": 0.0185185185185185,
            "physical_writes_direct_lobs_per_sec": 0.0191350937619594,
            "physical_writes_direct_per_sec": 0.191350937619594,
            "physical_writes_direct_per_txn": 0.185185185185185,
            "physical_writes_per_sec": 0.478377344048986,
            "physical_writes_per_txn": 0.462962962962963,
            "pq_qc_session_count": 0,
            "pq_slave_session_count": 0,
            "process_limit_pct": 32,
            "px_downgraded_1_to_25pct_per_sec": 0,
            "px_downgraded_25_to_50pct_per_sec": 0,
            "px_downgraded_50_to_75pct_per_sec": 0,
            "px_downgraded_75_to_99pct_per_sec": 0,
            "px_downgraded_to_serial_per_sec": 0,
            "px_operations_not_downgraded_per_sec": 0.114810562571757,
            "queries_parallelized_per_sec": 0.0382701875239189,
            "recursive_calls_per_sec": 3231.72598545733,
            "recursive_calls_per_txn": 3127.59259259259,
            "redo_allocation_hit_ratio": 99.9710060887214,
            "redo_generated_per_sec": 89624.2632988902,
            "redo_generated_per_txn": 86736.3703703704,
            "redo_writes_per_sec": 6.29544584768465,
            "redo_writes_per_txn": 6.09259259259259,
            "replayed_user_calls": 0,
            "response_time_per_txn": 127.349016666667,
            "row_cache_hit_ratio": 92.9547727525281,
            "row_cache_miss_ratio": 7.04522724747194,
            "rows_per_sort": 16.1167552157574,
            "run_queue_per_sec": 0,
            "session_count": 69,
            "session_limit_pct": 14.6186440677966,
            "shared_pool_free_pct": 15.3352475166321,
            "soft_parse_ratio": 82.5079777804042,
            "sql_service_response_time": 0.0406245755502782,
            "streams_pool_usage_percentage": 0,
            "temp_space_used": 0,
            "total_index_scans_per_sec": 732.548794489093,
            "total_index_scans_per_txn": 708.944444444445,
            "total_parse_count_per_sec": 323.804056639878,
            "total_parse_count_per_txn": 313.37037037037,
            "total_pga_allocated": 295197696,
            "total_pga_used_by_sql_workareas": 0,
            "total_sorts_per_user_call": 19.889175257732,
            "total_table_scans_per_sec": 42.7860696517413,
            "total_table_scans_per_txn": 41.4074074074074,
            "total_table_scans_per_user_call": 5.76288659793814,
            "txns_per_logon": 0.432,
            "user_calls_per_sec": 7.42441637964026,
            "user_calls_per_txn": 7.18518518518519,
            "user_calls_ratio": 0.229208757192311,
            "user_commits_per_sec": 1.01415996938385,
            "user_commits_percentage": 98.1481481481482,
            "user_limit_pct": 0.00000135041773350686,
            "user_rollback_undo_records_applied_per_txn": 25.7777777777778,
            "user_rollback_undorec_applied_per_sec": 26.6360505166475,
            "user_rollbacks_per_sec": 0.0191350937619594,
            "user_rollbacks_percentage": 1.85185185185185,
            "user_transaction_per_sec": 1.03329506314581,
            "vm_in_bytes_per_sec": 0,
            "vm_out_bytes_per_sec": 0,
            "workload_capture_and_replay_status": 0
        }
    },
    "service": {
        "address": "oracle:1521",
        "type": "sql"
    }
}

Memory Metrics

A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. Metrics concerning Program Global Area (PGA) memory are mentioned below.

To collect the Memory metrics, Oracle integration relies on a specific set of views. Make sure that the user configured within the Oracle DSN configuration has READ access permissions to the following views:

V$SGASTAT
V$PGASTAT

Exported fields

Field	Description	Type	Unit	Metric Type
@timestamp	Event timestamp.	date
agent.id	Unique identifier of this agent (if one exists). Example: For Beats this would be beat.id.	keyword
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
data_stream.dataset	Data stream dataset.	constant_keyword
data_stream.namespace	Data stream namespace.	constant_keyword
data_stream.type	Data stream type.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
event.dataset	Event module	constant_keyword
event.module	Event module	constant_keyword
host.ip	Host ip addresses.	ip
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
oracle.memory.pga.aggregate_auto_target	Amount of PGA memory the Oracle Database can use for work areas running in automatic mode.	double	byte	gauge
oracle.memory.pga.aggregate_target_parameter	Current value of the PGA_AGGREGATE_TARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of PGA memory is disabled.	double	byte	gauge
oracle.memory.pga.cache_hit_pct	A metric computed by the Oracle Database to reflect the performance of the PGA memory component, cumulative since instance startup.	double	percent	gauge
oracle.memory.pga.global_memory_bound	Maximum size of a work area executed in automatic mode.	double	byte	gauge
oracle.memory.pga.maximum_allocated	Maximum number of bytes of PGA memory allocated at one time since instance startup.	double	byte	gauge
oracle.memory.pga.total_allocated	Current amount of PGA memory allocated by the instance.	double	byte	gauge
oracle.memory.pga.total_freeable_memory	Number of bytes of PGA memory in all processes that could be freed back to the operating system.	double	byte	gauge
oracle.memory.pga.total_inuse	Indicates how much PGA memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).	double	byte	gauge
oracle.memory.pga.total_used_for_auto_workareas	Indicates how much PGA memory is currently consumed by work areas running under the automatic memory management mode. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).	double	byte	gauge
oracle.memory.sga.free_memory	Amount of free memory in the Shared pool.	double	byte	gauge
oracle.memory.sga.total_memory	Amount of total memory in the Shared pool.	double	byte	gauge
service.address	Address where data about this service was collected from. This should be a URI, network address (ipv4:port or [ipv6]:port) or a resource path (sockets).	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

An example event for memory looks as following:

{
    "@timestamp": "2022-11-09T04:21:05.327Z",
    "agent": {
        "ephemeral_id": "df8a2ae5-c832-4b31-a31d-226a455aff19",
        "id": "c2cd9bb5-503e-492f-b6b7-fd5c845a7574",
        "name": "docker-custom-agent",
        "type": "metricbeat",
        "version": "8.4.3"
    },
    "cloud": {
        "account": {
            "id": "elastic-obs-integrations-dev"
        },
        "availability_zone": "asia-south1-c",
        "instance": {
            "id": "3010911784348669868",
            "name": "service-integration-dev-idc-01"
        },
        "machine": {
            "type": "n1-standard-8"
        },
        "project": {
            "id": "elastic-obs-integrations-dev"
        },
        "provider": "gcp",
        "service": {
            "name": "GCE"
        }
    },
    "data_stream": {
        "dataset": "oracle.memory",
        "namespace": "ep",
        "type": "metrics"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "elastic_agent": {
        "id": "c2cd9bb5-503e-492f-b6b7-fd5c845a7574",
        "snapshot": false,
        "version": "8.4.3"
    },
    "event": {
        "agent_id_status": "verified",
        "dataset": "oracle.memory",
        "duration": 104106525,
        "ingested": "2022-11-09T04:21:06Z",
        "module": "sql"
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-custom-agent",
        "id": "702b305d5bf3433b8efe81033888bd28",
        "ip": [
            "172.25.0.3",
            "192.168.240.4"
        ],
        "mac": [
            "02:42:ac:19:00:03",
            "02:42:c0:a8:f0:04"
        ],
        "name": "docker-custom-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.4.0-1078-gcp",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.5 LTS (Focal Fossa)"
        }
    },
    "metricset": {
        "name": "query",
        "period": 60000
    },
    "oracle": {
        "memory": {
            "pga": {
                "aggregate_auto_target": 593971200,
                "aggregate_target_parameter": 805306368,
                "cache_hit_pct": 100,
                "global_memory_bound": 104857600,
                "maximum_allocated": 361708544,
                "total_allocated": 197623808,
                "total_freeable_memory": 35061760,
                "total_inuse": 147043328,
                "total_used_for_auto_workareas": 0
            },
            "sga": {
                "free_memory": 33630360,
                "total_memory": 335544320
            }
        }
    },
    "service": {
        "address": "oracle:1521",
        "type": "sql"
    }
}

System Statistics Metrics

The System Global Area (SGA) is a group of shared memory structures that contain data and control information for one Oracle Database instance. Metrics concerning System Global Area (SGA) memory are mentioned below.

To collect the System Statistics metrics, Oracle integration relies on a specific set of views. Make sure that the user configured within the Oracle DSN configuration has READ access permissions to the following view:

V$SYSSTAT

Exported fields

Field	Description	Type	Unit	Metric Type
@timestamp	Event timestamp.	date
agent.id	Unique identifier of this agent (if one exists). Example: For Beats this would be beat.id.	keyword
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
data_stream.dataset	Data stream dataset.	constant_keyword
data_stream.namespace	Data stream namespace.	constant_keyword
data_stream.type	Data stream type.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
event.dataset	Event module	constant_keyword
event.module	Event module	constant_keyword
host.ip	Host ip addresses.	ip
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
oracle.system_statistics.bytes_received_via_sqlnet_from_client	Total number of bytes received from the client over Oracle Net Services.	double	byte	counter
oracle.system_statistics.bytes_received_via_sqlnet_from_dblink	Total number of bytes received from a database link over Oracle Net Services	double	byte	counter
oracle.system_statistics.bytes_sent_via_sqlnet_to_client	Total number of bytes sent to the client from the foreground processes.	double	byte	counter
oracle.system_statistics.bytes_sent_via_sqlnet_to_dblink	Total number of bytes sent over a database link.	double	byte	counter
oracle.system_statistics.cpu_used_by_this_session	Amount of CPU time (in 10s of milliseconds) used by a session from the time a user call starts until it ends.	double	ms	counter
oracle.system_statistics.db_block_changes	This statistic counts the total number of changes that were part of an update or delete operation that were made to all blocks in the SGA.	double		counter
oracle.system_statistics.db_block_gets_from_cache	The number of times a CURRENT block was requested from the buffer cache.	double		counter
oracle.system_statistics.db_time	The sum of CPU consumption of all the Oracle process and the sum of non-idle wait time.	double		counter
oracle.system_statistics.dbwr_checkpoint_buffers_written	The number of buffers that were written for checkpoints.	double		counter
oracle.system_statistics.dbwr_checkpoints	The number of times the DBWR was asked to scan the cache and write all blocks marked for a checkpoint or the end of recovery.	double		counter
oracle.system_statistics.dml_statements_parallelized	The number of DML statements that were executed in parallel.	double		counter
oracle.system_statistics.enqueue_conversions	Total number of conversions of the state of table or row lock.	double		counter
oracle.system_statistics.enqueue_deadlocks	Total number of deadlocks between table or row locks in different sessions.	double		counter
oracle.system_statistics.enqueue_releases	Total number of table or row locks released.	double		counter
oracle.system_statistics.enqueue_requests	Total number of table or row locks acquired	double		counter
oracle.system_statistics.enqueue_timeouts	Total number of table and row locks (acquired and converted) that timed out before they could complete.	double		counter
oracle.system_statistics.enqueue_waits	Total number of waits that occurred during an enqueue convert or get because the enqueue get was deferred.	double		counter
oracle.system_statistics.exchange_deadlocks	Number of times that a process detected a potential deadlock when exchanging two buffers and raised an internal, restartable error. Index scans are the only operations that perform exchanges.	double		counter
oracle.system_statistics.execute_count	Total number of calls (user and recursive) that executed SQL statements.	double		counter
oracle.system_statistics.gc_current_block_receive_time	The total time required for consistent read requests to complete. It records the round-trip time for all requests for consistent read blocks.	double		counter
oracle.system_statistics.index_fast_full_scans_direct_read	The number of fast full scans initiated using direct read.	double		counter
oracle.system_statistics.index_fast_full_scans_full	The number of fast full scans initiated using direct read.	double		counter
oracle.system_statistics.index_fast_full_scans_rowid_ranges	The number of fast full scans initiated with rowid endpoints specified.	double		counter
oracle.system_statistics.java_call_heap_live_size	The Java call heap live size.	double		counter
oracle.system_statistics.java_call_heap_total_size	The total Java call heap size.	double	byte	counter
oracle.system_statistics.java_call_heap_used_size	The Java call heap used size.	double		counter
oracle.system_statistics.lob_reads	The number of LOB API read operations performed in the session/system.	double		counter
oracle.system_statistics.lob_writes	The number of LOB API write operations performed in the session/system.	double		counter
oracle.system_statistics.logons_current	Total number of current logons.	double		counter
oracle.system_statistics.opened_cursors_current	Total number of current open cursors.	double		counter
oracle.system_statistics.os_system_time_used	The total CPU time used for system calls.	double		counter
oracle.system_statistics.os_user_time_used	The total CPU time used for user calls.	double		counter
oracle.system_statistics.parallel_operations_not_downgraded	Number of times parallel execution was executed at the requested degree of parallelism	double		counter
oracle.system_statistics.parse_count_hard	Total number of parse calls (real parses).	double		counter
oracle.system_statistics.parse_count_total	Total number of parse calls (hard, soft, and describe).	double		counter
oracle.system_statistics.parse_time_cpu	Total CPU time used for parsing (hard and soft) in 10s of milliseconds	double	ms	counter
oracle.system_statistics.parse_time_elapsed	Total elapsed time for parsing, in 10s of milliseconds.	double	ms	counter
oracle.system_statistics.physical_read_bytes	Total size in bytes of all disk reads by application activity (and not other instance activity) only.	double	byte	counter
oracle.system_statistics.physical_read_io_requests	Number of read requests for application activity (mainly buffer cache and direct load operation) which read one or more database blocks per request.	double		counter
oracle.system_statistics.physical_read_total_bytes	Total size in bytes of disk reads by all database instance activity including application reads, backup and recovery, and other utilities.	double	byte	counter
oracle.system_statistics.physical_read_total_io_requests	The number of read requests which read one or more database blocks for all instance activity including application, backup and recovery, and other utilities.	double		counter
oracle.system_statistics.physical_reads	Total number of data blocks read from disk.	double		counter
oracle.system_statistics.physical_write_bytes	Total size in bytes of all disk writes from the database application activity (and not other kinds of instance activity).	double	byte	counter
oracle.system_statistics.physical_write_io_requests	Number of write requests for application activity (mainly buffer cache and direct load operation) which wrote one or more database blocks per request.	double		counter
oracle.system_statistics.physical_write_total_bytes	Total size in bytes of all disk writes for the database instance including application activity, backup and recovery, and other utilities.	double	byte	counter
oracle.system_statistics.physical_write_total_io_requests	The number of write requests which wrote one or more database blocks from all instance activity including application activity, backup and recovery, and other utilities.	double		counter
oracle.system_statistics.physical_writes	Total number of data blocks written to disk. This statistics value equals the sum of physical writes direct and physical writes from cache values.	double		counter
oracle.system_statistics.physical_writes_direct	Number of writes directly to disk, bypassing the buffer cache (as in a direct load operation).	double		counter
oracle.system_statistics.physical_writes_from_cache	Total number of data blocks written to disk from the buffer cache. This is a subset of "physical writes" statistic.	double		counter
oracle.system_statistics.process_last_non_idle_time	The last time this process executed.	double		counter
oracle.system_statistics.queries_parallelized	Number of SELECT statements executed in parallel.	double		counter
oracle.system_statistics.recovery_blocks_read	The number of blocks read during recovery.	double		counter
oracle.system_statistics.recursive_calls	The number of recursive calls generated at both the user and system level.	double		counter
oracle.system_statistics.recursive_cpu_usage	Total CPU time used by non-user calls (recursive calls).	double		counter
oracle.system_statistics.redo_blocks_written	Total number of redo blocks written.	double		counter
oracle.system_statistics.redo_buffer_allocation_retries	Total number of retries necessary to allocate space in the redo buffer.	double		counter
oracle.system_statistics.redo_log_space_requests	The number of times the active log file is full and Oracle must wait for disk space to be allocated for the redo log entries.	double		counter
oracle.system_statistics.redo_log_space_wait_time	Total time waited in centiseconds for available space in the redo log buffer.	double		counter
oracle.system_statistics.redo_size	Total amount of redo generated in bytes.	double	byte	counter
oracle.system_statistics.redo_synch_time	Elapsed time of all redo synch writes calls in 10s of milliseconds.	double	ms	counter
oracle.system_statistics.redo_write_time	Total elapsed time of the write from the redo log buffer to the current redo log file in microseconds.	double	micros	counter
oracle.system_statistics.redo_writes	Total number of writes by LGWR to the redo log files.	double		counter
oracle.system_statistics.session_cursor_cache_count	Total number of cursors cached.	double		counter
oracle.system_statistics.session_cursor_cache_hits	Total number of cursors cached.	double		counter
oracle.system_statistics.session_logical_reads	The sum of db block gets plus consistent gets. This includes logical reads of database blocks from either the buffer cache or process private memory.	double		counter
oracle.system_statistics.session_stored_procedure_space	Amount of memory this session is using for stored procedures.	double		counter
oracle.system_statistics.smon_posted_for_instance_recovery	The total count or number of times SMON posted for instance recovery.	double		counter
oracle.system_statistics.smon_posted_for_txn_recovery_for_other_instances	The total count or number of times SMON posted for instance recovery	double		counter
oracle.system_statistics.sorts_disk	The number of sort operations that required at least one disk write.	double		counter
oracle.system_statistics.sorts_memory	The number of sort operations that were performed completely in memory and did not require any disk writes.	double		counter
oracle.system_statistics.sorts_rows	Total number of rows sorted.	double		counter
oracle.system_statistics.table_scan_rows_gotten	Number of rows that are processed during scanning operations.	double		counter
oracle.system_statistics.table_scans_direct_read	The number of table scans performed with direct read (bypassing the buffer cache).	double		counter
oracle.system_statistics.table_scans_long_tables	Long (or conversely short) tables can be defined as tables that do not meet the short table criteria.	double		counter
oracle.system_statistics.table_scans_rowid_ranges	During parallel query, the number of table scans conducted with specified ROWID ranges.	double		counter
oracle.system_statistics.transaction_rollbacks	Number of transactions being successfully rolled back.	double		counter
oracle.system_statistics.user_calls	Number of user calls such as login, parse, fetch, or execute.	double		counter
oracle.system_statistics.user_commits	Number of user commits. When a user commits a transaction, the redo generated that reflects the changes made to database blocks must be written to disk.	double		counter
oracle.system_statistics.user_rollbacks	Number of times users manually issue the ROLLBACK statement or an error occurs during a user's transactions.	double		counter
service.address	Address where data about this service was collected from. This should be a URI, network address (ipv4:port or [ipv6]:port) or a resource path (sockets).	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

An example event for system_statistics looks as following:

{
    "@timestamp": "2022-11-09T04:31:54.386Z",
    "agent": {
        "ephemeral_id": "a4fc8cc8-ffc8-41ca-95c0-84e4f17bf1d1",
        "id": "cb76e254-12e8-4c08-9044-4fe4255975da",
        "name": "docker-custom-agent",
        "type": "metricbeat",
        "version": "8.4.3"
    },
    "cloud": {
        "account": {
            "id": "elastic-obs-integrations-dev"
        },
        "availability_zone": "asia-south1-c",
        "instance": {
            "id": "3010911784348669868",
            "name": "service-integration-dev-idc-01"
        },
        "machine": {
            "type": "n1-standard-8"
        },
        "project": {
            "id": "elastic-obs-integrations-dev"
        },
        "provider": "gcp",
        "service": {
            "name": "GCE"
        }
    },
    "data_stream": {
        "dataset": "oracle.system_statistics",
        "namespace": "ep",
        "type": "metrics"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "elastic_agent": {
        "id": "cb76e254-12e8-4c08-9044-4fe4255975da",
        "snapshot": false,
        "version": "8.4.3"
    },
    "event": {
        "agent_id_status": "verified",
        "dataset": "oracle.system_statistics",
        "duration": 79970148,
        "ingested": "2022-11-09T04:31:55Z",
        "module": "sql"
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-custom-agent",
        "id": "702b305d5bf3433b8efe81033888bd28",
        "ip": [
            "172.28.0.3",
            "192.168.240.4"
        ],
        "mac": [
            "02:42:ac:1c:00:03",
            "02:42:c0:a8:f0:04"
        ],
        "name": "docker-custom-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.4.0-1078-gcp",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.5 LTS (Focal Fossa)"
        }
    },
    "metricset": {
        "name": "query",
        "period": 60000
    },
    "oracle": {
        "system_statistics": {
            "bytes_received_via_sqlnet_from_client": 15982,
            "bytes_received_via_sqlnet_from_dblink": 0,
            "bytes_sent_via_sqlnet_to_client": 25891,
            "bytes_sent_via_sqlnet_to_dblink": 0,
            "cpu_used_by_this_session": 1794,
            "db_block_changes": 31677,
            "db_block_gets_from_cache": 27540,
            "db_time": 64115,
            "dbwr_checkpoint_buffers_written": 0,
            "dbwr_checkpoints": 3,
            "dml_statements_parallelized": 0,
            "enqueue_conversions": 610,
            "enqueue_deadlocks": 0,
            "enqueue_releases": 28193,
            "enqueue_requests": 28233,
            "enqueue_timeouts": 9,
            "enqueue_waits": 53,
            "exchange_deadlocks": 0,
            "execute_count": 53587,
            "gc_current_block_receive_time": 0,
            "index_fast_full_scans_direct_read": 0,
            "index_fast_full_scans_full": 858,
            "index_fast_full_scans_rowid_ranges": 0,
            "java_call_heap_live_size": 0,
            "java_call_heap_total_size": 0,
            "java_call_heap_used_size": 0,
            "lob_reads": 126,
            "lob_writes": 206,
            "logons_current": 41,
            "opened_cursors_current": 25,
            "os_system_time_used": 0,
            "os_user_time_used": 0,
            "parallel_operations_not_downgraded": 8,
            "parse_count_hard": 4131,
            "parse_count_total": 20224,
            "parse_time_cpu": 560,
            "parse_time_elapsed": 1338,
            "physical_read_bytes": 143785984,
            "physical_read_io_requests": 10758,
            "physical_read_total_bytes": 1264044544,
            "physical_read_total_io_requests": 13539,
            "physical_reads": 17552,
            "physical_write_bytes": 188416,
            "physical_write_io_requests": 23,
            "physical_write_total_bytes": 1094185289,
            "physical_write_total_io_requests": 2209,
            "physical_writes": 23,
            "physical_writes_direct": 14,
            "physical_writes_from_cache": 9,
            "process_last_non_idle_time": 1667968313,
            "queries_parallelized": 2,
            "recovery_blocks_read": 0,
            "recursive_calls": 220113,
            "recursive_cpu_usage": 1462,
            "redo_blocks_written": 9478,
            "redo_buffer_allocation_retries": 4,
            "redo_log_space_requests": 4,
            "redo_log_space_wait_time": 2,
            "redo_size": 4568196,
            "redo_synch_time": 73,
            "redo_write_time": 277,
            "redo_writes": 476,
            "session_cursor_cache_count": 4017,
            "session_cursor_cache_hits": 52537,
            "session_logical_reads": 371800,
            "session_stored_procedure_space": 0,
            "smon_posted_for_instance_recovery": 0,
            "smon_posted_for_txn_recovery_for_other_instances": 0,
            "sorts_disk": 0,
            "sorts_memory": 11360,
            "sorts_rows": 153397,
            "table_scan_rows_gotten": 3049493,
            "table_scans_direct_read": 0,
            "table_scans_long_tables": 0,
            "table_scans_rowid_ranges": 0,
            "transaction_rollbacks": 6,
            "user_calls": 564,
            "user_commits": 62,
            "user_rollbacks": 1
        }
    },
    "service": {
        "address": "oracle:1521",
        "type": "sql"
    }
}

Performance Metrics

Performance metrics give an overview of where time is spent in the system and enable comparisons of wait times across the system.

To collect the Performance metrics, Oracle integration relies on a specific set of views. Make sure that the user configured within the Oracle DSN configuration has READ access permissions to the following views:

V$BUFFER_POOL_STATISTICS
V$SESSTAT
V$SYSSTAT
V$LIBRARYCACHE
DBA_JOBS
GV$SESSION
V$SYSTEM_WAIT_CLASS

Exported fields

Field	Description	Type	Unit	Metric Type
@timestamp	Date/time when the event originated. This is the date/time extracted from the event, typically representing when the event was generated by the source. If the event source has no original timestamp, this value is typically populated by the first time the event was received by the pipeline. Required field for all events.	date
agent.id	Unique identifier of this agent (if one exists). Example: For Beats this would be beat.id.	keyword
cloud.account.id	The cloud account or organization id used to identify different entities in a multi-tenant environment. Examples: AWS account id, Google Cloud ORG Id, or other unique identifier.	keyword
cloud.availability_zone	Availability zone in which this host, resource, or service is located.	keyword
cloud.instance.id	Instance ID of the host machine.	keyword
cloud.provider	Name of the cloud provider. Example values are aws, azure, gcp, or digitalocean.	keyword
cloud.region	Region in which this host, resource, or service is located.	keyword
container.id	Unique container id.	keyword
data_stream.dataset	The field can contain anything that makes sense to signify the source of the data. Examples include `nginx.access`, `prometheus`, `endpoint` etc. For data streams that otherwise fit, but that do not have dataset set we use the value "generic" for the dataset value. `event.dataset` should have the same value as `data_stream.dataset`. Beyond the Elasticsearch data stream naming criteria noted above, the `dataset` value has additional restrictions: * Must not contain `-` * No longer than 100 characters	constant_keyword
data_stream.namespace	A user defined namespace. Namespaces are useful to allow grouping of data. Many users already organize their indices this way, and the data stream naming scheme now provides this best practice as a default. Many users will populate this field with `default`. If no value is used, it falls back to `default`. Beyond the Elasticsearch index naming criteria noted above, `namespace` value has the additional restrictions: * Must not contain `-` * No longer than 100 characters	constant_keyword
data_stream.type	An overarching type for the data stream. Currently allowed values are "logs" and "metrics". We expect to also add "traces" and "synthetics" in the near future.	constant_keyword
ecs.version	ECS version this event conforms to. `ecs.version` is a required field and must exist in all events. When querying across multiple indices -- which may conform to slightly different ECS versions -- this field lets integrations adjust to the schema version of the events.	keyword
event.dataset	Event module	constant_keyword
event.module	Event module	constant_keyword
host.ip	Host ip addresses.	ip
host.name	Name of the host. It can contain what `hostname` returns on Unix systems, the fully qualified domain name, or a name specified by the user. The sender decides which value to use.	keyword
oracle.performance.buffer_pool	Name of the buffer pool in the instance.	keyword
oracle.performance.cache.buffer.hit.pct	The cache hit ratio of the specified buffer pool.	double	percent	gauge
oracle.performance.cache.get.consistent	Consistent gets statistic.	long		gauge
oracle.performance.cache.get.db_blocks	Database blocks gotten.	long		gauge
oracle.performance.cache.physical_reads	Physical reads. This metric represents the number of data blocks read from disk per second during a time period.	long		gauge
oracle.performance.cursors.avg	Average cursors opened by username and machine.	double		gauge
oracle.performance.cursors.cache_hit.pct	Ratio of session cursor cache hits from total number of cursors.	double	percent	gauge
oracle.performance.cursors.max	Max cursors opened by username and machine.	double		gauge
oracle.performance.cursors.opened.current	Total number of current open cursors.	long		gauge
oracle.performance.cursors.opened.total	Total number of cursors opened since the instance started.	long		counter
oracle.performance.cursors.parse.real	"Real number of parses that occurred: session cursor cache hits - parse count (total)."	double		gauge
oracle.performance.cursors.parse.total	Total number of parse calls (hard and soft). A soft parse is a check on an object already in the shared pool, to verify that the permissions on the underlying object have not changed.	long		gauge
oracle.performance.cursors.session.cache_hits	Number of hits in the session cursor cache. A hit means that the SQL statement did not have to be reparsed.	double		gauge
oracle.performance.cursors.total	Total opened cursors by username and machine.	double		gauge
oracle.performance.failed_db_jobs	This metric checks for failed DBMS jobs.	double		gauge
oracle.performance.io_reloads	Reloads by Pins ratio. A Reload is any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk. Pins are the number of times a PIN was requested for objects of this namespace.	double		gauge
oracle.performance.lock_requests	Average of the ratio between 'gethits' and 'gets', where 'gethits' the number of times an object's handle was found in memory and 'gets' is the number of times a lock was requested for objects of this namespace.	double		gauge
oracle.performance.machine	Operating system machine name.	keyword
oracle.performance.pin_requests	Average of all pinhits/pins ratios, where 'PinHits' is the number of times all of the metadata pieces of the library object were found in memory and 'pins' is the number of times a PIN was requested for objects of this namespace.	double		gauge
oracle.performance.query_id	Autogenerated ID representing the Oracle query that is executed to fetch the results.	keyword
oracle.performance.session_count.active	Total count of sessions.	double		gauge
oracle.performance.session_count.inactive	Total count of Inactive sessions.	double		gauge
oracle.performance.session_count.inactive_morethan_onehr	Total inactive sessions more than one hour.	double		gauge
oracle.performance.username	Oracle username	keyword
oracle.performance.wait.pct_time	Percentage of time waits that are not Idle wait class.	double	percent	gauge
oracle.performance.wait.pct_waits	Percentage of number of pct time waits that are not of Idle wait class.	double	percent	gauge
oracle.performance.wait.time_waited_secs	Amount of time spent in the wait class by the session.	double	s	gauge
oracle.performance.wait.total_waits	Number of times waits of the class occurred for the session.	double		counter
oracle.performance.wait.wait_class	Every wait event belongs to a class of wait event. Wait classes can be one of the following - Administrative, Application, Cluster, Commit, Concurrency, Configuration, Idle, Network, Other, Scheduler, System IO, User IO	keyword
service.address	Address where data about this service was collected from. This should be a URI, network address (ipv4:port or [ipv6]:port) or a resource path (sockets).	keyword
service.type	The type of the service data is collected from. The type can be used to group and correlate logs and metrics from one service type. Example: If logs or metrics are collected from Elasticsearch, `service.type` would be `elasticsearch`.	keyword

An example event for performance looks as following:

{
    "@timestamp": "2022-11-09T04:24:38.581Z",
    "agent": {
        "ephemeral_id": "622d8585-de9d-4fbf-8a16-0f16a7cc5429",
        "id": "a7ec6f52-409e-4f25-80e6-a221e04812c7",
        "name": "docker-custom-agent",
        "type": "metricbeat",
        "version": "8.4.3"
    },
    "cloud": {
        "account": {
            "id": "elastic-obs-integrations-dev"
        },
        "availability_zone": "asia-south1-c",
        "instance": {
            "id": "3010911784348669868",
            "name": "service-integration-dev-idc-01"
        },
        "machine": {
            "type": "n1-standard-8"
        },
        "project": {
            "id": "elastic-obs-integrations-dev"
        },
        "provider": "gcp",
        "service": {
            "name": "GCE"
        }
    },
    "data_stream": {
        "dataset": "oracle.performance",
        "namespace": "ep",
        "type": "metrics"
    },
    "ecs": {
        "version": "8.0.0"
    },
    "elastic_agent": {
        "id": "a7ec6f52-409e-4f25-80e6-a221e04812c7",
        "snapshot": false,
        "version": "8.4.3"
    },
    "event": {
        "agent_id_status": "verified",
        "dataset": "oracle.performance",
        "duration": 93046359,
        "ingested": "2022-11-09T04:24:38Z",
        "module": "sql"
    },
    "host": {
        "architecture": "x86_64",
        "containerized": true,
        "hostname": "docker-custom-agent",
        "id": "702b305d5bf3433b8efe81033888bd28",
        "ip": [
            "172.26.0.3",
            "192.168.240.4"
        ],
        "mac": [
            "02:42:ac:1a:00:03",
            "02:42:c0:a8:f0:04"
        ],
        "name": "docker-custom-agent",
        "os": {
            "codename": "focal",
            "family": "debian",
            "kernel": "5.4.0-1078-gcp",
            "name": "Ubuntu",
            "platform": "ubuntu",
            "type": "linux",
            "version": "20.04.5 LTS (Focal Fossa)"
        }
    },
    "metricset": {
        "name": "query",
        "period": 60000
    },
    "oracle": {
        "performance": {
            "buffer_pool": "DEFAULT",
            "cache": {
                "buffer": {
                    "hit": {
                        "pct": 0.952424765502866
                    }
                },
                "get": {
                    "consistent": 344187,
                    "db_blocks": 24261
                },
                "physical_reads": 17529
            }
        }
    },
    "service": {
        "address": "oracle:1521",
        "type": "sql"
    }
}

Changelog

Version	Details	Kibana version(s)
1.25.0	Enhancement View pull request Add global filter on data_stream.dataset to improve performance.	8.10.2 or higher
1.24.3	Bug fix View pull request README updates regarding mandatory user permission.	8.10.2 or higher
1.24.2	Bug fix View pull request README updates regarding DSN formats.	8.10.2 or higher
1.24.1	Enhancement View pull request Make Oracle DSN configuration details more discoverable.	8.10.2 or higher
1.24.0	Enhancement View pull request Document alternate method of adding runtime library path.	8.10.2 or higher
1.23.0	Enhancement View pull request Add custom number formatting to visualizations.	8.10.2 or higher
1.22.0	Enhancement View pull request Update the package format_version to 3.0.0.	8.8.0 or higher
1.21.0	Enhancement View pull request Adapt fields for changes in file system info	8.8.0 or higher
1.20.2	Bug fix View pull request Add null check and ignore_missing check to the rename processor	8.8.0 or higher
1.20.1	Bug fix View pull request Resolved `ORA-01476` error in `Performance` datastream.	8.8.0 or higher
1.20.0	Enhancement View pull request Add support for processors	8.8.0 or higher
1.19.0	Enhancement View pull request Enable time series data streams for the metrics datasets. This dramatically reduces storage for metrics and is expected to progressively improve query performance. For more details, see https://www.elastic.co/guide/en/elasticsearch/reference/current/tsds.html.	8.8.0 or higher
1.18.0	Enhancement View pull request Rename ownership from obs-service-integrations to obs-infraobs-integrations	8.6.0 or higher
1.17.2	Bug fix View pull request Fixed dimension fields for all datastreams.	8.6.0 or higher
1.17.1	Bug fix View pull request Fix aggregation of `Performance` data stream visualization.	8.6.0 or higher
1.17.0	Enhancement View pull request Migrate `Overview` dashboard visualizations to lens	8.6.0 or higher
1.16.0	Enhancement View pull request Migrate `Performance` dashboard visualizations to lens	—
1.15.0	Enhancement View pull request Migrate `System Statistics` dashboard visualizations to lens	—
1.14.0	Enhancement View pull request Migrate `Tablespace` dashboard visualizations to lens	—
1.13.0	Enhancement View pull request Migrate `Memory` dashboard visualizations to lens	—
1.12.0	Enhancement View pull request Migrate `Sysmetric` dashboard visualizations to lens	—
1.11.2	Enhancement View pull request Updated dimension field mapping for all datastream.	8.3.0 or higher
1.11.1	Enhancement View pull request Added categories and/or subcategories.	8.3.0 or higher
1.11.0	Enhancement View pull request Add dimension fields to all dataset to support TSDB enablement.	8.3.0 or higher
1.10.1	Bug fix View pull request Dashboard fixes to represent Parse Count and Cache Hit Percentage Value"	8.3.0 or higher
1.10.0	Enhancement View pull request Update package to ECS 8.6.0.	8.3.0 or higher
1.9.2	Enhancement View pull request Included the details of supported host configurations in README.	8.3.0 or higher
1.9.1	Enhancement View pull request Added system testing files.	8.3.0 or higher
1.9.0	Enhancement View pull request Added infrastructure category.	8.3.0 or higher
1.8.0	Enhancement View pull request Update package to ECS 8.5.0.	8.3.0 or higher
1.7.0	Enhancement View pull request Added support for additional database audit events that only include actions.	8.3.0 or higher
1.6.0	Enhancement View pull request Added support for database audit events, originally it was only supporting objects.	8.3.0 or higher
1.5.0	Bug fix View pull request Add support for specially crafted action lines.	8.3.0 or higher
1.4.2	Bug fix View pull request Pipeline issue fixes in Performance datastream.	8.3.0 or higher
1.4.1	Bug fix View pull request Remove duplicate field.	8.3.0 or higher
1.4.0	Enhancement View pull request Enhancement to capture system statistics metrics, pga metrics, sga metrics.	8.3.0 or higher
1.3.0	Enhancement View pull request Update package to ECS 8.4.0	8.3.0 or higher
1.2.0	Enhancement View pull request Enhancement to capture performance, tablespace and sysmetrics metric data for Oracle database	8.3.0 or higher
1.1.1	Enhancement View pull request Update package name and description to align with standard wording	7.17.0 or higher 8.0.0 or higher
1.1.0	Enhancement View pull request Update package to ECS 8.3.0.	7.17.0 or higher 8.0.0 or higher
1.0.2	Bug fix View pull request Supporting the double digit date parsing in ingest pipeline for oracle logs	7.17.0 or higher 8.0.0 or higher
1.0.1	Enhancement View pull request Add documentation for multi-fields	7.17.0 or higher 8.0.0 or higher
1.0.0	Enhancement View pull request Initial Release	7.17.0 or higher 8.0.0 or higher

On this page

Article navigation

Requirements

Oracle Database Connection Pre-requisites

Oracle Instant Client

Enable Listener

Oracle DSN Configuration

Compatibility

Audit Log

Tablespace Metrics

Sysmetrics

Memory Metrics

System Statistics Metrics

Performance Metrics

Changelog