Oracle Database monitoring integration

Our Oracle Database integration collects key performance metrics on databases, tablespaces, and memory by default. You can customize your configuration to collect even more metrics, giving you detailed characterization of database performance.

Read on to install the integration, and to see what data we collect.

Compatibility and requirements

Our integration is compatible with Oracle Database from versions 11.2 to 23.

Before installing the integration, make sure that you meet the following requirements:

Linux distro compatible with infrastructure, except for RHEL/CentOS/OEL versions lower than 7.
Install the infrastructure agent.
Oracle Instant Client on the agent box.
Oracle database with ORACLE_HOME configured to the correct directory for the root user.
Oracle database user with both CONNECT and SELECT privileges on the required global views.
Oracle database with a listener.ora file configured to monitor from a remote connection. By default, Oracle Database only listens to localhost.

Important

ARM64 architecture is not supported.

Install and activate

To install the Oracle Database integration:

Install the infrastructure agent, and replace the INTEGRATION_FILE_NAME variable with nri-oracledb.
Change directory to the integrations folder:
bash
```
$cd /etc/newrelic-infra/integrations.d
```

Copy the sample configuration file:

bash

$sudo cp oracledb-config.yml.sample oracledb-config.yml

Edit the oracledb-config.yml file as described in the configuration settings.

Additional notes:

Advanced: It's also possible to install the integration from a tarball file. This gives you full control over the installation and configuration process.
On-host integrations do not automatically update. For best results, regularly update the integration package and the infrastructure agent.

Did this doc help with your installation?

Configuration

Enabling your Oracle DB Server

In the Oracle database, execute the following statements to create a new user and assign user privileges. USERNAME and similar user-specific values must be replaced.

Choose which kind of database you have. For assistance with user maintenance questions, consult the Oracle docs or contact your system or database administrator.
For standalone database if you use Oracle DB 12c or higher, use ALTER SESSION to access the database and manage users and user properties. Do not run this query if your Oracle DB version is lower than 12c.
ALTER SESSION set "_Oracle_SCRIPT"=true;
Use CREATE USER to add a new user to the database. Replace USER_PASSWORD with the new user's password.
CREATE USER USERNAME IDENTIFIED BY "USER_PASSWORD";
For multitenant databases, log in to the root database as an administrator. Use CREATE USER to add a new user to the database. Specified username will be a 'common user' and needs to be prefixed with 'c##' as recommended by Oracle. Replace USER_PASSWORD with the new user's password.
CREATE USER c##USERNAME IDENTIFIED BY "USER_PASSWORD";
Grant permission to new user to access all container objects (or specific container by mentioning PDB container name and root container name in 'CONTAINER_DATA').
ALTER USER c##USERNAME SET CONTAINER_DATA=ALL CONTAINER=CURRENT;
Grant CONNECT privileges to the user:
```
GRANT CONNECT TO USERNAME;
```

Grant SELECT privileges to the user on the following global views:

cdb_data_files
cdb_pdbs
cdb_users
gv_$sysmetric
gv_$pgastat
gv_$instance
gv_$filestat
gv_$parameter
sys.dba_data_files
gv_$session
gv_$sesstat
gv_$statname
gv_$rowcache
gv_$sga
gv_$sysstat
v_$database
gv_$librarycache
gv_$sqlarea
gv_$system_event
dba_tablespaces
gv_$session_wait
gv_$rollstat

v_$instance

Execute the following SQL statements together in one script, or individually:

GRANT SELECT ON cdb_data_files TO USERNAME;
GRANT SELECT ON cdb_pdbs TO USERNAME;
GRANT SELECT ON cdb_users TO USERNAME;
GRANT SELECT ON gv_$sysmetric TO USERNAME;
GRANT SELECT ON gv_$pgastat TO USERNAME;
GRANT SELECT ON gv_$instance TO USERNAME;
GRANT SELECT ON gv_$filestat TO USERNAME;
GRANT SELECT ON gv_$parameter TO USERNAME;
GRANT SELECT ON sys.dba_data_files TO USERNAME;
GRANT SELECT ON DBA_TABLESPACES TO USERNAME;
GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO USERNAME;
GRANT SELECT ON gv_$session TO USERNAME;
GRANT SELECT ON gv_$sesstat TO USERNAME;
GRANT SELECT ON gv_$statname TO USERNAME;
GRANT SELECT ON gv_$rowcache TO USERNAME;
GRANT SELECT ON gv_$sga TO USERNAME;
GRANT SELECT ON gv_$sysstat TO USERNAME;
GRANT SELECT ON v_$database TO USERNAME;
GRANT SELECT ON gv_$librarycache TO USERNAME;
GRANT SELECT ON gv_$sqlarea TO USERNAME;
GRANT SELECT ON gv_$system_event TO USERNAME;
GRANT SELECT ON dba_tablespaces TO USERNAME;
GRANT SELECT ON gv_$session_wait TO USERNAME;
GRANT SELECT ON gv_$rollstat TO USERNAME;
GRANT SELECT ON v_$instance TO USERNAME;

To collect PDB metrics, grant gv$con_sysmetric privileges by running:

GRANT SELECT ON gv$con_sysmetric TO USERNAME;

Configure the integration

There are several ways to configure the integration, depending on how it was installed:

If enabled via Amazon ECS: see Monitor services running on ECS.
If installed on-host: edit the config in the integration's YAML config file, oracledb-config.yml.

An integration's YAML-format configuration is where you can place required login credentials and configure how data is collected. Which options you change depend on your setup and preference.

The configuration file has common settings applicable to all integrations like interval, timeout, inventory_source. To read all about these common settings refer to our Configuration Format document.

Important

If you are still using our Legacy configuration/definition files please refer to this document for help.

Specific settings related to Oracle DB are defined using the env section of the configuration file. These settings control the connection to your Oracle DB instance as well as other security settings and features. The list of valid settings is described in the next section of this document.

Oracle DB Instance Settings

The Oracle DB integration collects both Metrics(M) and Inventory(I) information. In the table, use the Applies To column for the settings available to each collection:

