G2-OracleDB-Listener - v2

Description

Monitors the availability and state of Oracle database listener services, and the status of traditional listener, in both standalone and RAC environments.

Prerequisites

  • Ensure you have Gateway Version 14.0.0 or Later.
  • Ensure the following environment variables are properly configured:
    • Set ORACLE_HOME to the path where Oracle is installed.
    • Set ORACLE_SID to your database’s SID (System Identifier).
    • Add the Oracle binary folder to your system’s PATH by running the following command: export PATH=$ORACLE_HOME/bin:$PATH

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Listener Service Availabilityoracle_database_listener_service_availabilityOracle Database Listener Service AvailabilityMonitors the availability of specified Oracle database listener services in both standalone and RAC setups, indicating a state of 1 for available services and 0 for those that are not available.
G2-OracleDB-Listener Service Stateoracle_database_listener_service_stateOracle Database Listener Service StateMonitors the state of specified RAC (Real Application Clusters) and standalone Oracle database listener services. The possible values include: READY (1): The service is ready to accept connections. BLOCKED (2): The service is blocked and cannot accept connections. READY/SECONDARY (3): The service is in a secondary state, allowing connections under specific conditions. RESTRICTED (4): The service is in a restricted state, limiting access. UNKNOWN (5): The service status is unknown, indicating potential issues.
G2-OracleDB-Listener Statusoracle_database_listener_statusOracle Database Listener StatusMonitors the status of the traditional Oracle database listener (LISTENER) in standalone and RAC setups. Possible states are: 0 indicates Running, 1 indicates Not Running.

G2-OracleDB-Listener - RAC

Description

Monitors the status and availability of Oracle database listeners in a Real Application Clusters (RAC) environment, ensuring that both local and SCAN listeners are operational for optimal client connectivity and service availability.

Prerequisites

  • Ensure you have Gateway Version 14.0.0 or Later.
  • Ensure the following environment variables are properly configured:
    • Set ORACLE_HOME to the path where Oracle is installed.
    • Set ORACLE_SID to your database’s SID (System Identifier).
    • Add the Oracle binary folder to your system’s PATH by running the following command: export PATH=$ORACLE_HOME/bin:$PATH

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Listener - RACoracle_database_scan_listener_statusOracle Database Scan Listener StatusMonitors the status of SCAN (Single Client Access Name) listeners in a RAC environment, checking if the scan listeners are up and running for client connections. The possible values include: 1(Running) and 0(Not Running).
oracle_database_all_listener_statusOracle Database All Listener StatusMonitors the overall status of all Oracle listeners, including both local and SCAN listeners, providing a consolidated view of listener availability. Possible values include 0(Not running), 1 (Running)
oracle_database_local_listener_statusOracle Database Local Listener StatusMonitors the status of local Oracle database listeners to determine whether they are running or not, ensuring the local listeners are operational on the server. Possible values include: 0(Not Running), 1 (Running)
oracle_database_listener_status_with_nodesOracle Database Listener Status With NodesMonitors the status of Oracle listeners across nodes, displaying whether each listener is running, including both local and SCAN listeners and the specific node it's associated with it, in a RAC environment. Possible values include: 0(Not Running), 1 (Running).

G2-OracleDB-Database Monitoring - v2

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version. Prerequisites: Gateway 7.0.0 and above. In this version of the template, G2-OracleDB-Database Monitoring - v2, the metric has been updated from oracle_database_invalid_objects to oracle_database_invalid_objects_count.

Prerequisites

