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

This describes the discovery and monitoring setup for the Oracle database.


  • 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:


For more information, see Create a Metric.

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.

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.



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

ping <IP Address>
telnet <IP Address> <Port>
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 laset , 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-Oracle Library Stats
G2-OracleDB-Oracle Library Stats - v2.0
G2-OracleDB-Oracle Memory
G2-OracleDB-Oracle Memory - v2.0
G2-OracleDB-Performance - v2.0
G2-OracleDB-Sessions - v2.0
G2-OracleDB-System Stats
G2-OracleDB-System Stats - v2.0
G2-OracleDB-System Summary
G2-OracleDB-System Summary - v2.0
G2-OracleDB-Table Space
G2-OracleDB-Table Space - v2.0
G2-OracleDB-ASM Availability
G2-OracleDB-Database locking
G2-OracleDB-Database backups
G2-OracleDB-Database scheduled jobs
G2-OracleDB-Database Space Usage

Supported metrics

MetricMetric Display NameUnit

Monitors the Oracle ASM ACFS status.
Oracle ASM ACFS Status
oracle_asm_alertlog_sizeOracle ASM AlertLog Sizemegabytes(MB)

Monitors the Oracle ASM disk status.
Oracle ASM Disk Status

Monitors the Oracle ASM disk group status.
Oracle ASM DiskGroup Status

Monitors the Oracle ASM disk group space utilization.
Oracle ASM Disk Group Space Utilizationpercentage(%)

Monitors the Oracle ASM failure groups status.
Oracle ASM Failure Groups Status

Monitors the Oracle blocking session count.
Oracle Blocking Session Countcount
oracle_database_alertLog_availabilityOracle Database Alert Log AvailabilityN/A
oracle_database_alertLog_readAccessibilityOracle Database Alert Log Read AccessibilityN/A
oracle_database_alertLog_writeAccessibilityOracle Database Alert Log Write AccessibilityN/A
oracle_database_archivegap_detectionOracle Database Archive Gap DetectionN/A
oracle_database_archivelog_total_usageOracle Database Archive Log Total UsageGB
oracle_database_archiveLogModeOracle Database Archive Log ModeN/A

Monitors the Oracle database auto task job status.
Oracle Database AutoTask Job Status

Monitors the Oracle database full backup days ago.
Oracle Database Full Backup DaysAgoDays

Monitors the Oracle database incremental backup days ago.
Oracle Database Incremental Backup DaysAgoDays
oracle_database_backup_modeOracle Database Backup ModeN/A

Monitors the Oracle database RMAN backup days ago.
Oracle Database RMAN Backup DaysAgoDays

Monitors the Oracle database user managed backup days ago.
Oracle Database User Managed Backup DaysAgoDays
oracle_database_blockCorruption_countOracle Database Block Corruption Countcount
oracle_database_blockCorruption_typeOracle Database Block Corruption TypeN/A
oracle_database_component_statusOracle Database Component StatusN/A
oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointDays

Monitors the Oracle database DBMS jobs failure count.
Oracle Database DBMS Jobs Failure CountCount
oracle_database_flash_recovery_usageOracle Database Flash Recovery Usagemegabytes(MB)
oracle_database_flashback_log_usageOracle Database FlashBack Log Usagepercent
oracle_database_indexLogging_countOracle Database Index Logging Countcount
oracle_database_licenseOptionUsage_statusOracle Database License Option Usage StatusN/A
oracle_database_listenerSID_availabilityOracle Database Listener SID AvailabilityN/A
oracle_database_lockedusers_statusOracle Database Locked Users StatusMonitors the Oracle database locked users status.
oracle_database_monitoredLicense_UsedstatusOracle Database Monitored License Used StatusN/A
oracle_database_password_expiry_DaysOracle Database Password Expiry DaysDays
oracle_database_recoveryDest_sizeOracle Database RecoveryDest Sizemegabytes(MB)
oracle_database_recoveryDest_used_percentageOracle Database RecoveryDest Used Percentagepercent
oracle_database_recoveryDest_used_sizeOracle Database RecoveryDest Used Sizemegabytes(MB)

G2-OracleDB-Database RedoLog Status Monitor
G2-OracleDB-Database Monitoring