Setting	Description	Default	Applies To
SERVICE_NAME	The service name for the Oracle instance.	N/A	M/I
HOSTNAME	Hostname or IP where Oracle DB is running.	127.0.0.1	M/I
PORT	Port on which Oracle DB is listening.	1521	M/I
USERNAME	Username for accessing the Oracle DB server.	N/A	M/I
PASSWORD	Password for the given user.	N/A	M/I
CONNECTION_STRING	A full connection string such as those found in `tnsnames.ora`. Takes precedence over hostname, port, and service name.	N/A	M/I
ORACLE_HOME	Path to where `ORACLE_HOME` is. This field is required.	N/A	M/I
TABLESPACES	A JSON array of tablespaces to collect. If omitted, it collects all tablespaces. If empty, it skips tablespace metrics collection.	[]	M
IS_SYS_DBA	Indicates whether the authenticating user has SysDBA permissions.	false	M
IS_SYS_OPER	Indicates whether the authenticating user has SysOper permissions.	false	M
EXTENDED_METRICS	Indicates whether to collect extended metrics. Check which are extended metrics in the table below	false	M
SKIP_METRICS_GROUPS	Collected metrics are grouped together depending on the query used to obtain the data. These metric groups are listed here and can be skipped from collection by adding the name of the group to `SKIP_METRICS_GROUPS` in JSON array format. By default no group is skipped. See example below.	[]	M
DISABLE_CONNECTION_POOL	Disable connection pooling. Use only if the integration is getting errors when trying to establish new connections to Oracle DB.	false	M
MAX_OPEN_CONNECTIONS	Maximum number of simultaneous connections opened by the integration.	5	M
SYS_METRICS_SOURCE	Set it to `PDB` to collect application container metrics. Set it to `ALL` to collect multitenant container database (CDB) and customer-created pluggable databases (PDB) metrics. If you set it to any other value, you'll get `SYS` metrics for standalone and multitenant databases with CDB access only.	''	M
CUSTOM_METRICS_QUERY	A SQL query to collect custom metrics. See example below.	N/A	M
CUSTOM_METRICS_CONFIG	YAML configuration with one or more SQL queries to collect custom metrics. See example below.	false	M
METRICS	Set to `true` to enable metrics-only collection.	false
INVENTORY	Set to `true` to enable inventory-only collection.	false

The values for these settings can be defined in several ways:

Add the value directly to the configuration file. This is the most common way.
Replace the values from environment variables using the {{}} notation. This requires infrastructure agent 1.14.0+. For more on this, see more on infrastructure agent passthrough environment variables.
Use secrets management to protect sensible information, such as passwords, so that it's not exposed in plain text on the configuration file. For more information, see secrets management.

Labels and custom attributes

You can also decorate your metrics with labels. Labels allow you to add key/value pair attributes to your metrics so that you can query, filter, or group your metrics.

Even though our default sample configuration file includes examples of labels, they're optional. You can remove, modify, or add new ones.

labels:
   env: production
   role: load_balancer

Example configurations

This is the basic configuration used to collect metrics and inventory from your localhost. It uses default connection on port 1521. Do not forget to replace SERVICE_NAME and ORACLE_HOME with the correct values for your environment:

integrations:
  - name: nri-oracledb
    env:
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
    interval: 15s
    labels:
      environment: production
    inventory_source: config/oracledb

This configuration collects metrics every 15 seconds and inventory every 60 seconds:

integrations:
  - name: nri-oracledb
    env:
      METRICS: true
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
    interval: 15s
    labels:
      environment: production

  - name: nri-oracledb
    env:
      INVENTORY: true
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
    interval: 60s
    labels:
      environment: production
    inventory_source: config/oracledb

This configuration collects only metrics, including extended ones, filtering collection to only 2 tablespaces:

integrations:
  - name: nri-oracledb
    env:
      METRICS: true
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
      TABLESPACES: '["tablespace1", "tablespace2"]'
      EXTENDED_METRICS: true
    interval: 15s
    labels:
      environment: production

This configuration skips collection of some metrics by disabling some of the queries using SKIP_METRICS_GROUPS. The allowed list of metric groups, together with the queries and affected metrics, are listed in this document:

integrations:
  - name: nri-oracledb
    env:
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
      SKIP_METRICS_GROUPS: '["sgauga_total_memory", "redo_log_waits"]'
    interval: 15s
    labels:
      environment: production
    inventory_source: config/oracledb

You can use custom a custom query to collect additional metrics. Custom metrics will be added, by default, to the OracleCustomSample event sample.

Notes:

If you need to use multiple custom queries, remove this setting and use CUSTOM_METRICS_CONFIG instead.

Do not use ; in custom SQL statements.

integrations:
  - name: nri-oracledb
    env:
      METRICS: true
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
      CUSTOM_METRICS_QUERY: >-
        SELECT
          'physical_reads' AS "metric_name",
          'gauge' AS "metric_type",
          SUM(PHYRDS) AS "metric_value",
          INST_ID AS "instanceID"
        FROM gv$filestat
        GROUP BY INST_ID
    interval: 15s
    labels:
      environment: production

If you need multiple custom SQL queries, add them to oracledb-custom-query.yml, and reference that file on your configuration.

NOTE: CUSTOM_METRICS_CONFIG is only enabled if CUSTOM_METRICS_QUERY is not present.

integrations:
  - name: nri-oracledb
    env:
      METRICS: true
      SERVICE_NAME: ORACLE
      HOSTNAME: 127.0.0.1
      PORT: 1521
      USERNAME: oracledb_user
      PASSWORD: oracledb_password
      ORACLE_HOME: /app/oracle/product/version/database
      CUSTOM_METRICS_CONFIG: 'C:\path\to\oracledb-custom-query.yml'
    interval: 15s
    labels:
      environment: production

Here's an example oracledb-custom-query.yml.

queries:
  # Metric names are set to the column names in the query results
  - query: >-
      SELECT
        SUM(stat.gets) AS "gets",
        SUM(stat.waits) AS "waits",
        SUM(stat.waits)/SUM(stat.gets) AS "ratio",
        inst.inst_id
      FROM GV$ROLLSTAT stat, GV$INSTANCE inst
      WHERE stat.inst_id=inst.inst_id
      GROUP BY inst.inst_id

    # If not set explicitly here, metric type will default to
    # 'gauge' for numbers and 'attribute' for strings
    metric_types:
      gets: gauge

    # If unset, sample_name defaults to OracleCustomSample
    sample_name: MyCustomSample

Find and use data

To find your integration data in New Relic, go to one.newrelic.com > All capabilities > Infrastructure > Third-party services and select one of the Oracle Database integration links.

Oracle Database data is attached to the following event types:

OracleDatabaseSample
OracleTablespaceSample

For more on how to find and use your data, see Understand integration data.

Metric data

The Oracle Database integration collects the following metric data attributes. Each metric name is prefixed with a category indicator and a period, such as disk. or memory..

Database metrics

These attributes can be found by querying the OracleDatabaseSample event type.