No Prerequisites

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Custom Monitor - v2oracle_database_archivelog_total_usageOracle Database Archive Log Total UsageGBThis metric monitors the total size (in GB) of Archive log
oracle_database_archfile_usageOracle Database ArchFile UsageMBThis metric monitors the size (in MB) of each Arch file
oracle_database_datafile_availabilityOracle Database Datafile AvailabilitynullThis metric monitors the datafile availability - Below are the possible values: 1 - AVAILABLE, 2 - INVALID
oracle_database_locked_critical_usersOracle Database Locked Critical UsersnullThis metric monitors the locked critical users information
oracle_database_backup_modeOracle Database Backup ModenullThis metric monitors the oracle database backup mode like Active or InActive
oracle_database_archivegap_detectionOracle Database Archive Gap DetectionnullThis metric monitors the Archive GAP detection
oracle_asm_diskgroup_typeOracle ASM Disk Group TypenullThis metric displays the type of the ASM disk group
oracle_asm_disk_mode_statusOracle ASM Disk Mode StatusnullThis metric displays global status about which kinds of I/O requests are allowed to the disk
oracle_database_restorePoint_GuaranteeFlashback_StatusOracle Database Restore Point Guarantee Flashback StatusnullMonitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values - YES - 1 NO - 0
oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointDaysMonitors the age (In Days) of last successful restore point
oracle_database_blockCorruption_countOracle Database Block Corruption CountcountMonitors the count of block corruption in Oracle DB
oracle_database_blockCorruption_typeOracle Database Block Corruption TypenullMonitor the type of block corruption in Oracle DB
oracle_database_undoUnexpired_countOracle Database Undo Unexpired CountcountMonitors the count of Undo Unexpired in Oracle DB
oracle_database_indexLogging_countOracle Database Index Logging CountcountMonitors the count of Index logging in Oracle DB
oracle_database_invalid_objects_countOracle Database Invalid Objects CountcountMonitors the count of Invalid objects in Oracle DB
oracle_database_licenseOptionUsage_statusOracle Database License Option Usage StatusnullMonitors the Oracle DB License Option Usage Status: Below are the possible values - YES - 1 NO - 0
G2-OracleDB-ASM AlertLog Monitororacle_asm_alertlog_sizeOracle ASM AlertLog SizeMBThis metric monitors the disk used space (in MB) by ASM alert log

G2-OracleDB-Database locking - v2

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database locking Monitor - v2oracle_blocking_session_countOracle Blocking Session CountcountOracle Blocking Session Count
oracle_database_lockedusers_countOracle Database Locked Users CountcountMonitors the count of Locked users in Oracle DB

G2-OracleDB-Alert Log Status

Description

This template supports for Oracle Linux flavor machines and tested in Oracle RAC 19c version.

Prerequisites

  1. Gateway 7.0.0 and above & Add SSH credentials on target device.
  2. Need to provide input parameters like below format:
    <diag trace path 1>::<instance1_sid>,<diag trace path 2>::<instance2_sid>

Single Instance Example:

u01/app/oracle/diag/rdbms/cintbprd/CINTBPRD1/trace/::CINTBPRD1

Multiple Instance Example (separted with comma):

/u01/app/oracle/diag/rdbms/cintbprd/CINTBPRD1/trace/::CINTBPRD1,/u01/app/oracle/diag/rdbms/cintbprd/CINTBPRD2/trace/::CINTBPRD2

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Alert Log Statusoracle_database_alertLog_readAccessibilityOracle Database Alert Log Read AccessibilityNULLMonitors the alert log read accessibility of given instances. Below are the possible values: 0 - Not Accessible,1 - Accessible
oracle_database_alertLog_availabilityOracle Database Alert Log AvailabilityNULLMonitors the alert log availability of given instance. Below are the possible values: 0 - Not Available,1 - Available
oracle_database_alertLog_writeAccessibilityOracle Database Alert Log Write AccessibilityNULLMonitors the alert log write accessibility of given instances. Below are the possible values: 0 - Not Accessible,1 - Accessible