Monitors Oracle Database including different redundancy requirements (Safely usable data usage).
Oracle Database Required Mirror Free Spacemegabytes(MB)
oracle_database_restorePoint_GuaranteeFlashback_StatusOracle Database Restore Point Guarantee Flashback StatusN/A

Monitors the Oracle Database including safely usable disk space on different redundancy (Safely usable data usage).
Oracle Database Safely Usable Disk Spacemegabytes(MB)

Monitors the Oracle database scheduler jobs status.
Oracle Database Scheduler Jobs Status

G2-OracleDB-Database RedoLog Status Monitor
G2-OracleDB-Database Monitoring

Monitors the Oracle database tablespace usage without autoextend.
Oracle Database Tablespace Usage Without AutoExtendpercentage(%)

G2-OracleDB-Database Space Usage Monitor
G2-OracleDB-Database Space Usagepercentage(%)
oracle_database_undoUnexpired_countOracle Database Undo Unexpired Countcount
oracle_database_users_default_passwordOracle Database Users Default Passwordcount

Monitors the active sessions.
Active SessionsCount

Oracle query for ASM ARCHIVE diskgroup.
Oracle ASM Archive pctPercentage(%)

Oracle query for ASM DATA diskgroup.
Oracle ASM Data pctPercentage(%)

Validates the number of block lock queries on a specific database.
Oracle Blocking Lock QueriesCount

To monitor blocked valid sessions.
Oracle Blocking SessionCount

To monitor buffer cache hit ratio value in percentage.
Oracle BufferCacheHitRatio pctPercentage(%)

The number of global cache blocks lost over the user-defined observation period.
Cache Blocks LostCount

Validates the number of cache invalidations on a specific database.
Oracle Cache InvalidationsCount

Monitors database instance connectivity.
Check Db Alive

The CPU usage per second by the database processes measured in hundredths of a second.
CPU Usage Per SecPer Second(psec)

The amount of CPU usage per transaction for a specific task or session.
CPU Usage Per TxnPercentage(%)

The 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 .
Database CPU Time RatioPercentage(%)

Monitors the database wait time ratio.
Database Wait Time RatioPercentage(%)

The db instance uptime since start up.
DB Instance UptimeDays

To monitor disk sort ratio value in percentage.
Oracle Disk Sort Ratio pctPercentage(%)

To check the existence of duplicated db filenames in different ASM paths.
Oracle Duplicated Filename CountCount

The average transactions per second
Executions Per SecPer Second(psec)

The average amount of time per execution
Executions Per Txn

Monitors the failed logon attempts of the current user.
Failed Logon CountCount

Monitors the inactive sessions.
Inactive SessionsCount

Checks for invalid objects in a database.
Invalid ObjectsCount

The total time taken to complete the I/O operations keeping the application in a blocked state.
IO Wait TimeMilli Seconds(ms)

Monitors the free java pool memory in MB.
Java Pool FreeMega Bytes(MB)

Monitors the free large pool memory in MB.
Large Pool FreeMega Bytes(MB)

Validates the number of library cache gets by the database.
Oracle Library Cache GetsCount

Validates the number of library cache reloads by the database.
Library Cache Reloads

To monitor the library cache hit ratio value in percentage.
Oracle Library Cache Hit Ratio pctPercentage(%)

The number of logons per second during the sample period.
Logons Per SecCount

Validates the number of long running queries on a specific database.
Oracle Long Running QueriesCount

To monitor the percentage of open oracle files.
Oracle Max DB File pct usagePercentage(%)

To monitor maximum open cursor value for each db username.
Oracle Max Open Cursor Username CountCount

Monitor the current processes running in the database.
Process Count

To monitor db process usage in percentage.
Oracle Processes Used pctPercentage(%)

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

The number of requests per second by Oracle waiting for disk space allocation for the redo log entries.
Redo Log Space RequestsReq per Sec

To monitor the number of redolog switch.
Oracle Redolog Switch CountCount

To monitor the sequence usage in percentage.
Oracle Sequence Pct UsedPercentage(%)

Monitors the session cpu usage in seconds.
Session Cpu UsedSeconds(s)