Metric	Description	Extended
`db.activeParallelSessions`	Active parallel sessions.
`db.activeSerialSessions`	Active serial sessions.
`db.averageActiveSessions`	Average active sessions.
`db.backgroundCheckpointsPerSecond`	Checkpoints per second.
`db.backgroundCpuUsagePerSecond`	Background CPU usage per second.
`db.backgroundTimePerSecond`	Background time per second.
`db.blockChangesPerSecond`	DB block changes per second.
`db.blockChangesPerTransaction`	DB block changes per transaction.
`db.blockChangesPerUserCall`	DB block changes per user call.
`db.blockGetsPerSecond`	DB block gets per second.
`db.blockGetsPerTransaction`	DB block gets per transaction.
`db.blockGetsPerUserCall`	DB block gets per user call.
`db.branchNodeSplitsPerSecond`	Branch node splits per second.
`db.branchNodeSplitsPerTransaction`	Branch node splits per transaction.
`db.consistentReadChangesPerSecond`	Consistent read changes per second.
`db.consistentReadChangesPerTransaction`	Consistent read changes per transaction.
`db.consistentReadGetsPerSecond`	Consistent read gets per second.
`db.consistentReadGetsPerTransaction`	Consistent read gets per transaction.
`db.cpuTimeRatio Database`	CPU time ratio.
`db.cpuUsagePerSecond`	CPU usage per second.
`db.cpuUsagePerTransaction`	CPU usage per transaction.
`db.crBlocksCreatedPerSecond`	CR blocks created per second.
`db.crBlocksCreatedPerTransaction`	CR blocks created per transaction.
`db.crUndoRecordsAppliedPerSecond`	CR undo records applied per second.
`db.crUndoRecordsAppliedPerTransaction`	CR undo records applied per transaction.
`db.currentLogons`	Current logons count.
`db.currentOpenCursors`	Current open cursors count.
`db.cursorCacheHitsPerAttempts`	Cursor cache hit ratio.
`db.databaseCpuTimePerSecond`	Database time per second.
`db.dbwrCheckpointsPerSecond`	DBWR checkpoints per second.
`db.enqueueDeadlocksPerSecond`	Enqueue deadlocks per second.
`db.enqueueDeadlocksPerTransaction`	Enqueue deadlocks per transaction.
`db.enqueueRequestsPerSecond`	Enqueue requests per second.
`db.enqueueRequestsPerTransaction`	Enqueue requests per transaction.
`db.enqueueTimeoutsPerSecond`	Enqueue timeouts per second.
`db.enqueueTimeoutsPerTransaction`	Enqueue timeouts per transaction.
`db.enqueueWaitsPerSecond`	Enqueue waits per second.
`db.enqueueWaitsPerTransaction`	Enqueue waits per transaction.
`db.executionsPerSecond`	Executions per second.
`db.executionsPerTransaction`	Executions per transaction.
`db.executionsPerUserCall`	Executions per user call.
`db.fullIndexScansPerSecond`	Full index scans per second.
`db.fullIndexScansPerTransaction`	Full index scans per transaction.
`db.GcCrBlockRecievedPerSecond`	GC CR block received per second.
`db.GcCrBlockRecievedPerTransaction`	GC CR block received per transaction.
`db.GcCurrentBlockReceivedPerSecond`	GC current block received per second.
`db.GcCurrentBlockReceivedPerTransaction`	GC current block received per transaction.
`db.globalCacheAverageCrGetTime`	Global cache average CR get time.
`db.globalCacheAverageCurrentGetTime`	Global cache average current get time.
`db.hardParseCountPerSecond`	Hard parse count per second.
`db.hardParseCountPerTransaction`	Hard parse count per transaction.
`db.hostCpuUsagePerSecond`	Host CPU usage per second.
`db.hostCpuUtilization`	Host CPU utilization (percentage).
`db.leafNodeSplitsPerSecond`	Leaf node splits per second.
`db.leafNodeSplitsPerTransaction`	Leaf node splits per transaction.
`db.libraryCacheHitRatio`	Library cache hit ratio.
`db.libraryCacheMissRatio`	Library cache miss ratio.
`db.logicalReadsPerSecond`	Logical reads per second.
`db.logicalReadsPerTransaction`	Logical reads per transaction.
`db.logonsPerSecond`	Logons per second.
`db.logonsPerTransaction`	Logons per transaction.
`db.longTableScansPerSecond`	Long table scans per second.
`db.longTableScansPerTransaction`	Long table scans per transaction.
`db.openCursorsPerSecond`	Open cursors per second.
`db.openCursorsPerTransaction`	Open cursors per transaction.
`db.osLoad`	Current OS load.
`db.parseFailureCountPerSecond`	Parse failure count per second.
`db.parseFailureCountPerTransaction`	Parse failure count per transaction.
`db.pgaCacheHitPercentage`	PGA cache hit percentage.
`db.processLimitPercentage`	Process limit percentage.
`db.recursiveCallsPerSecond`	Recursive calls per second.
`db.recursiveCallsPerTransaction`	Recursive calls per transaction.
`db.redoWritesPerSecond`	Redo writes per second.
`db.redoWritesPerTransaction`	Redo writes per transaction.
`db.responseTimePerTransaction`	Response time per transaction.
`db.rowCacheHitRatio`	Row cache hit ratio.
`db.rowCacheMissRatio`	Row cache miss ratio.
`db.rowsPerSort`	Rows per sort.
`db.sessionCount`	Session count.
`db.sessionLimitPercentage`	Session limit percentage.
`db.sharedPoolFreePercentage`	Shared pool free percentage.
`db.softParseRatio`	Soft parse ratio.
`db.sortsPerUserCall`	Total sorts per user call.
`db.sqlServiceResponseTime`	SQL service response time.
`db.streamsPoolUsagePercentage`	Streams pool usage percentage.
`db.tableScansPerUserCall`	Total table scans per user call.
`db.totalIndexScansPerSecond`	Total index scans per second.
`db.totalIndexScansPerTransaction`	Total index scans per transaction.
`db.totalParseCountPerSecond`	Total parse count per second.
`db.totalParseCountPerTransaction`	Total parse count per transaction.
`db.totalTableScansPerSecond`	Total table scans per second.
`db.totalTableScansPerTransaction`	Total table scans per transaction.
`db.TransactionsPerLogon`	Transactions per logon.
`db.userCallsPerSecond`	User calls per second.
`db.userCallsPerTransaction`	User calls per transaction.
`db.userCallsRatio`	User calls ratio.
`db.userCommitsPercentage`	User commits percentage.
`db.userCommitsPerSecond`	User commits per second.
`db.userLimitPercentage`	User limit percentage.
`db.userRollbacksPercentage`	User rollbacks per transaction.
`db.userRollbacksPerSecond`	User rollbacks per second.
`db.userRollbackUndoRecordsAppliedPerSecond`	User rollback undo records applied per second.
`db.userRollbackUndoRecordsAppliedPerTransaction`	User rollback undo records applied per transaction.
`db.waitTimeRatio`	Database wait time ratio.
`db.capturedUserCalls`	Captured Used Calls
`db.executeWithoutParseRatio`	Execute Without Parse Ratio
`db.logonsPerSecond`	Logons Per Sec
`db.physicalReadBytesPerSecond`	Physical Read Bytes Per Sec
`db.physicalReadIORequestsPerSecond`	Pysical Read IO Requests Per Sec
`db.physicalReadsPerSecond`	Pysical Reads Per Sec
`db.physicalWriteBytesPerSecond`	Physical Writes Bytes Per Sec
`db.physicalWritesPerSecond`	Physical Writes Per Sec
`disk.blocksRead`	Number of block reads.
`disk.blocksWritten`	Number of block writes.
`disk.logicalReadsPerUserCall`	Logical reads per user call.
`disk.physicalLobsReadsPerSecond`	Physical reads direct lobs per second.
`disk.physicalLobsWritesPerSecond`	Physical writes direct lobs per second.
`disk.physicalReadBytesPerSecond`	Physical read total bytes per second.
`disk.physicalReadIoRequestsPerSecond`	Physical read total I/O requests per second.
`disk.physicalReadsPerSecond`	Physical reads direct per second.
`disk.physicalWriteBytesPerSecond`	Physical write total bytes per second.
`disk.physicalWriteIoRequestsPerSecond`	Physical write I/O requests per second.
`disk.physicalWritesPerSecond`	Physical writes direct per second.
`disk.physicalWriteTotalIoRequestsPerSecond`	Physical write total I/O requests per second.
`disk.reads`	Total number of physical reads.
`disk.readTimeInMilliseconds`	Amount of file read time.
`disk.sortPerSecond`	Disk sort per second.
`disk.sortPerTransaction`	Disk sort per transaction.
`disk.tempSpaceUsedInBytes`	Temp space used.
`disk.writes`	Total number of physical writes.
`disk.writeTimeInMilliseconds`	Amount of file write time.
`lockedAccounts`	Number of accounts whose `account_status` is not `OPEN`.
`longRunningQueries`	Number of long running (> 60s) queries.
`memory.bufferCacheHitRatio`	Buffer cache hit ratio.
`memory.globalCacheBlocksCorrupted`	Global cache blocks corrupted.
`memory.globalCacheBlocksLost`	Global cache blocks lost.
`memory.pgaAllocatedInBytes`	Current amount of PGA memory allocated by the instance.
`memory.pgaFreeableInBytes`	Maximum size of a work area executed in automatic mode.
`memory.pgaFreeableInBytes`	Number of bytes of PGA memory in all processes that could be freed back to the operating system.
`memory.pgaInUseInBytes`	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).
`memory.redoAllocationHitRatio`	Redo allocation hit ratio.
`memory.redoGeneratedBytesPerSecond`	Redo generated bytes per second.
`memory.redoGeneratedBytesPerTransaction`	Redo generated bytes per transaction.
`memory.sortsRatio`	Memory sorts ratio.
`network.ioMegabytesPerSecond`	I/O megabytes per second.
`network.ioRequestsPerSecond`	I/O requests per second.
`network.trafficBytePerSecond`	Network traffic volume per second.
`query.physicalLobsReadsPerTransaction`	Physical reads direct lobs per transaction.
`query.physicalLobsWritesPerTransaction`	Physical writes direct lobs per transaction.
`query.physicalReadsPerTransaction`	Physical reads direct per transaction.
`query.physicalReadsPerTransaction`	Physical reads per transaction.
`query.physicalWritesPerTransaction`	Physical writes direct per transaction.
`query.physicalWritesPerTransaction`	Physical writes per transaction.
`query.transactionsPerSecond`	User transaction per second.
`redoLog.logFileSwitch`	Number of redo log file switch events.
`redoLog.logFileSwitchArchivingNeeded`	Number of redo log file switch events that need archiving.
`redoLog.logFileSwitchCheckpointIncomplete`	Number of redo log file switch event checkpoints that are incomplete.
`redoLog.waits`	Number of redo log waits.
`rollbackSegments.gets`	Number of rollback segments gets.
`rollbackSegments.ratioWait`	Ratio of waits for rollback segments.
`rollbackSegments.waits`	Number of rollback segments waits.
`sga.bufferBusyWaits`	Number of SGA buffer busy waits.
`sga.fixedSizeInBytes`	SGA fixed size.
`sga.freeBufferInspected`	Number of SGA free buffer inspected.
`sga.freeBufferWaits`	Number of SGA free buffer waits.
`sga.hitRatio`	Hit ratio for the SGA.
`sga.logBufferAllocationRetriesRatio`	Retry ratio of allocations for the SGA log buffer.
`sga.logBufferRedoAllocationRetries`	Redo allocation ratio for the SGA log buffer.
`sga.logBufferRedoEntries`	Number of Redo entries in the SGA log buffer.
`sga.logBufferSpaceWaits`	Buffer space waits for the SGA log buffer.
`sga.redoBuffersInBytes`	SGA Redo buffers, in bytes.
`sga.sharedPoolDictCacheMissRatio`	Miss ratio for the SGA shared pool dictionary (dict) cache.
`sga.sharedPoolLibraryCacheHitRatio`	Hit ratio for the SGA shared pool library cache.
`sga.sharedPoolLibraryCacheReloadRatio`	Reload ratio for the SGA shared pool library cache.
`sga.sharedPoolLibraryCacheShareableMemoryPerStatementInBytes`	SGA cacheable memory per statement, in bytes.
`sga.sharedPoolLibraryCacheShareableMemoryPerUserInBytes`	SGA cacheable memory per user, in bytes.
`sga.ugaTotalMemoryInBytes`	Total memory in the User Global Area (UGA).
`sorts.diskInBytes`	Sorts disk usage, in bytes.
`sorts.memoryInBytes`	Sorts memory usage, in bytes.