G2-OracleDB-ARCHIVER

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries,Template is tested on Oracle RAC 19c version (Linux based OS).

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-ARCHIVERoracle_database_flash_recovery_usageOracle Database Flash Recovery UsageMBFlash recovery usage (in MB) of the oracle database
oracle_database_flashback_log_usageOracle Database FlashBack Log Usage%FlashBack Log usage in percent
oracle_database_recoveryDest_sizeOracle Database RecoveryDest SizeMBOracle Database Recovery Destination Size in MB
oracle_database_recoveryDest_used_percentageOracle Database RecoveryDest Used Percentage%Oracle Database Recovery Destination usage in Percent
oracle_database_recoveryDest_used_sizeOracle Database RecoveryDest Used SizeMBOracle Database Recovery Destination Used Size in MB
oracle_database_archiveLogModeOracle Database Archive Log ModeNULLMonitors the archive log mode of the instance. Below are the possible values: 0 - NOARCHIVELOG. 1 - ARCHIVELOG,2 - MANUAL
oracle_database_component_statusOracle Database Component StatusNULLOracle 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

G2-OracleDB-ASM Availability

Description

This template supports both SID and Service name connection types,Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-ASM Availability Monitororacle_asm_disk_statusOracle ASM Disk StatusNULLOracle ASM Disk Status
oracle_asm_diskgroup_statusOracle ASM DiskGroup StatusNULLOracle ASM DiskGroup Status
oracle_asm_acfs_statusOracle ASM ACFS StatusNULLOracle ASM ACFS Status

G2-OracleDB ASM DiskGroup Space Usage

Description

Monitors Oracle ASM Diskgroup Space Usages

Prerequisites

No Prerequisites

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB ASM DiskGroup Space Usage Monitororacle_database_asm_diskgroup_utilizationoracle_database_asm_diskgroup_utilization%This metric calculates the percentage of disk group space that is currently being used. It helps you monitor the overall utilization of the ASM disk group.

Note: Oracle Database 10g and later versions.
oracle_database_asm_dis kgroup_safelyUsableDiskSpaceoracle_database_asm_diskgroup_safelyUsableDiskSpaceMBThis metric provides the amount of usable disk space in megabytes within the ASM disk group. It represents the space available for storing database files and other data safely.

Note: Oracle Database 11g Release 2 and later versions.
oracle_database_asm_diskgroup_requiredMirrorFreeSpaceoracle_database_asm_diskgroup_requiredMirrorFreeSpaceThis metric indicates the amount of free space in megabytes that is required for maintaining the mirroring or redundancy configuration of the ASM disk group. It helps ensure data redundancy and availability.

Note: Oracle Database 11g Release 2 and later versions.

G2-OracleDB-Database backups

Description

This template supports both SID and Service name connection type Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database backups Monitororacle_database_backup_incrementalOracle Database Incremental Backup DaysAgoDaysOracle Database Incremental Backup DaysAgo
oracle_database_backup_usermanagedOracle Database User Managed Backup DaysAgoDaysOracle Database User Managed Backup DaysAgo
oracle_database_backup_fullOracle Database Full Backup DaysAgoDaysOracle Database Full Backup DaysAgo
oracle_database_backup_archiveOracle Database Archive Backup DaysAgoDaysOracle Database Archive Backup DaysAgo
oracle_database_backup_rmanOracle Database RMAN Backup DaysAgoDaysOracle Database RMAN Backup DaysAgo

G2-OracleDB-Database locking

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database locking Monitororacle_database_lockedusers_statusOracle Database Locked Users StatusNULLOracle Database Locked Users Status
oracle_blocking_session_countOracle Blocking Session CountcountOracle Blocking Session Count

