Collector Type: Agent

Category: Application Monitors

Application Name: oracledb

Global Template Name: DB-Oracle DotNet v4

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.

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 NameDescription
oracle.blocking_lock_queriesOracle Blocking Lock Queries
oracle.cache_invalidationsOracle Cache InvalidationsValidates the how many Cache invalidations on particular database.
oracle.data_file_disk_readsOracle Data File Disk ReadsValidates the Number of Data file disk reads by database.
oracle.data_file_disk_writesOracle Data File Disk WritesValidates the Number of Data file disk writes to database.
oracle.data_filelesize_allocatedOracle Data File Disk AllocatedValidates the Data File Size Allocated for the database.
oracle.library_cache_getsOracle Library Cache GetsValidates the Number of Library Cache gets by database.
oracle.library_cache_reloadsOracle Library Cache ReloadsValidates the Number of Library Cache Reloads by database.
oracle.long_running_queriesOracle Long Running Queries
oracle.processesOracle Processes
oracle.sessionsonsOracle Sessions
oracle.table_space_allocatedOracle Table Space AllocatedValidates the Size allocated for the table by database.
oracle.table_space_freeOracle Table Space Free
oracle.tablescan_blocksOracle Table scan BlocksValidates the Number of Table scan blocks by database.
oracle.user_rollbacksOracle User RollbacksValidates the Number of User Roll backs.
oracle.users_commitOracle Users CommitValidates Number of User commits