Introduction

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP and DW) database workloads.

Prerequisites

  • Requires Gateway 7.0.0 and above.

  • Add SSH credentials on target device (For which user has permissions to execute lsnrctl services  and srvctl commands).

Supported Versions
19.3.0.0.0
PrivilegeDescriptionExample
CONNECTGive the user connect role before assigning privileges.GRANT CONNECT TO MY_USER;
SELECT ANY DICTIONARYMinimum privilege to monitor all the G2 templates.GRANT SELECT ANY DICTIONARY TO MY_USER;

Discovery using the Agent

Collector Type: Agent

Category: Application Monitors

Application Name: oracledb

Global Template Name: DB-Oracle DotNet v4

Parameters

NameDefault ValueDescription
Host127.0.0.1IP Address of the server
PortThe port on which OracleDB server is running.
User NameNAThe username of the OracleDB Server, if authentication is enabled.
PasswordNAThe password of the OracleDB Server, if authentication is enabled.

Note: All field attributes are mandatory, use default values wherever applicable.

Collected Metrics

Metric NameDisplay NameDescriptionUnit
Oracle_BlockingLockQueriesOracle Blocking Lock QueriesValidates the number of block lock queries on a specific database.Count
Oracle_CacheInvalidationsOracle Cache InvalidationsValidates the number of cache invalidations on a specific database.Count
Oracle_DataFileDiskReadsOracle Data File Disk ReadsValidates the number of data file disk reads by the database.Count
Oracle_DataFileDiskWritesOracle Data File Disk WritesValidates the number of data file disk writes to database.Count
Oracle_DataFilelesizeAllocatedOracle Data File Disk AllocatedValidates the data file size allocated for the database.MB
Oracle_LibraryCacheGetsOracle Library Cache GetsValidates the number of Library Cache gets by database.Count
Oracle_LibraryCacheReloadsOracle Library Cache ReloadsValidates the number of Library Cache reloads by database.Count
Oracle_LongRunningQueriesOracle Long Running QueriesValidates the number of long running queries on a specific database.Count
Oracle_ProcessesOracle ProcessesValidates the number of processes on a specific database.Count
Oracle_SessionsOracle SessionsValidates the number of sessions currently on a specific database.Count
Oracle_TableSpaceAllocatedOracle Table Space AllocatedValidates the size allocated for the table by database.MB
Oracle_TableSpaceFreeOracle Table Space FreeValidates the free space allocated for the table by database.MB
Oracle_TablescanBlocksOracle Table scan BlocksValidates the number of table scan blocks by database.Count
Oracle_UserRollbacksOracle User RollbacksThis metric represents the number of times, per transaction during the sample period, that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.Count
Oracle_UsersCommitOracle Users CommitValidates the number of user commits.Count

Prerequisites

  • Database and port(1521) can be accessed by the gateway.
  • A gateway management profile mapped to a resource.
  • Create credentials with type Database before assigning a template to a resource. The Port, Connection Time-out, and Is Secure values are not used to create credentials.

Database discovery and monitoring

The administrator can deploy an agent or gateway to support OracleDB agent-based or agentless monitoring.

Discovery using the Gateway

The gateway establishes a connection to the database using the Java Database Connectivity (JDBC) Java API and collects metrics using SQL queries. To monitor an OracleDB, install gateway version 5.0.0 or later.

Use one of the following mechanisms to discover OracleDB servers to add them to your inventory:

  • WMI
  • SSH
  • SNMP

Optionally, add a database server manually to the infrastructure inventory:

  1. Select Infrastructure and click Resources.
  2. Click the Settings icon on the top-right and click Add.
  3. On the Add Device page, enter the Device Type and any other information you want to enter.
  4. Click Save.

Prepare the device to start monitoring

  1. Associate appropriate database credentials to the discovered database.
  2. Assign one or more database-specific global monitors or templates on the device.
    Optionally, create custom metrics or monitors using SQL queries and assign them to the database.