G2-OracleDB-Database Monitoring

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-ASM AlertLog Monitororacle_asm_alertlog_sizeOracle ASM AlertLog SizeMBThis metric monitors the disk used space (in MB) by ASM alert log
G2-OracleDB-Custom Monitororacle_database_blockCorruption_countOracle Database Block Corruption CountcountMonitors the count of block corruption in Oracle DB
oracle_database_blockCorruption_typeOracle Database Block Corruption TypeNULLMonitor the type of block corruption in Oracle DB
oracle_database_archfile_usageOracle Database ArchFile UsageMBThis metric monitors the size (in MB) of each Arch file
oracle_database_restorePoint_GuaranteeFlashback_StatusOracle Database Restore Point Guarantee Flashback StatusNULLMonitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values - YES - 1,NO - 0
oracle_database_indexLogging_countOracle Database Index Logging CountcountMonitors the count of Index logging in Oracle DB
oracle_database_archivegap_detectionOracle Database Archive Gap DetectionNULLThis metric monitors the Archive GAP detection
oracle_database_undoUnexpired_countOracle Database Undo Unexpired CountcountMonitors the count of Undo Unexpired in Oracle DB
oracle_database_locked_critical_usersOracle Database Locked Critical UsersNULLThis metric monitors the locked critical users information
oracle_database_datafile_availabilityOracle Database Datafile AvailabilityNULLThis metric monitors the datafile availability - Below are the possible values: 1 - AVAILABLE,2 - INVALID
oracle_database_backup_modeOracle Database Backup ModeNULLThis metric monitors the oracle database backup mode like Active or InActive
oracle_database_archivelog_total_usageOracle Database Archive Log Total UsageGBThis metric monitors the total size (in GB) of Archive log
oracle_asm_diskgroup_typeOracle ASM Disk Group TypeNULLThis metric displays the type of the ASM disk group
oracle_database_invalid_objectsOracle Database Invalid ObjectsNULLThis metric displays invalid objects available or not
oracle_asm_disk_mode_statusOracle ASM Disk Mode StatusNULLThis metric displays global status about which kinds of I/O requests are allowed to the disk
oracle_database_daysSinceLastRestorePointOracle Database Days Since Last Restore PointDaysMonitors the age (In Days) of last successful restore point

G2-OracleDB-Database Resource Usage

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database Resource Usage Monitororacle_database_resource_process_limitOracle Database Resource Process LimitcountOracle Database Resource Process Limit
oracle_database_resource_session_limitOracle Database Resource Session LimitcountOracle Database Resource Session Limit

G2-OracleDB-Database Resource Usage - v2

Description

This updated version 2 template added with new process utilization metric.

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database Resource Usage Monitor - v2oracle_database_process_utilizationOracle Database Process Utilization%To monitor Process Utilization of the provided DB Instance.

G2-OracleDB-Database scheduled jobs

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database scheduled jobs Monitororacle_database_dbmsjobs_failure_countOracle Database DBMS Jobs Failure CountcountOracle Database DBMS Jobs Failure Count
oracle_database_scheduler_jobs_statusOracle Database Scheduler Jobs StatusNULLOracle Database Scheduler Jobs Status
oracle_database_autotask_job_statusOracle Database AutoTask Job StatusNULLOracle Database AutoTask Job Status

G2-OracleDB-Database Space Usage

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Database Space Usage Monitororacle_database_required_mirror_freespaceOracle Database Required Mirror Free SpaceMBOracle Database - Including different redundancy requirements (Safely usable data usage)
oracle_asm_diskgroup_utilizationOracle ASM DiskGroup Space Utilization%Oracle ASM DiskGroup Space Utilization
oracle_database_tablespace_usedPercentOracle Database Tablespace Used Percent%Monitor the Oracle table space used percent
oracle_database_safelyusable_diskspaceOracle Database Safely Usable Disk SpaceMBOracle Database - Including safely usable disk space on different redundancy (Safely usable data usage)

G2-OracleDB-DataGuard

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-DG DB Role Change Monitor With DGBoracle_dg_database_role_change_withDGBOracle DataGuard DB Role Change with DataGuard BrokerNULLOracle DataGuard DB Role Change with DataGuard Broker

G2-OracleDB-Listener

Description

This template supports for Oracle Linux flavor machines and tested in Oracle RAC 19c version.

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 Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Listener Availability Monitororacle_database_listener_availabilityOracle Database Listener AvailabilityNULLOracle Database Listener Availability
G2-OracleDB-Listener Monitororacle_database_listener_status_with_nodesOracle Database Listener Status With NodesNULLOracle Database Listener Status With Nodes
oracle_database_all_listener_statusOracle Database All Listener StatusNULLOracle Database All Listener Status
oracle_database_scan_listener_statusOracle Database Scan Listener StatusNULLOracle Database Scan Listener Status
oracle_database_local_listener_statusOracle Database Local Listener StatusNULLOracle Database Local Listener Status
G2-OracleDB-Listener Service Monitororacle_database_listener_service_statusOracle Database Listener Service StatusNULLOracle Database Listener Service Status