Tablespace metrics

The Oracle Database integration collects the following tablespace metrics. These attributes can be found by querying the OracleTablespaceSample event type. Please note that tablespace usage metrics are not available for read-only standby databases - read more about this limitation in the Oracle Knowledgebase here.

Metric	Description	Extended
`tablespace.isOffline`	Boolean for tablespace offline status.
`tablespace.offlinePDBDatafiles`	The number of PDB datafiles that are offline.
`tablespace.offlineCDBDatafiles`	The number of CDB datafiles that are offline.
`tablespace.pdbDatafilesNonWrite`	The number of PDB datafiles in a non-writable state.
`tablespace.spaceConsumedInBytes`	Consumed amount of tablespace in bytes.
`tablespace.spaceReservedInBytes`	Total reserved tablespace in bytes.
`tablespace.spaceUsedPercentage`	Ratio of used to total tablespace.

Inventory data

The Oracle Database integration captures the configuration parameters of the Oracle database. The data is available on the Inventory page, under the config/oracledb source. For more about inventory data, see Understand integration data.

The integration captures data for the following Oracle Database configuration parameters:

Metric	Description
`DBFIPS_140`	Enable use of crypographic libraries in FIPS mode, public.
`O7_DICTIONARY_ACCESSIBILITY`	Version 7 dictionary accessibility support.
`active_instance_count`	Number of active instances in the cluster database.
`adg_account_info_tracking`	ADG user account info tracked in standby (`LOCAL`) or in primary (`GLOBAL`).
`allow_global_dblinks`	LDAP lookup for DBLINKS.
`allow_group_access_to_sga`	Allow read access for SGA to users of Oracle owner group.
`approx_for_aggregation`	Replace `exact_aggregation` with `approximate_aggregation`.
`approx_for_count_distinct`	Replace `count_distinct` with `approx_count_distinct`.
`approx_for_percentile`	Replace `percentile_*` with `approx_percentile`.
`aq_tm_processes`	Number of AQ time managers to start.
`archive_lag_target`	Maximum number of seconds of redos the standby could lose.
`asm_diskstring`	Disk set locations for discovery.
`asm_preferred_read_failure_groups`	Preferred read failure groups.
`audit_file_dest`	Directory in which auditing files are to reside.
`audit_sys_operations`	Enable sys auditing.
`audit_syslog_level`	Syslog facility and level.
`audit_trail`	Enable system auditing.
`autotask_max_active_pdbs`	Setting for autotask maximum maintenance PDBs.
`awr_pdb_autoflush_enabled`	Enable/Disable AWR automatic PDB flushing.
`awr_pdb_max_parallel_slaves`	Maximum concurrent AWR PDB MMON slaves per instance.
`awr_snapshot_time_offset`	Setting for AWR snapshot time offset.
`background_core_dump`	Core size for background processes.
`background_dump_dest`	Detached process dump directory.
`backup_tape_io_slaves`	Backup tape I/O slaves.
`bitmap_merge_area_size`	Maximum memory allow for bitmap merge.
`blank_trimming`	Blank trimming semantics parameter.
`buffer_pool_keep`	Number of database blocks/latches in keep buffer pool.
`buffer_pool_recycle`	Number of database blocks/latches in recycle buffer pool.
`cdb_cluster`	If `TRUE` startup in CDB cluster mode.
`cdb_cluster_name`	CDB cluster name.
`cell_offload_compaction`	Cell packet compaction strategy.
`cell_offload_decryption`	Enable SQL processing offload of encrypted data to cells.
`cell_offload_parameters`	Additional cell offload parameters.
`cell_offload_plan_display`	Cell offload explain plan display.
`cell_offload_processing`	Enable SQL processing offload to cells.
`cell_offloadgroup_name`	Set the offload group name.
`circuits`	Max number of circuits.
`client_result_cache_lag`	Client result cache maximum lag in milliseconds.
`client_result_cache_size`	Client result cache max size in bytes.
`clonedb`	Clone database.
`clonedb_dir`	CloneDB Directory.
`cluster_database`	If `TRUE` startup in cluster database mode.
`cluster_database_instances`	Number of instances to use for sizing cluster DB SGA structures.
`cluster_interconnects`	Interconnects for RAC use.
`commit_logging`	Transaction commit log write behaviour.
`commit_point_strength`	Bias this node has toward not preparing in a two-phase commit.
`commit_wait`	Transaction commit log wait behaviour.
`commit_write`	Transaction commit log write behaviour.
`common_user_prefix`	Enforce restriction on a prefix of a common `user`, `role`, or `profile` .
`compatible`	Database will be completely compatible with this software version.
`connection_brokers`	Connection brokers specification.
`containers_parallel_degree`	Parallel degree for a `CONTAINERS()` query.
`control_file_record_keep_time`	Control file record keep time in days.
`control_files`	Control file names list.
`control_management_pack_access`	Declares which manageability packs are enabled.
`core_dump_dest`	Core dump directory.
`cpu_count`	Number of CPUs for this instance.
`create_bitmap_area_size`	Size of create bitmap buffer for bitmap index.
`create_stored_outlines`	Create stored outlines for DML statements.
`cursor_bind_capture_destination`	Allowed destination for captured bind variables.
`cursor_invalidation`	Default for DDL cursor invalidation semantics.
`cursor_sharing`	Cursor sharing mode.
`cursor_space_for_time`	Use more memory in order to get faster execution.
`data_guard_sync_latency`	Data guard sync latency.
`data_transfer_cache_size`	Size of data transfer cache.
`db_16k_cache_size`	Size of cache for 16K buffers.
`db_2k_cache_size`	Size of cache for 2K buffers.
`db_32k_cache_size`	Size of cache for 32K buffers.
`db_4k_cache_size`	Size of cache for 4K buffers.
`db_8k_cache_size`	Size of cache for 8K buffers.
`db_big_table_cache_percent_target`	Big table cache target size in percentage.
`db_block_buffers`	Number of database blocks cached in memory.
`db_block_checking`	Header checking and data and index block checking.
`db_block_checksum`	Store checksum in DB blocks and check during reads.
`db_block_size`	Size of database block in bytes.
`db_cache_advice`	Buffer cache sizing advisory.
`db_cache_size`	Size of default buffer pool for standard block size buffers.
`db_create_file_dest`	Default database location.
`db_create_online_log_dest_1`	Online log/controlfile destination #1.
`db_create_online_log_dest_2`	Online log/controlfile destination #2.
`db_create_online_log_dest_3`	Online log/controlfile destination #3.
`db_create_online_log_dest_4`	Online log/controlfile destination #4.
`db_create_online_log_dest_5`	Online log/controlfile destination #5.
`db_domain`	Directory part of global database name stored with `CREATE DATABASE`.
`db_file_multiblock_read_count`	DB block to be read each I/O.
`db_file_name_convert`	Datafile name convert patterns and strings for standby/clone db.
`db_files`	Max allowable number of db files.
`db_flash_cache_file`	Flash cache file for default block size.
`db_flash_cache_size`	Flash cache size for `db_flash_cache_file`.
`db_flashback_retention_target`	Maximum flashback database log retention time in minutes..
`db_index_compression_inheritance`	Options for table or tablespace level compression inheritance.
`db_keep_cache_size`	Size of KEEP buffer pool for standard block size buffers.
`db_lost_write_protect`	Enable lost write detection.
`db_name`	Database name specified in `CREATE DATABASE`.
`db_performance_profile`	Database performance category.
`db_recovery_file_dest`	Default database recovery file location.
`db_recovery_file_dest_size`	Database recovery files size limit.
`db_recycle_cache_size`	Size of RECYCLE buffer pool for standard block size buffers.
`db_securefile`	Permit securefile storage during lob creation.
`db_ultra_safe`	Sets defaults for other parameters that control protection levels.
`db_unique_name`	Database unique name.
`db_unrecoverable_scn_tracking`	Track nologging SCN in controlfile.
`db_writer_processes`	Number of background database writer processes to start.
`dbwr_io_slaves`	DBWR I/O slaves.
`ddl_lock_timeout`	Timeout to restrict the time that DDLS wait for DML lock.
`default_sharing`	Default sharing clause.
`deferred_segment_creation`	Defer segment creation to first insert.
`dg_broker_config_file1`	Data guard broker configuration file #1.
`dg_broker_config_file2`	Data guard broker configuration file #2.
`dg_broker_start`	Start data guard broker (DMON process).
`diagnostic_dest`	Diagnostic base directory.
`disable_pdb_feature`	Disable features.
`disk_asynch_io`	Use asynch I/O for random access devices.
`dispatchers`	Specifications of dispatchers.
`distributed_lock_timeout`	Number of seconds a distributed transaction waits for a lock.
`dml_locks`	DML locks - one for each table modified in a transaction.
`dnfs_batch_size`	Max number of dNFS asynch I/O requests queued per session.
`dst_upgrade_insert_conv`	Enables/Disables internal conversions during DST upgrade.
`enable_automatic_maintenance_pdb`	Enable/Disable automated maintenance for non-root PDB.
`enable_ddl_logging`	Enable ddl logging.
`enable_dnfs_dispatcher`	Enable DNFS dispatcher.
`enable_goldengate_replication`	Goldengate replication enabled.
`enable_pluggable_database`	Enable pluggable database.
`enabled_PDBs_on_standby`	List of enabled PDB patterns.
`encrypt_new_tablespaces`	Whether to encrypt newly created tablespaces.
`event`	Debug event control - default null string.
`exafusion_enabled`	Enable exafusion.
`external_keystore_credential_location`	External keystore credential location.
`fal_client`	FAL client.
`fal_server`	FAL server list.
`fast_start_io_target`	Upper bound on recovery reads.
`fast_start_mttr_target`	MTTR target in seconds.
`fast_start_parallel_rollback`	Max number of parallel recovery slaves that may be used.
`file_mapping`	Enable file mapping.
`fileio_network_adapters`	Network adapters for File I/O.
`filesystemio_options`	IO operations on filesystem files.
`fixed_date`	Fixed `SYSDATE` value.
`forward_listener`	Forward listener.
`gcs_server_processes`	Number of background gcs server processes to start.
`global_names`	Enforce that database links have same name as remote database.
`global_txn_processes`	Number of background global transaction processes to start.
`hash_area_size`	Size of in-memory hash work area.
`heat_map`	ILM Heatmap Tracking.
`hi_shared_memory_address`	SGA starting address (high order 32-bits on 64-bit platforms).
`hs_autoregister`	Enable automatic server DD updates in HS agent self-registration.
`ifile`	Include file in `init.Ora`.
`inmemory_adg_enabled`	Enable IMC support on ADG.
`inmemory_automatic_level`	Enable Automatic In-Memory management.
`inmemory_clause_default`	Default in-memory clause for new tables.
`inmemory_expressions_usage`	Controls which In-Memory Expressions are populated in-memory.
`inmemory_force`	Force tables to be in-memory or not.
`inmemory_max_populate_servers`	Maximum inmemory populate servers.
`inmemory_optimized_arithmetic`	Controls whether or not DSBs are stored in-memory.
`inmemory_prefer_xmem_memcompress`	Prefer to store tables with given memcompress levels in xmem.
`inmemory_prefer_xmem_priority`	Prefer to store tables with given priority levels in xmem.
`inmemory_query`	Specifies whether in-memory queries are allowed.
`inmemory_size`	Size in bytes of in-memory area.
`inmemory_trickle_repopulate_servers_percent`	Inmemory trickle repopulate servers percent.
`inmemory_virtual_columns`	Controls which user-defined virtual columns are stored in-memory.
`inmemory_xmem_size`	Size in bytes of in-memory xmem area.
`instance_abort_delay_time`	Time to delay an internal initiated abort (in seconds).
`instance_groups`	List of instance group names.
`instance_mode`	Indicates whether the instance read-only or read-write or read-mostly.
`instance_name`	Instance name supported by the instance.
`instance_number`	Instance number.
`instance_type`	Type of instance to be executed.
`instant_restore`	Instant repopulation of datafiles.
`java_jit_enabled`	Java VM JIT enabled.
`java_max_sessionspace_size`	Max allowed size in bytes of a Java sessionspace.
`java_pool_size`	Size in bytes of java pool.
`java_restrict`	Restrict Java VM Access.
`java_soft_sessionspace_limit`	Warning limit on size in bytes of a Java sessionspace.
`job_queue_processes`	Maximum number of job queue slave processes.
`large_pool_size`	Size in bytes of large pool.
`ldap_directory_access`	RDBMS's LDAP access option.
`ldap_directory_sysauth`	OID usage parameter.
`license_max_sessions`	Maximum number of non-system user sessions allowed.
`license_max_users`	Maximum number of named users that can be created in the database.
`license_sessions_warning`	Warning level for number of non-system user sessions.
`listener_networks`	Listener registration networks.
`local_listener`	Local listener.
`lock_name_space`	Lock name space used for generating lock names for standby/clone database.
`lock_sga`	Lock entire SGA in physical memory.
`log_archive_config`	Log archive config.
`log_archive_dest`	Archival destination text string.
`log_archive_dest_1`	Archival destination #1 text string.
`log_archive_dest_10`	Archival destination #10 text string.
`log_archive_dest_11`	Archival destination #11 text string.
`log_archive_dest_12`	Archival destination #12 text string.
`log_archive_dest_13`	Archival destination #13 text string.
`log_archive_dest_14`	Archival destination #14 text string.
`log_archive_dest_15`	Archival destination #15 text string.
`log_archive_dest_16`	Archival destination #16 text string.
`log_archive_dest_17`	Archival destination #17 text string.
`log_archive_dest_18`	Archival destination #18 text string.
`log_archive_dest_19`	Archival destination #19 text string.
`log_archive_dest_2`	Archival destination #2 text string.
`log_archive_dest_20`	Archival destination #20 text string.
`log_archive_dest_21`	Archival destination #21 text string.
`log_archive_dest_22`	Archival destination #22 text string.
`log_archive_dest_23`	Archival destination #23 text string.
`log_archive_dest_24`	Archival destination #24 text string.
`log_archive_dest_25`	Archival destination #25 text string.
`log_archive_dest_26`	Archival destination #26 text string.
`log_archive_dest_27`	Archival destination #27 text string.
`log_archive_dest_28`	Archival destination #28 text string.
`log_archive_dest_29`	Archival destination #29 text string.
`log_archive_dest_3`	Archival destination #3 text string.
`log_archive_dest_30`	Archival destination #30 text string.
`log_archive_dest_31`	Archival destination #31 text string.
`log_archive_dest_4`	Archival destination #4 text string.
`log_archive_dest_5`	Archival destination #5 text string.
`log_archive_dest_6`	Archival destination #6 text string.
`log_archive_dest_7`	Archival destination #7 text string.
`log_archive_dest_8`	Archival destination #8 text string.
`log_archive_dest_9`	Archival destination #9 text string.
`log_archive_dest_state_1`	Archival destination #1 state text string.
`log_archive_dest_state_10`	Archival destination #10 state text string.
`log_archive_dest_state_11`	Archival destination #11 state text string.
`log_archive_dest_state_12`	Archival destination #12 state text string.
`log_archive_dest_state_13`	Archival destination #13 state text string.
`log_archive_dest_state_14`	Archival destination #14 state text string.
`log_archive_dest_state_15`	Archival destination #15 state text string.
`log_archive_dest_state_16`	Archival destination #16 state text string.
`log_archive_dest_state_17`	Archival destination #17 state text string.
`log_archive_dest_state_18`	Archival destination #18 state text string.
`log_archive_dest_state_19`	Archival destination #19 state text string.
`log_archive_dest_state_2`	Archival destination #2 state text string.
`log_archive_dest_state_20`	Archival destination #20 state text string.
`log_archive_dest_state_21`	Archival destination #21 state text string.
`log_archive_dest_state_22`	Archival destination #22 state text string.
`log_archive_dest_state_23`	Archival destination #23 state text string.
`log_archive_dest_state_24`	Archival destination #24 state text string.
`log_archive_dest_state_25`	Archival destination #25 state text string.
`log_archive_dest_state_26`	Archival destination #26 state text string.
`log_archive_dest_state_27`	Archival destination #27 state text string.
`log_archive_dest_state_28`	Archival destination #28 state text string.
`log_archive_dest_state_29`	Archival destination #29 state text string.
`log_archive_dest_state_3`	Archival destination #3 state text string.
`log_archive_dest_state_30`	Archival destination #30 state text string.
`log_archive_dest_state_31`	Archival destination #31 state text string.
`log_archive_dest_state_4`	Archival destination #4 state text string.
`log_archive_dest_state_5`	Archival destination #5 state text string.
`log_archive_dest_state_6`	Archival destination #6 state text string.
`log_archive_dest_state_7`	Archival destination #7 state text string.
`log_archive_dest_state_8`	Archival destination #8 state text string.
`log_archive_dest_state_9`	Archival destination #9 state text string.
`log_archive_duplex_dest`	duplex Archival destination text string.
`log_archive_format`	Archival destination format.
`log_archive_max_processes`	Maximum number of active ARCH processes.
`log_archive_min_succeed_dest`	Minimum number of archive destinations that must succeed.
`log_archive_start`	Start archival process on SGA initialization.
`log_archive_trace`	Establish archive operation tracing level.
`log_buffer`	Redo circular buffer size.
`log_checkpoint_interval`	Number of redo blocks checkpoint threshold.
`log_checkpoint_timeout`	Maximum time interval between checkpoints in seconds.
`log_checkpoints_to_alert`	Log checkpoint begin/end to alert file.
`log_file_name_convert`	Logfile name convert patterns and strings for standby/clone db.
`long_module_action`	Use longer module and action.
`max_datapump_jobs_per_pdb`	Maximum number of concurrent data pump jobs per PDB.
`max_dispatchers`	Max number of dispatchers.
`max_dump_file_size`	Maximum size (in bytes) of dump file.
`max_idle_time`	Maximum session idle time in minutes.
`max_iops`	MAX I/O per second.
`max_mbps`	MAX MB per second.
`max_pdbs`	Max number of pdbs allowed in CDB or Application ROOT.
`max_shared_servers`	Max number of shared servers.
`max_string_size`	Controls maximum size of `VARCHAR2`, `NVARCHAR2`, and `RAW` types in SQL.
`memoptimize_pool_size`	Size of cache for imoltp buffers.
`memory_max_target`	Max size for Memory Target.
`memory_target`	Target size of Oracle SGA and PGA memory.
`multishard_query_data_consistency`	Consistency setting for multishard queries.
`multishard_query_partial_results`	Enable partial results for multishard queries.
`nls_calendar`	NLS calendar system name.
`nls_comp`	NLS comparison.
`nls_currency`	NLS local currency symbol.
`nls_date_format`	NLS Oracle date format.
`nls_date_language`	NLS date language name.
`nls_dual_currency`	Dual currency symbol.
`nls_iso_currency`	NLS ISO currency territory name.
`nls_language`	NLS language name.
`nls_length_semantics`	Create columns using byte or char semantics by default.
`nls_nchar_conv_excp`	NLS raise an exception instead of allowing implicit conversion.
`nls_numeric_characters`	NLS numeric characters.
`nls_sort`	NLS linguistic definition name.
`nls_territory`	NLS territory name.
`nls_time_format`	Time format.
`nls_time_tz_format`	Time with time zone format.
`nls_timestamp_format`	Time stamp format.
`nls_timestamp_tz_format`	Timestamp with time zone format.
`noncdb_compatible`	Non-CDB Compatible.
`object_cache_max_size_percent`	Percentage of maximum size over optimal of the user session's object cache.
`object_cache_optimal_size`	Optimal size of the user session's object cache in bytes.
`ofs_threads`	Number of OFS threads.
`olap_page_pool_size`	Size of the olap page pool in bytes.
`one_step_plugin_for_pdb_with_tde`	Facilitate one-step plugin for PDB with TDE encrypted data.
`open_cursors`	Max number of cursors per session.
`open_links`	Max number of open links per session.
`open_links_per_instance`	Max number of open links per instance.
`optimizer_adaptive_plans`	Controls all types of adaptive plans.
`optimizer_adaptive_reporting_only`	Use reporting-only mode for adaptive optimizations.
`optimizer_adaptive_statistics`	Controls all types of adaptive statistics.
`optimizer_capture_sql_plan_baselines`	Automatic capture of SQL plan baselines for repeatable statements.
`optimizer_dynamic_sampling`	Optimizer dynamic sampling.
`optimizer_features_enable`	Optimizer plan compatibility parameter.
`optimizer_ignore_hints`	Enables the embedded hints to be ignored.
`optimizer_ignore_parallel_hints`	Enables embedded parallel hints to be ignored.
`optimizer_index_caching`	Optimizer percent index caching.
`optimizer_index_cost_adj`	Optimizer index cost adjustment.
`optimizer_inmemory_aware`	Optimizer in-memory columnar awareness.
`optimizer_mode`	Optimizer mode.
`optimizer_secure_view_merging`	Optimizer secure view merging and predicate pushdown/movearound.
`optimizer_use_invisible_indexes`	Usage of invisible indexes (`TRUE` or `FALSE`).
`optimizer_use_pending_statistics`	Control whether to use optimizer pending statistics.
`optimizer_use_sql_plan_baselines`	Use of SQL plan baselines for captured sql statements.
`os_authent_prefix`	Prefix for auto-logon accounts.
`os_roles`	Retrieve roles from the operating system.
`outbound_dblink_protocols`	Outbound DBLINK Protocols allowed.
`parallel_adaptive_multi_user`	Enable adaptive setting of degree for multiple user streams.
`parallel_degree_limit`	Limit placed on degree of parallelism.
`parallel_degree_policy`	Policy used to compute the degree of parallelism (`MANUAL`, `LIMITED`, `AUTO`, or `ADAPTIVE`).
`parallel_execution_message_size`	Message buffer size for parallel execution.
`parallel_force_local`	Force single instance execution.
`parallel_instance_group`	Instance group to use for all parallel operations.
`parallel_max_servers`	Maximum parallel query servers per instance.
`parallel_min_degree`	Controls the minimum DOP computed by auto DOP.
`parallel_min_percent`	Minimum percent of threads required for parallel query.
`parallel_min_servers`	Minimum parallel query servers per instance.
`parallel_min_time_threshold`	Threshold above which a plan is a candidate for parallelization (in seconds).
`parallel_servers_target`	Instance target in terms of number of parallel servers.
`parallel_threads_per_cpu`	Number of parallel execution threads per CPU.
`pdb_file_name_convert`	PDB file name convert patterns and strings for create cdb/pdb.
`pdb_lockdown`	Pluggable database lockdown profile.
`pdb_os_credential`	Pluggable database OS credential to bind.
`pdb_template`	PDB template.
`permit_92_wrap_format`	Allow 9.2 or older wrap format in PL/SQL.
`pga_aggregate_limit`	Limit of aggregate PGA memory for the instance or PDB.
`pga_aggregate_target`	Target size for the aggregate PGA memory consumed by the instance.
`plscope_settings`	Plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier and SQL statement data.
`plsql_ccflags`	PL/SQL ccflags.
`plsql_code_type`	PL/SQL code-type.
`plsql_debug`	PL/SQL debug.
`plsql_optimize_level`	PL/SQL optimize level.
`plsql_v2_compatibility`	PL/SQL version 2.X compatibility flag.
`plsql_warnings`	PL/SQL compiler warnings settings.
`pre_page_sga`	Pre-page sga for process.
`private_temp_table_prefix`	Private temporary table prefix.
`processes`	User processes.
`processor_group_name`	Name of the processor group that this instance should run in.
`query_rewrite_enabled`	Allow rewrite of queries using materialized views if enabled.
`query_rewrite_integrity`	Perform rewrite using materialized views with desired integrity.
`rdbms_server_dn`	RDBMS's distinguished name.
`read_only_open_delayed`	If `TRUE` delay opening of read only files until first access.
`recovery_parallelism`	Number of server processes to use for parallel recovery.
`recyclebin`	Recyclebin processing.
`redo_transport_user`	Data guard transport user when using password file.
`remote_dependencies_mode`	Remote-procedure-call dependencies mode parameter.
`remote_listener`	Remote listener.
`remote_login_passwordfile`	Password file usage parameter.
`remote_os_authent`	Allow non-secure remote clients to use auto-logon accounts.
`remote_os_roles`	Allow non-secure remote clients to use os roles.
`remote_recovery_file_dest`	Default remote database recovery file location for refresh/relocate.
`replication_dependency_tracking`	Tracking dependency for replication parallel propagation.
`resource_limit`	Master switch for resource limit.
`resource_manage_goldengate`	Goldengate resource manager enabled.
`resource_manager_cpu_allocation`	Resource Manager CPU allocation.
`resource_manager_plan`	Resource mgr top plan.
`result_cache_max_result`	Maximum result size as percent of cache size.
`result_cache_max_size`	Maximum amount of memory to be used by the cache.
`result_cache_mode`	Result cache operator usage mode.
`result_cache_remote_expiration`	Maximum life time (min) for any result using a remote object.
`resumable_timeout`	Set resumable timeout.
`rollback_segments`	Undo segment list.
`sec_case_sensitive_logon`	Case sensitive password enabled for logon.
`sec_max_failed_login_attempts`	Maximum number of failed login attempts on a connection.
`sec_protocol_error_further_action`	TTC protocol error continue action.
`sec_protocol_error_trace_action`	TTC protocol error action.
`sec_return_server_release_banner`	Whether the server returns the complete version information.
`serial_reuse`	Reuse the frame segments.
`service_names`	Service names supported by the instance.
`session_cached_cursors`	Number of cursors to cache in a session.
`session_max_open_files`	Maximum number of open files allowed per session.
`sessions`	User and system sessions.
`sga_max_size`	Max total SGA size.
`sga_min_size`	Minimum, guaranteed size of PDB's SGA.
`sga_target`	Target size of SGA.
`shadow_core_dump`	Core size for shadow processes.
`shared_memory_address`	SGA starting address (low order 32-bits on 64-bit platforms).
`shared_pool_reserved_size`	Size in bytes of reserved area of shared pool.
`shared_pool_size`	Size in bytes of shared pool.
`shared_server_sessions`	Max number of shared server sessions.
`shared_servers`	Number of shared servers to start up.
`shrd_dupl_table_refresh_rate`	Duplicated table refresh rate (in seconds).
`skip_unusable_indexes`	Skip unusable indexes if set to `TRUE`.
`smtp_out_server`	Utl_smtp server and port configuration parameter.
`sort_area_retained_size`	Size of in-memory sort work area retained between fetch calls.
`sort_area_size`	Size of in-memory sort work area.
`spatial_vector_acceleration`	Enable spatial vector acceleration.
`spfile`	Server parameter file.
`sql92_security`	Require select privilege for searched update/delete.
`sql_trace`	Enable SQL trace.
`sqltune_category`	Category qualifier for applying hintsets.
`standby_db_preserve_states`	Preserve state cross standby role transition.
`standby_file_management`	If auto, files are created/dropped automatically on standby.
`standby_pdb_source_file_dblink`	Database link to standby source files.
`standby_pdb_source_file_directory`	Standby source file directory location.
`star_transformation_enabled`	Enable the use of star transformation.
`statistics_level`	Statistics level.
`streams_pool_size`	Size in bytes of the streams pool.
`tape_asynch_io`	Use asynch I/O requests for tape devices.
`target_pdbs`	Parameter is a hint to adjust certain attributes of the CDB.
`tde_configuration`	Per-PDB configuration for transparent tata encryption.
`temp_undo_enabled`	Is temporary undo enabled.
`thread`	Redo thread to mount.
`threaded_execution`	Threaded Execution Mode.
`timed_os_statistics`	Internal os statistic gathering interval in seconds.
`timed_statistics`	Maintain internal timing statistics.
`trace_enabled`	Enable in memory tracing.
`tracefile_identifier`	Trace file custom identifier.
`transactions`	Max. Number of concurrent active transactions.
`transactions_per_rollback_segment`	Number of active transactions per rollback segment.
`undo_management`	Instance runs in SMU mode if `TRUE`, else in RBU mode.
`undo_retention`	Undo retention in seconds.
`undo_tablespace`	Use/switch undo tablespace.
`unified_audit_sga_queue_size`	Size of unified audit SGA queue.
`unified_audit_systemlog`	Syslog facility and level for unified audit.
`uniform_log_timestamp_format`	Use uniform timestamp formats vs pre-12.2 formats.
`use_dedicated_broker`	Use dedicated connection broker.
`use_large_pages`	Use large pages if available (`TRUE`, `FALSE`, or `ONLY`).
`user_dump_dest`	User process dump directory.
`version`	Oracle Database version.
`xwallet_root`	Wallet root instance initialization parameter.
`workarea_size_policy`	Policy used to size SQL working areas (MANUAL``AUTO).