To track monitoring of OracleDB database in your cloud environment, see Monitoring Cloud Database using Gateway.

Create custom metrics

To create a metric using SQL query for OracleDB monitoring, navigate to Monitoring > Metrics > Create Metric. For example, to create a metric to check the DB instance use:

SELECT INSTANCE_NAME, DATABASE_STATUS FROM V$INSTANCE

For more information, see Create a Metric.

Note: When creating a custom metric using SQL query, do not add or append semicolon(; ) at the end of the query.

Assign templates from setup

Assign OracleDB templates to one or more resources for a selected client and change the configuration parameters while assigning templates. For more information, see Assign Templates from Setup.

Assign templates at the device level

Applying Oracle templates at the device level helps assign one or more templates to a specific resource. You can change the configuration parameter default values while assigning the templates. For more information, see Assign Templates at the Device Level.

Template configuration parameters

Configuration ParameterDescription
Connection Time-outThe maximum time to connect to the database. The driver waits for the specified time before timing out due to connection failure. The default time is 15000 milliseconds(ms).
Service Transport TypeTo configure the database at a secure end-point. The default type is In-secure. The connection is Secure when the data sent between the client and server is encrypted.
Service PortThe port number where the database is running. The connection is made to the specified port if you specify the port and the database name. The default port is 1521.
DB Instance NameThe name of the database to connect to. The default name is system.
  • If you have multiple database names with different ports, use the following syntax: `DBname1:Port1, DBname2:Port2,..` (Comma-separated). Create separate credential sets on the resource if databases consist of different users. For example, if DBname 1 has credential set A and DBname 2 has credential set B, create separate credentials sets on the resource.
  • If you have multiple database names with the same port, use the following syntax: `DBname1, DBname2,..` (Comma-separated).
Application TypeThe application type value to identify the adapter. For example, ORACLE_DB.
Warning: Do not change the default application type value.
TLS ConnectionThis enables users to keep an eye on the secure/encrypted databases (TCPS protocol). No is the default selection. Mark it as Yes to monitor encrypted databases.

Assign template from device management policies

Device management policies help manage resources. You can assign monitoring templates, knowledge base articles, and custom attributes using device management policies. The device management policy can be applied to one or a set of resources. For more information, see Create Policies.

View resource metrics

The gateway monitors the application using the assigned templates and displays the results in graphical format. To view resource metrics, click the database resource name > resource Details > Metrics.

OracleDB

Troubleshooting

If you have OracleDB monitoring issues, verify gateway, telnet, and database connectivity:

ping <IP Address>
telnet <IP Address> <Port>
gcli
db <Database Type> <IP Address> <User Name> <Password> <Port> <Database Name> <Connect Timeout> <ReadTimeout> <Secure Flag> <Query>

Beginning with gateway version 5.3.0, use the following format for the latest , including the result-set:

db <Database Type> <IP Address> <User Name> <Password> <Port> <Database Name> <Connect Timeout> <Read Timeout> <Secure Flag> <ResultSet?: Yes/No> <Query>

Supported templates

Collector TypeTemplate Name
GatewayG2-OracleDB-Database Monitoring
G2-OracleDB-Database backups
G2-OracleDB-Database scheduled jobs
G2-OracleDB-Database locking
G2-OracleDB-ASM Availability
G2-OracleDB-Database Space Usage
G2-OracleDB-ARCHIVER
G2-OracleDB-Password Security
G2-OracleDB-Alert Log Status
G2-OracleDB-Listener SID Availability
G2-OracleDB-Monitored License Used Status
G2-OracleDB-Database Resource Usage
G2-OracleDB-Listener
G2-OracleDB-DataGuard
G2-OracleDB-Sessions - v3.0
G2-OracleDB-Oracle Library Stats - v2.0
G2-OracleDB-Oracle Memory - v2.0
G2-OracleDB-Performance - v2.0
G2-OracleDB-Sessions - v2.0
G2-OracleDB-System Stats - v2.0
G2-OracleDB-System Summary - v2.0
G2-OracleDB-Table Space - v2.0 - v2.0