G2-OracleDB-Listener SID Availability

Description

This template supports for Oracle Linux flavor machines and tested in Oracle RAC 19c version. This template Only works for CDB SID’s

Prerequisites

  1. Gateway 7.0.0 and above & Add SSH credentials on target device.
  2. Need to provide input parameters like below format.syntax:,,,...etc example:Instance1,Instance2.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Listener SID Availability Monitororacle_database_listenerSID_availabilityOracle Database Listener SID AvailabilityMonitors the oracle database listener SID availability status: Below are the possible values - 1 - Available,0 - Unavailable

G2-OracleDB-Monitored License Used Status

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries and tested in Oracle RAC 19c version.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Monitored License Used Statusoracle_database_monitoredLicense_UsedstatusOracle Database Monitored License Used StatusNULLIt provides oracle monitored license list with currently used status. Below are the possible values - TRUE: 0 FALSE: 1

G2-OracleDB-Oracle Library Stats

Description

G2-OracleDB-Oracle Library Stats

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Library statsoracle.library.cache.getsOracle Library Cache GetsValidates the Number of Library Cache gets by database.
oracle.library.cachereloadsLibrary Cache ReloadsNULLValidates the Number of Library Cache Reloads by database.
oracle.cache.invalidationsOracle Cache InvalidationsValidates the how many Cache invalidations on particular database.

G2-OracleDB-Oracle Library Stats - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Library stats - v2.0oracle.library.cache.getsOracle Library Cache GetsValidates the Number of Library Cache gets by database.
oracle.library.cachereloadsLibrary Cache ReloadsNULLValidates the Number of Library Cache Reloads by database.
oracle.cache.invalidationsOracle Cache InvalidationsValidates the how many Cache invalidations on particular database.

G2-OracleDB-Oracle Memory

Description

G2-OracleDB-Oracle Memory

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle SGA statsoracle.shared.pool.freeShared Pool FreeMBIt monitors the free shared pool memory in MB.
oracle.java.pool.freeJava Pool FreeMBIt monitors the free java pool memory in MB.
oracle.large.pool.freeLarge Pool FreeMBIt monitors the free large pool memory in MB.

G2-OracleDB-Oracle Memory - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle SGA stats - v2.0oracle.shared.pool.freeShared Pool FreeMBIt monitors the free shared pool memory in MB.
oracle.java.pool.freeJava Pool FreeMBIt monitors the free java pool memory in MB.
oracle.large.pool.freeLarge Pool FreeMBIt monitors the free large pool memory in MB.

G2-OracleDB-Password Security

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries,Template is tested on Oracle RAC 19c version (Linux based OS).

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2-OracleDB-Password Securityoracle_database_users_default_passwordoracle_database_users_default_passwordcountMonitors the count of users which are using default password
oracle_database_password_expiry_DaysOracle Database Password Expiry DaysDaysMonitors the users password expiry in days

G2-OracleDB-Performance

Description

G2-OracleDB-Performance

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
OracleDB Performanceoracle.invalid.objectsInvalid ObjectscountChecks for invalid objects in database.
oracle.failed.logon.countFailed Logon CountcountIt monitors the failed logon attempts of the current user.
oracle.blocking.lock.queriesOracle Blocking Lock QueriescountValidates the how many block lock queries?on particular database.
oracle.long.running.queriesOracle Long Running QueriescountValidates the how many long running queries?on particular database.