Troubleshooting

Troubleshooting tips:

This error will appear in the logs as [ERR] ORA-01284: Error while trying to retrieve text for error.

To avoid this error make sure ORACLE_HOME is set correctly for the agent process. The agent runs as root, so its environment is not the same as the oracle user.

To verify this setting, execute cat /proc/$(pgrep newrelic-infra)/environ to print out the environment variables for the infrastructure process, the output should include ORACLE_HOME if configured correctly.

Check the source code

This integration is open source software. That means you can browse its source code and send improvements, or create your own fork and build it.

Compatibility and requirements

Important

Install and activate

Did this doc help with your installation?

Configuration

Enabling your Oracle DB Server

Standalone database (Oracle DB 12c or higher)

Multitenant database

Configure the integration

Important

Oracle DB Instance Settings

Labels and custom attributes

Example configurations

Basic configuration

Basic configuration with different metric/inventory intervals

Metrics-only with extended metrics and tablespace filtering

Skip metrics groups

Custom Query

Multiple Custom Queries

Find and use data

Metric data

Database metrics

Tablespace metrics

Inventory data

Parameters

Troubleshooting

The Oracle library cannot be loaded

`ORACLE_HOME` is not set correctly

I get an `ORA` error

Check the source code

Oracle Database monitoring integration

Compatibility and requirements .css-21sua1{background:none;border:none;width:0;padding:0;}

Important

Install and activate

Did this doc help with your installation?

Configuration

Enabling your Oracle DB Server

Multitenant database

Configure the integration

Important

Oracle DB Instance Settings

Labels and custom attributes

Example configurations

Basic configuration

Basic configuration with different metric/inventory intervals

Metrics-only with extended metrics and tablespace filtering

Skip metrics groups

Custom Query

Multiple Custom Queries

Find and use data

Metric data

Database metrics

Tablespace metrics

Inventory data

Parameters

Troubleshooting

The Oracle library cannot be loaded

ORACLE_HOME is not set correctly

I get an ORA error

Check the source code

Compatibility and requirements

`ORACLE_HOME` is not set correctly

I get an `ORA` error