Supported metrics

Metric NameDisplay NameDescriptionUnit
Oracle_asm_alertlog_sizeOracle ASM AlertLog SizeThis metric monitors the disk used space (in MB) by ASM alert log.megabytes(MB)
Oracle_database_archivelog_total_usageOracle Database Archive Log Total UsageThis metric monitors the total size (in GB) of Archive log.Gigabytes(GB)
Oracle_database_archfile_usageOracle Database ArchFile UsageThis metric monitors the size (in MB) of each Arch file.MB
Oracle_database_datafile_availabilityOracle Database Datafile AvailabilityThis metric monitors the datafile availability. Below are the possible values:
1 - AVAILABLE
2 - INVALID
N/A
Oracle_database_invalid_objectsOracle Database Invalid ObjectsThis metric displays invalid objects available or not.N/A
Oracle_database_locked_critical_usersOracle Database Locked Critical UsersThis metric monitors the locked critical users information.N/A
Oracle_database_backup_modeOracle Database Backup ModeThis metric monitors the oracle database backup mode like Active or InActive.N/A
Oracle_database_archivegap_detectionOracle Database Archive Gap DetectionThis metric monitors the Archive GAP detection.N/A
Oracle_asm_diskgroup_typeOracle ASM Disk Group TypeThis metric displays the type of the ASM disk group.N/A
Oracle_asm_disk_mode_statusOracle Database Restore Point Guarantee Flashback StatusMonitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values:
YES - 1
NO - 0
N/A
Oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointMonitors the age (In Days) of last successful restore point.Days
Oracle_database_restorePoint_GuaranteeFlashback_StatusOracle Database Restore Point Guarantee Flashback StatusMonitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values:
YES - 1
NO - 0
N/A
oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointMonitors the age (In Days) of last successful restore point.Days
Oracle_database_blockCorruption_countOracle Database Block Corruption CountMonitors the count of block corruption in Oracle DB.Count
Oracle_database_blockCorruption_typeOracle Database Block Corruption TypeMonitor the type of block corruption in Oracle DB.N/A
Oracle_database_undoUnexpired_countOracle Database Undo Unexpired CountMonitors the count of Undo Unexpired in Oracle DB.Count
Oracle_database_indexLogging_countOracle Database Index Logging CountMonitors the count of Index logging in Oracle DB.Count
Oracle_database_licenseOptionUsage_statusOracle Database License Option Usage StatusMonitors the Oracle DB License Option Usage Status: Below are the possible values:
YES - 1
NO - 0
N/A
Oracle_database_redoLog_statusOracle Database RedoLog StatusMonitors the status of each redo log. Below are the possible values:
FileInUse (File is in use) - 0
INVALID (File is inaccessible) - 1
STALE (File's contents are incomplete) - 2
DELETED (File is no longer used) - 3
N/A
Oracle_database_backup_archiveOracle Database Archive Backup DaysAgoMonitors the status of the Oracle Database Archive Backup DaysAgo.Days
Oracle_database_backup_fullOracle Database Archive Backup DaysAgoMonitors the status of the Oracle Database Full Backup DaysAgo.Days
Oracle_database_backup_usermanagedOracle Database User Managed Backup DaysAgoMonitors the status of the Oracle Database User Managed Backup DaysAgoDays
Oracle_database_backup_incrementalOracle Database Incremental Backup DaysAgoMonitors the status of the Oracle Database Incremental Backup DaysAgo.Days
Oracle_database_backup_rmanOracle Database RMAN Backup DaysAgoMonitors the status of the Oracle Database RMAN Backup DaysAgo.Days
Oracle_database_scheduler_jobs_statusOracle Database Scheduler Jobs StatusMonitors the status of the Oracle Database Scheduler Jobs Status.N/A
Oracle_database_dbmsjobs_failure_countOracle Database DBMS Jobs Failure CountMonitors the status of the Oracle Database DBMS Jobs Failure Count.Count
Oracle_database_autotask_job_statusOracle Database AutoTask Job StatusMonitors the status of the Oracle Database AutoTask Job.N/A
Oracle_database_lockedusers_statusOracle Database Locked Users StatusMonitors the status of the Oracle Database Locked Users.N/A
Oracle_blocking_session_countOracle Blocking Session CountMonitors the status of the Oracle Blocking Session Count.Count
Oracle_asm_disk_statusOracle ASM Disk StatusMonitors the status of the Oracle ASM Disk.N/A
Oracle_asm_acfs_statusOracle ASM ACFS StatusMonitors the status Oracle ASM ACFS.N/A
Oracle_asm_diskgroup_utilizationOracle ASM DiskGroup Space UtilizationMonitors the status of the Oracle ASM DiskGroup Space Utilization.Percentage(%)
Oracle_database_required_mirror_freespaceOracle Database Required Mirror Free SpaceMonitors the status of the Oracle Database Including different redundancy requirements (Safely usable data usage).MB
Oracle_database_safelyusable_diskspaceOracle Database Safely Usable Disk SpaceMonitors the status of the Oracle Database Including safely usable disk space on different redundancy (Safely usable data usage).MB
Oracle_database_tablespace_usedPercentOracle Database Tablespace Used PercentMonitor the Oracle table space used percent.%
Oracle_database_flash_recovery_usageOracle Database Flash Recovery UsageFlash recovery usage (in MB) of the oracle database.MB
Oracle_database_flashback_log_usageOracle Database FlashBack Log UsageFlashBack Log usage in percent.%
Oracle_database_recoveryDest_used_percentageOracle Database RecoveryDest Used PercentageOracle Database Recovery Destination usage in Percent.%
Oracle_database_recoveryDest_sizeOracle Database RecoveryDest SizeOracle Database Recovery Destination Size in MB.MB
Oracle_database_recoveryDest_used_sizeOracle Database RecoveryDest Used SizeOracle Database Recovery Destination Used Size in MB.MB
Oracle_database_component_statusOracle Database Component StatusOracle Database DBA Registry Component Status.
Below are the possible values:
INVALID - 0
VALID - 1
LOADING - 2
LOADED - 3
UPGRADING - 4
UPGRADED - 5
DOWNGRADING - 6
DOWNGRADED - 7
REMOVING - 8
REMOVED - 9
N/A
Oracle_database_archiveLogModeOracle Database Archive Log ModeMonitors the archive log mode of the instance.
Below are the possible values:
0 - NOARCHIVELOG
1 - ARCHIVELOG
2 - MANUAL
N/A
Oracle_database_password_expiry_DaysOracle Database Password Expiry DaysMonitors the users password expiry in days.Days
Oracle_database_users_default_passwordOracle Database Users Default PasswordMonitors the count of users which are using default password.Count
Oracle_database_alertLog_availabilityOracle Database Alert Log AvailabilityMonitors the alert log availability of given instances.
Below are the possible values:
0 - Not Available
1 - Available
N/A
Oracle_database_alertLog_writeAccessibilityOracle Database Alert Log Write AccessibilityMonitors the alert log write accessibility of given instances.
Below are the possible values:
0 - Not Accessible
1 - Accessible
N/A
Oracle_database_alertLog_readAccessibilityOracle Database Alert Log Read AccessibilityMonitors the alert log read accessibility of given instances.
Below are the possible values:
0 - Not Accessible
1 - Accessible
N/A
Oracle_database_listenerSID_availabilityOracle Database Listener SID AvailabilityThis metric checks the availability of specific Oracle database instance SIDs (System Identifier) and reports whether they are currently running on the system.
Oracle_database_monitoredLicense_UsedstatusOracle Database Monitored License Used StatusIt provides an oracle monitored license list with currently used status.
Below are the possible values:
TRUE: 0
FALSE: 1
N/A
Oracle_database_resource_process_limitOracle Database Resource Process LimitMonitor the Oracle Database resource process limit.Count
Oracle_database_resource_session_limitOracle Database Resource Session LimitMonitor the Oracle Database resource session limit.Count
Oracle_database_listener_service_statusOracle Database Listener Service StatusThis metric monitors the status of database services associated with an Oracle listener.N/A
Oracle_database_local_listener_statusOracle Database Local Listener StatusThis metric is capturing the status of local Oracle listeners in an oracle RAC setup.N/A
Oracle_database_all_listener_status

Oracle Database All Listener StatusThis metric combines both the local listener status and the SCAN listener status into a single metric in an oracle RAC setup.N/A
Oracle_database_listener_status_with_nodes

Oracle Database Listener Status With NodesThis metric monitor the Oracle Database Listener Status With Nodes.N/A
Oracle_database_scan_listener_status

Oracle Database Scan Listener StatusThis metric monitor the status of Oracle Database Scan Listener.N/A
Oracle_database_listener_availability

Oracle Database Listener AvailabilityThis metric captures the availability status of Oracle Database services by interacting with the Oracle listener via the `lsnrctl` services command.N/A
Oracle_dg_database_role_change_withDGB

Oracle DataGuard DB Role Change with DataGuard BrokerIt monitor the Oracle DataGuard DB Role Change with DataGuard Broker.N/A
Oracle.session.limit.usage

Session Limit UsageIt monitors the sessions utilization.%
Oracle.inactive.sessions

Inactive SessionsIt monitors the inactive sessions.Count
Oracle.active.sessions

Active SessionsIt monitors the active sessions.Count
Oracle_session_waits_perEvent

Oracle Session Waits PerEventMonitors the sum of "session waits" per each event and class (event for which sessions have just completed waiting or are currently waiting).S
Oracle_system_waits_perClass

Oracle System Waits PerClassMonitor oracle system class waits (The system-level waits represent a high level summary of all session-level waits). This metric evaluated using this formula avg of waits = sum(time_waited)/sum(total_waits).S
Oracle_database_avgGlobalLockGetTime

Oracle Database Average Global Lock Get TimeIt monitors the average global lock get time (in milliseconds).Milliseconds(ms)
Oracle_database_bufferCachehitRatio

Oracle Database Buffer Cache Hit RatioIt monitors the buffer cache hit ratio.%
Oracle_database_chainedRows

Oracle Database Chained RowsIt monitors the count of chained rows from all available tables in oracle database.Count
Oracle_database_dictionaryCacheHitRatio

Oracle Database Dictionary Cache Hit RatioIt monitors the Dictionary cache hit ratio.%
Oracle_database_gc_blocks_corrupt

Oracle Database Global Cache Blocks CorruptIt monitors the value of the global cache blocks corrupt.Count
Oracle_database_gc_blocks_lost

Oracle Database Global Cache Blocks LostIt monitors the value of the global cache blocks lost.N/A
Oracle_database_gc_cr_timeouts

Oracle Database Global Cache Consistent Read TimeoutsIt monitors the value of global cache consistent read timeouts. This statistic is available in older oracle versions only.N/A
Oracle_database_gc_convert_timeouts

Oracle Database Global Cache Convert TimeoutsIt monitors the value of global cache convert timeouts, This statistic is available in older oracle versions only.N/A
Oracle_database_gc_service_utilization

Oracle Database Global Cache Service UtilizationIt monitors the value of global cache service utilization, This statistic is available in older oracle versions only.%
Oracle_database_unUsable_index_count

Oracle Database UnUsable Index CountIt monitors the count of the unusable indexes in the oracle database.Count
Oracle_database_cacheFusionWrites

Oracle Database Cache Fusion Writes RatioIt monitors the ratio of cache fusion writes.%
Oracle_database_redoLog_contention

Oracle Database Redo Log ContentionIt monitors the miss ratio for redo log latches. If the ratio of MISSES to GETS exceeds 1% then there is latch contention.%
oracle_database_memory_sortRatio

Oracle Database Memory Sort RatioIt monitors the ratio of memory sorts.%
Oracle_database_concurrentUsers

Oracle Database Concurrent UsersMonitors the count of concurrent users.Count
Oracle_database_overallSize

Oracle Database Overall SizeMonitors the oracle database size (in MB) based on data files, temp files, log files and the control files.MB
Oracle_database_size_withDataAndLogFiles

Oracle Database Size With Data And Log FilesMonitors the oracle database size (in MB) based on log and data files.MB
Oracle_database_locked_users_count

Oracle Database Locked UsersMonitors the number of users suspended by locks within a timeout.Count
Oracle_database_resource_utilization

Oracle Database Resource UtilizationMonitors the resource utilization for the resources: Processes, Sessions and Transactions.%
Oracle_database_pga_memory_usage

Oracle Database PGA Memory UsageMonitors the PGA memory usage (in Bytes) of the each oracle user.Bytes
Oracle_database_activeConnectionRatio

Oracle Database Active Connection RatioMonitors the ratio of oracle active connections.%
Oracle_database_activeUsers

Oracle Database Active UsersMonitors the count of oracle active users.Count
Oracle_database_remaining_extents

Oracle Database Remaining ExtentsMonitors the count of remaining extents for each tablespace in the oracle.Count
Oracle_database_rollbackSegments

Oracle Database Rollback SegmentsMonitors the value of a sufficient number of rollback segments.N/A
Oracle_database_tablespace_freeSpace

Oracle Database Tablespace FreeSpaceMonitors the free space utilization of each tablespace in oracle.%
Oracle_database_tablespace_status

Oracle Database Tablespace StatusN/AMonitors the status of each tablespace in oracle.
Below are the possible values:
ONLINE
OFFLINE
READ ONLY
Oracle_database_tablespace_deficit_status

Oracle Database Tablespace Deficit StatusIt monitors the deficit status of each tablespace in oracle.
Below are the possible values:
0 - Tablespace has deficit (i.e. available space < next extent)
1 - Tablespace has no deficit (i.e. available space > next extent)"
Enum Mapping
Oracle_database_tablespace_size

Oracle Database Tablespace SizeIt monitors the size(in MB) of the each tablespace (including temp tablespace).MB
Oracle_database_tablespace_temp_free

Oracle Database Tablespace Temp FreeMonitors the free space (in Bytes) of the temp tablespace.Bytes
Oracle_database_no_next_extents

Oracle Database No Next ExtentsMonitors the count of database segments which are having no next extent.Count
oracle_asm_diskgroup_status

Oracle ASM DiskGroup StatusMonitors the Oracle ASM disk group status.N/A
oracle_asm_failure_groups_status

Oracle ASM Failure Groups StatusMonitors the Oracle ASM failure groups status.N/A
oracle_blocking_session_count

Oracle Blocking Session CountMonitors the Oracle blocking session count.count
oracle_database_archivegap_detectionOracle Database Archive Gap DetectionMonitors the Oracle Database Archive Gap Detection.N/A
oracle_database_blockCorruption_countOracle Database Block Corruption CountMonitors the Oracle Database Block Corruption Count.count
oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointMonitor the Oracle Database Days Since Last Restore Point.Days
oracle_database_redoLog_status

G2-OracleDB-Database MonitoringG2-OracleDB-Database RedoLog Status Monitor.N/A
oracle_database_tablespace_usage_without_autoextend

Oracle Database Tablespace Usage Without AutoExtendMonitors the Oracle database tablespace usage without autoextend.%
oracle_database_tablespace_usedPercent

G2-OracleDB-Database Space UsageG2-OracleDB-Database Space Usage Monitor.%
oracle.asm.archive.pct

Oracle ASM Archive pctOracle query for ASM ARCHIVE diskgroup.%
oracle.asm.data.pct

Oracle ASM Data pctOracle query for ASM DATA diskgroup.%
oracle.blocking.lock.queries

Oracle Blocking Lock QueriesValidates the number of block lock queries on a specific database.Count
oracle.blocking.session

Oracle Blocking SessionTo monitor blocked valid sessions.Count
oracle.BufferCacheHitRatio.pct

Oracle BufferCacheHitRatio pctTo monitor buffer cache hit ratio value in percentage.%
oracle.cache.blocks.lost

Cache Blocks LostThe number of global cache blocks lost over the user-defined observation period.Count
oracle.cache.invalidations

Oracle Cache InvalidationsValidates the number of cache invalidations on a specific database.Count
oracle.check.db.alive

Check Db AliveMonitors database instance connectivity.N/A
oracle.cpu.usage.per.sec

CPU Usage Per SecThe CPU usage per second by the database processes measured in hundredths of a second.Per Second(psec)
oracle.cpu.usage.per.txn

CPU Usage Per TxnThe amount of CPU usage per transaction for a specific task or session.%
oracle.database.cpu.time.ratio

Database CPU Time RatioThe Database CPU Time Ratio is calculated by dividing the amount of used CPU in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls .%
oracle.database.wait.time.ratio

Database Wait Time RatioMonitors the database wait time ratio.%
oracle.db.instance.uptime

DB Instance UptimeThe db instance uptime since start up.Days
oracle.disk.sort.ratio.pct

Oracle Disk Sort Ratio pctTo monitor disk sort ratio value in percentage.%
oracle.duplicated.filename.count

Oracle Duplicated Filename CountTo check the existence of duplicate db file names in different ASM paths.Count
oracle.executions.per.sec

Executions Per SecThe average transactions per second.Per Second(psec)
oracle.executions.per.txn

Executions Per TxnThe average amount of time per execution.N/A
oracle.failed.logon.count

Failed Logon CountMonitors the failed logon attempts of the current user.Count
oracle.invalid.objects

Invalid ObjectsChecks for invalid objects in a database.Count
oracle.io.wait.time

IO Wait TimeThe total time taken to complete the I/O operations keeping the application in a blocked state.Milli Seconds(ms)
oracle.java.pool.free

Java Pool FreeMonitors the free java pool memory in MB.Mega Bytes(MB)
oracle.large.pool.free

Large Pool FreeMonitors the free large pool memory in MB.Mega Bytes(MB)
oracle.library.cache.gets

Oracle Library Cache GetsValidates the number of library cache gets by the database.Count
oracle.library.cachereloads

Library Cache ReloadsValidates the number of library cache reloads by the database.N/A
oracle.librarycachehitratio.pct

Oracle Library Cache Hit Ratio pctTo monitor the library cache hit ratio value in percentage.%
oracle.logons.per.sec

Logons Per SecThe number of logons per second during the sample period.Count
oracle.long.running.queries

Oracle Long Running QueriesValidates the number of long running queries on a specific database.Count
oracle.maxdbfilepct.usage

Oracle Max DB File pct usageTo monitor the percentage of open oracle files.%
oracle.maxopencursor.username.count

Oracle Max Open Cursor Username CountTo monitor maximum open cursor value for each db username.Count
oracle.process.count

Process CountMonitor the current processes running in the database.N/A
oracle.procsused.pct

Oracle Processes Used pctTo monitor db process usage in percentage.%
oracle.rac.tablespace.space.used

Oracle RAC Tablespace Space Used Top 20 Greaterthan 85To monitor top(20) RAC tablespace space usage where percentage > 85%.%
oracle.redo.log.space.requests

Redo Log Space RequestsThe number of requests per second by Oracle waiting for disk space allocation for the redo log entries.Req per Sec
oracle.redolog.switch.count

Oracle Redolog Switch CountTo monitor the number of redolog switch.Count
oracle.sequence.pctused

Oracle Sequence Pct UsedTo monitor the sequence usage in percentage.%
oracle.session.cpu_used

Session Cpu UsedMonitors the session cpu usage in seconds.Seconds(s)

Refer to the Oracle Cloud (OCI) for more information about Oracle Cloud.