G2-OracleDB-Performance - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
OracleDB Performance - v2.0oracle.invalid.objectsInvalid ObjectscountChecks for invalid objects in database.
oracle.failed.logon.countFailed Logon CountcountIt monitors the failed logon attempts of the current user.
oracle.blocking.lock.queriesOracle Blocking Lock QueriescountValidates the how many block lock queries?on particular database.
oracle.long.running.queriesOracle Long Running QueriescountValidates the how many long running queries?on particular database.

G2-OracleDB-Sessions

Description

G2-OracleDB-Sessions

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Sessionsoracle.session.cpu_usedSession Cpu UsedsIt monitors the session cpu usage in seconds.
oracle.active.sessionsActive SessionscountIt monitors the active sessions
oracle.inactive.sessionsInactive SessionscountIt monitors the inactive sessions
oracle.session.limit.usageSession Limit Usage%It monitors the sessions utilization.
oracle.session.waitsSession WaitssIt monitors the session waits

G2-OracleDB-Sessions - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Sessions - v2.0oracle.session.cpu_usedSession Cpu UsedsIt monitors the session cpu usage in seconds.
oracle.active.sessionsActive SessionscountIt monitors the active sessions
oracle.inactive.sessionsInactive SessionscountIt monitors the inactive sessions
oracle.session.limit.usageSession Limit Usage%It monitors the sessions utilization.
oracle.session.waitsSession WaitssIt monitors the session waits

G2-OracleDB-Sessions - v3.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Sessions - v3.0oracle.active.sessionsActive SessionscountIt monitors the active sessions
oracle.session.limit.usageSession Limit Usage%It monitors the sessions utilization.
oracle.inactive.sessionsInactive SessionscountIt monitors the inactive sessions
oracle_system_waits_perClassOracle System Waits PerClasssTo monitor 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)
oracle_session_waits_perEventOracle Session Waits PerEventsIt monitors sum of "session waits" per each event and class. (event for which sessions have just completed waiting or are currently waiting)

G2-OracleDB-System Stats

Description

G2-OracleDB-System Stats

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle System Statsoracle.user.commitsUser CommitspsecThis metric represents the number of user commits performed per second in last two monitoring polls.
oracle.redo.log.space.requestsRedo Log Space RequestsReq per SecIt represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.
oracle.user.rollbacks.persecUser RollbackspsecThis metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
oracle.cache.blocks.lostCache Blocks LostcountThis metric represents the number of global cache blocks lost over the user-defined observation period.
oracle.table.scan.blocks.persecTable Scan BlockspsecNumber of blocks received via table scans.
oracle.io.wait.timeIO Wait TimemsHow much time the application was blocked,waiting for all I/O operation to complete
oracle.logons.per.secLogons Per SeccountThis metric represents the number of logons per second during the sample period.
oracle.db.instance.uptimeDB Instance UptimeDaysIt represents db instance uptime since start up.
oracle.check.db.aliveCheck Db AliveNULLMonitors connectivity to the database instance.

G2-OracleDB-System Stats - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle System Stats - v2.0oracle.user.commitsUser CommitspsecThis metric represents the number of user commits performed per second in last two monitoring polls.
oracle.redo.log.space.requestsRedo Log Space RequestsReq per SecIt represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.
oracle.user.rollbacks.persecUser RollbackspsecThis metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
oracle.cache.blocks.lostCache Blocks LostcountThis metric represents the number of global cache blocks lost over the user-defined observation period.
oracle.table.scan.blocks.persecTable Scan BlockspsecNumber of blocks received via table scans.
oracle.io.wait.timeIO Wait TimemsHow much time the application was blocked,waiting for all I/O operation to complete
oracle.logons.per.secLogons Per SeccountThis metric represents the number of logons per second during the sample period.
oracle.db.instance.uptimeDB Instance UptimeDaysIt represents db instance uptime since start up.
oracle.check.db.aliveCheck Db AliveNULLMonitors connectivity to the database instance.

G2-OracleDB-System Stats - v3.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Database System Statisticsoracle_database_gc_blocks_corruptOracle Database Global Cache Blocks CorruptNULLIt monitors the value of the global cache blocks corrupt.
oracle_database_redoLog_contentionOracle Database Redo Log Contention%It monitors the miss ratio for redo log latches. If the ratio of MISSES to GETS exceeds 1% then there is latch contention.
oracle_database_gc_blocks_lostOracle Database Global Cache Blocks LostNULLIt monitors the value of the global cache blocks lost
oracle_database_cacheFusionWritesOracle Database Cache Fusion Writes Ratio%It monitors the ratio of cache fusion writes
oracle_database_avgGlobalLockGetTimeOracle Database Average Global Lock Get TimemsIt monitors the average global lock get time (in milliseconds)
oracle_database_dictionaryCacheHitRatioOracle Database Dictionary Cache Hit Ratio%It monitors the Dictionary cache hit ratio
oracle_database_gc_cr_timeoutsOracle Database Global Cache Consistent Read TimeoutsNULLIt monitors the value of global cache consistent read timeouts. This statistic is available in older oracle versions only.
oracle_database_chainedRowsOracle Database Chained RowscountIt monitors the count of chained rows from all available tables in oracle database
oracle_database_bufferCachehitRatioOracle Database Buffer Cache Hit Ratio%It monitors the buffer cache hit ratio
oracle_database_gc_convert_timeoutsOracle Database Global Cache Convert TimeoutsNULLIt monitors the value of global cache convert timeouts,this statistic is available in older oracle versions only.
oracle_database_gc_service_utilizationOracle Database Global Cache Service Utilization%It monitors the value of global cache service utilization,this statistic is available in older oracle versions only.
oracle_database_memory_sortRatioOracle Database Memory Sort Ratio%It monitors the ratio of memory sorts
oracle_database_unUsable_index_countOracle Database UnUsable Index CountcountIt monitors the count of the unusable indexes in the oracle database.
Oracle Database Users Statisticsoracle_database_overallSizeOracle Database Overall SizeMBIt monitors the oracle database size (in MB) based on data files,temp files,log files and the control files
oracle_database_activeUsersOracle Database Active UserscountIt monitors the count of oracle active users
oracle_database_resource_utilizationOracle Database Resource Utilization%It monitors the resource utilization for the resources :Processes,Sessions and Transactions
oracle_database_activeConnectionRatioOracle Database Active Connection Ratio%It monitors the ratio of oracle active connections
oracle_database_concurrentUsersOracle Database Concurrent UserscountIt monitors the count of concurrent users
oracle_database_pga_memory_usageOracle Database PGA Memory UsageBytesIt monitors the PGA memory usage (in Bytes) of the each oracle user
oracle_database_size_withDataAndLogFilesOracle Database Size With Data And Log FilesMBIt monitors the oracle database size (in MB) based on log and data files.
oracle_database_locked_users_countOracle Database Locked Users CountcountIt monitors the number of users suspended by locks within a timeout
Oracle System Stats - v3.0oracle.table.scan.blocks.persecTable Scan BlockspsecNumber of blocks received via table scans.
oracle.user.commitsUser CommitspsecThis metric represents the number of user commits performed per second in last two monitoring polls.
oracle.logons.per.secLogons Per SeccountThis metric represents the number of logons per second during the sample period.
oracle.cache.blocks.lostCache Blocks LostcountThis metric represents the number of global cache blocks lost over the user-defined observation period.
oracle.user.rollbacks.persecUser RollbackspsecThis metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
oracle.io.wait.timeIO Wait TimemsHow much time the application was blocked,waiting for all I/O operation to complete
oracle.check.db.aliveCheck Db AliveNULLMonitors connectivity to the database instance.
oracle.db.instance.uptimeDB Instance UptimeDaysIt represents db instance uptime since start up.
oracle.redo.log.space.requestsRedo Log Space RequestsReq per SecIt represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.

G2-OracleDB-System Summary

Description

G2-OracleDB-System Summary

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle System Summaryoracle.cpu.usage.per.secCPU Usage Per SecNULLThis metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
oracle.cpu.usage.per.txnCPU Usage Per TxnNULLThe amount of CPU usage per transaction for the specific task or session.
oracle.database.cpu.time.ratioDatabase CPU Time RatioNULLThe Database CPU Time Ratio is of limited value as a tuning tool.The Database CPU Time Ratio is computed by dividing the amount of CPU used 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.executions.per.txnExecutions Per TxnNULLThe average amount of time per execution
oracle.executions.per.secExecutions Per SecNULLThe average transactions per second
oracle.sql.service.response.timeSql Service Response TimemsSQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
oracle.user.transaction.per.secmUser Transaction Per SecNULLThe User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period.
oracle.response.time.per.txnResponse Time Per TxnNULLThe Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period.
oracle.database.wait.time.ratioDatabase Wait Time RatioNULLIt monitors database wait time ratio.

G2-OracleDB-System Summary - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle System Summaryoracle.cpu.usage.per.secCPU Usage Per SecNULLThis metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
oracle.cpu.usage.per.txnCPU Usage Per TxnNULLThe amount of CPU usage per transaction for the specific task or session.
oracle.database.cpu.time.ratioDatabase CPU Time RatioNULLThe Database CPU Time Ratio is of limited value as a tuning tool.The Database CPU Time Ratio is computed by dividing the amount of CPU used 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.executions.per.txnExecutions Per TxnNULLThe average amount of time per execution
oracle.executions.per.secExecutions Per SecNULLThe average transactions per second
oracle.sql.service.response.timeSql Service Response TimemsSQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
oracle.user.transaction.per.secmUser Transaction Per SecNULLThe User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period.
oracle.response.time.per.txnResponse Time Per TxnNULLThe Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period.
oracle.database.wait.time.ratioDatabase Wait Time RatioNULLIt monitors database wait time ratio.

G2-OracleDB-Table Space

Description

G2-OracleDB-Table Space

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Table Spaceoracle.table.space.utilTable Space Utilization%It monitors the table space utilization
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space FreeMbIt monitors temporary table space free
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization
oracle.table.space.freeOracle Table Space FreeMBValidates the Size allocated for the table by database.

G2-OracleDB-Table Space - v2.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Table Space - v2.0oracle.table.space.utilTable Space Utilization%It monitors the table space utilization
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space FreeMbIt monitors temporary table space free
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization
oracle.table.space.freeOracle Table Space FreeMBValidates the Size allocated for the table by database.

G2-OracleDB-Table Space - v3.0

Description

This template supports both SID and Service name connection types Integration is done through JDBC and SQL queries.

Prerequisites

Gateway 7.0.0 and above.

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Oracle Database Tablespace Monitororacle_database_tablespace_statusOracle Database Tablespace StatusNULLIt monitors the status of the each tablespace in oracle. Below are the possible values: ONLINE,OFFLINE,READ ONLY
oracle_database_remaining_extentsOracle Database Remaining ExtentscountOracle Database Remaining Extents
oracle_database_rollbackSegmentsOracle Database Rollback SegmentscountIt monitors the value of a sufficient number of rollback segments.
oracle_database_tablespace_sizeOracle Database Tablespace SizeMBThis metric monitors the size (in MB) for each available TABLESPACES
oracle_database_tablespace_deficit_statusOracle Database Tablespace Deficit StatusNULLIt monitors the deficit status of the 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)"
oracle_database_tablespace_freeSpaceOracle Database Tablespace FreeSpace%It monitors the free space utilization of the each tablespace in oracle.
oracle_database_tablespace_temp_freeOracle Database Tablespace Temp FreeBytesIt monitors the free space (in Bytes) of the temp tablespace
oracle_database_no_next_extentsOracle Database No Next ExtentscountIt monitors the count of database segments which are having no next extent
Oracle Table Space - v3.0oracle.table.space.utilTable Space Utilization%It monitors the table space utilization
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space FreeMbIt monitors temporary table space free
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization
oracle.table.space.freeOracle Table Space FreeMBValidates the Size allocated for the table by database.