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
andsrvctl
commands).
Note
The G2-OracleDB-Listener global monitor is designed to work only with Oracle RAC setups. It is not compatible with Oracle standalone setups.Supported Versions |
---|
19.3.0.0.0 |
Privilege | Description | Example |
---|---|---|
CONNECT | Give the user connect role before assigning privileges. | GRANT CONNECT TO MY_USER; |
SELECT ANY DICTIONARY | Minimum 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
Name | Default Value | Description |
---|---|---|
Host | 127.0.0.1 | IP Address of the server |
Port | The port on which OracleDB server is running. | |
User Name | NA | The username of the OracleDB Server, if authentication is enabled. |
Password | NA | The password of the OracleDB Server, if authentication is enabled. |
Note: All field attributes are mandatory, use default values wherever applicable.
Collected Metrics
Metric Name | Display Name | Description | Unit |
---|---|---|---|
Oracle_BlockingLockQueries | Oracle Blocking Lock Queries | Validates the number of block lock queries on a specific database. | Count |
Oracle_CacheInvalidations | Oracle Cache Invalidations | Validates the number of cache invalidations on a specific database. | Count |
Oracle_DataFileDiskReads | Oracle Data File Disk Reads | Validates the number of data file disk reads by the database. | Count |
Oracle_DataFileDiskWrites | Oracle Data File Disk Writes | Validates the number of data file disk writes to database. | Count |
Oracle_DataFilelesizeAllocated | Oracle Data File Disk Allocated | Validates the data file size allocated for the database. | MB |
Oracle_LibraryCacheGets | Oracle Library Cache Gets | Validates the number of Library Cache gets by database. | Count |
Oracle_LibraryCacheReloads | Oracle Library Cache Reloads | Validates the number of Library Cache reloads by database. | Count |
Oracle_LongRunningQueries | Oracle Long Running Queries | Validates the number of long running queries on a specific database. | Count |
Oracle_Processes | Oracle Processes | Validates the number of processes on a specific database. | Count |
Oracle_Sessions | Oracle Sessions | Validates the number of sessions currently on a specific database. | Count |
Oracle_TableSpaceAllocated | Oracle Table Space Allocated | Validates the size allocated for the table by database. | MB |
Oracle_TableSpaceFree | Oracle Table Space Free | Validates the free space allocated for the table by database. | MB |
Oracle_TablescanBlocks | Oracle Table scan Blocks | Validates the number of table scan blocks by database. | Count |
Oracle_UserRollbacks | Oracle User Rollbacks | This 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_UsersCommit | Oracle Users Commit | Validates 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:
- Select Infrastructure and click Resources.
- Click the Settings icon on the top-right and click Add.
- On the Add Device page, enter the Device Type and any other information you want to enter.
- Click Save.
Prepare the device to start monitoring
- Associate appropriate database credentials to the discovered database.
- 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 Parameter | Description |
---|---|
Connection Time-out | The 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 Type | To 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 Port | The 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 Name | The name of the database to connect to. The default name is system.
|
Application Type | The application type value to identify the adapter. For example, ORACLE_DB. Warning: Do not change the default application type value. |
TLS Connection | This 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.
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 Type | Template Name |
---|---|
Gateway | G2-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 Name | Display Name | Description | Unit |
---|---|---|---|
Oracle_asm_alertlog_size | Oracle ASM AlertLog Size | This metric monitors the disk used space (in MB) by ASM alert log. | megabytes(MB) |
Oracle_database_archivelog_total_usage | Oracle Database Archive Log Total Usage | This metric monitors the total size (in GB) of Archive log. | Gigabytes(GB) |
Oracle_database_archfile_usage | Oracle Database ArchFile Usage | This metric monitors the size (in MB) of each Arch file. | MB |
Oracle_database_datafile_availability | Oracle Database Datafile Availability | This metric monitors the datafile availability. Below are the possible values: 1 - AVAILABLE 2 - INVALID | N/A |
Oracle_database_invalid_objects | Oracle Database Invalid Objects | This metric displays invalid objects available or not. | N/A |
Oracle_database_locked_critical_users | Oracle Database Locked Critical Users | This metric monitors the locked critical users information. | N/A |
Oracle_database_backup_mode | Oracle Database Backup Mode | This metric monitors the oracle database backup mode like Active or InActive. | N/A |
Oracle_database_archivegap_detection | Oracle Database Archive Gap Detection | This metric monitors the Archive GAP detection. | N/A |
Oracle_asm_diskgroup_type | Oracle ASM Disk Group Type | This metric displays the type of the ASM disk group. | N/A |
Oracle_asm_disk_mode_status | Oracle Database Restore Point Guarantee Flashback Status | Monitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values: YES - 1 NO - 0 | N/A |
Oracle_database_daysSinceLastRestorePoint | Oracle Database Days Since Last Restore Point | Monitors the age (In Days) of last successful restore point. | Days |
Oracle_database_restorePoint_GuaranteeFlashback_Status | Oracle Database Restore Point Guarantee Flashback Status | Monitors the Oracle DB backup restore point Guarantee Flashback DB Status. Below are the possible values: YES - 1 NO - 0 | N/A |
oracle_database_daysSinceLastRestorePoint | Oracle Database Days Since Last Restore Point | Monitors the age (In Days) of last successful restore point. | Days |
Oracle_database_blockCorruption_count | Oracle Database Block Corruption Count | Monitors the count of block corruption in Oracle DB. | Count |
Oracle_database_blockCorruption_type | Oracle Database Block Corruption Type | Monitor the type of block corruption in Oracle DB. | N/A |
Oracle_database_undoUnexpired_count | Oracle Database Undo Unexpired Count | Monitors the count of Undo Unexpired in Oracle DB. | Count |
Oracle_database_indexLogging_count | Oracle Database Index Logging Count | Monitors the count of Index logging in Oracle DB. | Count |
Oracle_database_licenseOptionUsage_status | Oracle Database License Option Usage Status | Monitors the Oracle DB License Option Usage Status: Below are the possible values: YES - 1 NO - 0 | N/A |
Oracle_database_redoLog_status | Oracle Database RedoLog Status | Monitors 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_archive | Oracle Database Archive Backup DaysAgo | Monitors the status of the Oracle Database Archive Backup DaysAgo. | Days |
Oracle_database_backup_full | Oracle Database Archive Backup DaysAgo | Monitors the status of the Oracle Database Full Backup DaysAgo. | Days |
Oracle_database_backup_usermanaged | Oracle Database User Managed Backup DaysAgo | Monitors the status of the Oracle Database User Managed Backup DaysAgo | Days |
Oracle_database_backup_incremental | Oracle Database Incremental Backup DaysAgo | Monitors the status of the Oracle Database Incremental Backup DaysAgo. | Days |
Oracle_database_backup_rman | Oracle Database RMAN Backup DaysAgo | Monitors the status of the Oracle Database RMAN Backup DaysAgo. | Days |
Oracle_database_scheduler_jobs_status | Oracle Database Scheduler Jobs Status | Monitors the status of the Oracle Database Scheduler Jobs Status. | N/A |
Oracle_database_dbmsjobs_failure_count | Oracle Database DBMS Jobs Failure Count | Monitors the status of the Oracle Database DBMS Jobs Failure Count. | Count |
Oracle_database_autotask_job_status | Oracle Database AutoTask Job Status | Monitors the status of the Oracle Database AutoTask Job. | N/A |
Oracle_database_lockedusers_status | Oracle Database Locked Users Status | Monitors the status of the Oracle Database Locked Users. | N/A |
Oracle_blocking_session_count | Oracle Blocking Session Count | Monitors the status of the Oracle Blocking Session Count. | Count |
Oracle_asm_disk_status | Oracle ASM Disk Status | Monitors the status of the Oracle ASM Disk. | N/A |
Oracle_asm_acfs_status | Oracle ASM ACFS Status | Monitors the status Oracle ASM ACFS. | N/A |
Oracle_asm_diskgroup_utilization | Oracle ASM DiskGroup Space Utilization | Monitors the status of the Oracle ASM DiskGroup Space Utilization. | Percentage(%) |
Oracle_database_required_mirror_freespace | Oracle Database Required Mirror Free Space | Monitors the status of the Oracle Database Including different redundancy requirements (Safely usable data usage). | MB |
Oracle_database_safelyusable_diskspace | Oracle Database Safely Usable Disk Space | Monitors the status of the Oracle Database Including safely usable disk space on different redundancy (Safely usable data usage). | MB |
Oracle_database_tablespace_usedPercent | Oracle Database Tablespace Used Percent | Monitor the Oracle table space used percent. | % |
Oracle_database_flash_recovery_usage | Oracle Database Flash Recovery Usage | Flash recovery usage (in MB) of the oracle database. | MB |
Oracle_database_flashback_log_usage | Oracle Database FlashBack Log Usage | FlashBack Log usage in percent. | % |
Oracle_database_recoveryDest_used_percentage | Oracle Database RecoveryDest Used Percentage | Oracle Database Recovery Destination usage in Percent. | % |
Oracle_database_recoveryDest_size | Oracle Database RecoveryDest Size | Oracle Database Recovery Destination Size in MB. | MB |
Oracle_database_recoveryDest_used_size | Oracle Database RecoveryDest Used Size | Oracle Database Recovery Destination Used Size in MB. | MB |
Oracle_database_component_status | Oracle Database Component Status | Oracle 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_archiveLogMode | Oracle Database Archive Log Mode | Monitors the archive log mode of the instance. Below are the possible values: 0 - NOARCHIVELOG 1 - ARCHIVELOG 2 - MANUAL | N/A |
Oracle_database_password_expiry_Days | Oracle Database Password Expiry Days | Monitors the users password expiry in days. | Days |
Oracle_database_users_default_password | Oracle Database Users Default Password | Monitors the count of users which are using default password. | Count |
Oracle_database_alertLog_availability | Oracle Database Alert Log Availability | Monitors the alert log availability of given instances. Below are the possible values: 0 - Not Available 1 - Available | N/A |
Oracle_database_alertLog_writeAccessibility | Oracle Database Alert Log Write Accessibility | Monitors the alert log write accessibility of given instances. Below are the possible values: 0 - Not Accessible 1 - Accessible | N/A |
Oracle_database_alertLog_readAccessibility | Oracle Database Alert Log Read Accessibility | Monitors the alert log read accessibility of given instances. Below are the possible values: 0 - Not Accessible 1 - Accessible | N/A |
Oracle_database_listenerSID_availability | Oracle Database Listener SID Availability | This 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_Usedstatus | Oracle Database Monitored License Used Status | It 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_limit | Oracle Database Resource Process Limit | Monitor the Oracle Database resource process limit. | Count |
Oracle_database_resource_session_limit | Oracle Database Resource Session Limit | Monitor the Oracle Database resource session limit. | Count |
Oracle_database_listener_service_status | Oracle Database Listener Service Status | This metric monitors the status of database services associated with an Oracle listener. | N/A |
Oracle_database_local_listener_status | Oracle Database Local Listener Status | This 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 Status | This 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 Nodes | This metric monitor the Oracle Database Listener Status With Nodes. | N/A |
Oracle_database_scan_listener_status | Oracle Database Scan Listener Status | This metric monitor the status of Oracle Database Scan Listener. | N/A |
Oracle_database_listener_availability | Oracle Database Listener Availability | This 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 Broker | It monitor the Oracle DataGuard DB Role Change with DataGuard Broker. | N/A |
Oracle.session.limit.usage | Session Limit Usage | It monitors the sessions utilization. | % |
Oracle.inactive.sessions | Inactive Sessions | It monitors the inactive sessions. | Count |
Oracle.active.sessions | Active Sessions | It monitors the active sessions. | Count |
Oracle_session_waits_perEvent | Oracle Session Waits PerEvent | Monitors 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 PerClass | 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). | S |
Oracle_database_avgGlobalLockGetTime | Oracle Database Average Global Lock Get Time | It monitors the average global lock get time (in milliseconds). | Milliseconds(ms) |
Oracle_database_bufferCachehitRatio | Oracle Database Buffer Cache Hit Ratio | It monitors the buffer cache hit ratio. | % |
Oracle_database_chainedRows | Oracle Database Chained Rows | It monitors the count of chained rows from all available tables in oracle database. | Count |
Oracle_database_dictionaryCacheHitRatio | Oracle Database Dictionary Cache Hit Ratio | It monitors the Dictionary cache hit ratio. | % |
Oracle_database_gc_blocks_corrupt | Oracle Database Global Cache Blocks Corrupt | It monitors the value of the global cache blocks corrupt. | Count |
Oracle_database_gc_blocks_lost | Oracle Database Global Cache Blocks Lost | It monitors the value of the global cache blocks lost. | N/A |
Oracle_database_gc_cr_timeouts | Oracle Database Global Cache Consistent Read Timeouts | It 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 Timeouts | It 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 Utilization | It 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 Count | It monitors the count of the unusable indexes in the oracle database. | Count |
Oracle_database_cacheFusionWrites | Oracle Database Cache Fusion Writes Ratio | It monitors the ratio of cache fusion writes. | % |
Oracle_database_redoLog_contention | Oracle 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_memory_sortRatio | Oracle Database Memory Sort Ratio | It monitors the ratio of memory sorts. | % |
Oracle_database_concurrentUsers | Oracle Database Concurrent Users | Monitors the count of concurrent users. | Count |
Oracle_database_overallSize | Oracle Database Overall Size | Monitors 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 Files | Monitors the oracle database size (in MB) based on log and data files. | MB |
Oracle_database_locked_users_count | Oracle Database Locked Users | Monitors the number of users suspended by locks within a timeout. | Count |
Oracle_database_resource_utilization | Oracle Database Resource Utilization | Monitors the resource utilization for the resources: Processes, Sessions and Transactions. | % |
Oracle_database_pga_memory_usage | Oracle Database PGA Memory Usage | Monitors the PGA memory usage (in Bytes) of the each oracle user. | Bytes |
Oracle_database_activeConnectionRatio | Oracle Database Active Connection Ratio | Monitors the ratio of oracle active connections. | % |
Oracle_database_activeUsers | Oracle Database Active Users | Monitors the count of oracle active users. | Count |
Oracle_database_remaining_extents | Oracle Database Remaining Extents | Monitors the count of remaining extents for each tablespace in the oracle. | Count |
Oracle_database_rollbackSegments | Oracle Database Rollback Segments | Monitors the value of a sufficient number of rollback segments. | N/A |
Oracle_database_tablespace_freeSpace | Oracle Database Tablespace FreeSpace | Monitors the free space utilization of each tablespace in oracle. | % |
Oracle_database_tablespace_status | Oracle Database Tablespace Status | N/A | Monitors 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 Status | It 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 Size | It monitors the size(in MB) of the each tablespace (including temp tablespace). | MB |
Oracle_database_tablespace_temp_free | Oracle Database Tablespace Temp Free | Monitors the free space (in Bytes) of the temp tablespace. | Bytes |
Oracle_database_no_next_extents | Oracle Database No Next Extents | Monitors the count of database segments which are having no next extent. | Count |
oracle_asm_diskgroup_status | Oracle ASM DiskGroup Status | Monitors the Oracle ASM disk group status. | N/A |
oracle_asm_failure_groups_status | Oracle ASM Failure Groups Status | Monitors the Oracle ASM failure groups status. | N/A |
oracle_blocking_session_count | Oracle Blocking Session Count | Monitors the Oracle blocking session count. | count |
oracle_database_archivegap_detection | Oracle Database Archive Gap Detection | Monitors the Oracle Database Archive Gap Detection. | N/A |
oracle_database_blockCorruption_count | Oracle Database Block Corruption Count | Monitors the Oracle Database Block Corruption Count. | count |
oracle_database_daysSinceLastRestorePoint | Oracle Database Days Since Last Restore Point | Monitor the Oracle Database Days Since Last Restore Point. | Days |
oracle_database_redoLog_status | G2-OracleDB-Database Monitoring | G2-OracleDB-Database RedoLog Status Monitor. | N/A |
oracle_database_tablespace_usage_without_autoextend | Oracle Database Tablespace Usage Without AutoExtend | Monitors the Oracle database tablespace usage without autoextend. | % |
oracle_database_tablespace_usedPercent | G2-OracleDB-Database Space Usage | G2-OracleDB-Database Space Usage Monitor. | % |
oracle.asm.archive.pct | Oracle ASM Archive pct | Oracle query for ASM ARCHIVE diskgroup. | % |
oracle.asm.data.pct | Oracle ASM Data pct | Oracle query for ASM DATA diskgroup. | % |
oracle.blocking.lock.queries | Oracle Blocking Lock Queries | Validates the number of block lock queries on a specific database. | Count |
oracle.blocking.session | Oracle Blocking Session | To monitor blocked valid sessions. | Count |
oracle.BufferCacheHitRatio.pct | Oracle BufferCacheHitRatio pct | To monitor buffer cache hit ratio value in percentage. | % |
oracle.cache.blocks.lost | Cache Blocks Lost | The number of global cache blocks lost over the user-defined observation period. | Count |
oracle.cache.invalidations | Oracle Cache Invalidations | Validates the number of cache invalidations on a specific database. | Count |
oracle.check.db.alive | Check Db Alive | Monitors database instance connectivity. | N/A |
oracle.cpu.usage.per.sec | CPU Usage Per Sec | The 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 Txn | The amount of CPU usage per transaction for a specific task or session. | % |
oracle.database.cpu.time.ratio | Database CPU Time Ratio | 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 . | % |
oracle.database.wait.time.ratio | Database Wait Time Ratio | Monitors the database wait time ratio. | % |
oracle.db.instance.uptime | DB Instance Uptime | The db instance uptime since start up. | Days |
oracle.disk.sort.ratio.pct | Oracle Disk Sort Ratio pct | To monitor disk sort ratio value in percentage. | % |
oracle.duplicated.filename.count | Oracle Duplicated Filename Count | To check the existence of duplicate db file names in different ASM paths. | Count |
oracle.executions.per.sec | Executions Per Sec | The average transactions per second. | Per Second(psec) |
oracle.executions.per.txn | Executions Per Txn | The average amount of time per execution. | N/A |
oracle.failed.logon.count | Failed Logon Count | Monitors the failed logon attempts of the current user. | Count |
oracle.invalid.objects | Invalid Objects | Checks for invalid objects in a database. | Count |
oracle.io.wait.time | IO Wait Time | The 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 Free | Monitors the free java pool memory in MB. | Mega Bytes(MB) |
oracle.large.pool.free | Large Pool Free | Monitors the free large pool memory in MB. | Mega Bytes(MB) |
oracle.library.cache.gets | Oracle Library Cache Gets | Validates the number of library cache gets by the database. | Count |
oracle.library.cachereloads | Library Cache Reloads | Validates the number of library cache reloads by the database. | N/A |
oracle.librarycachehitratio.pct | Oracle Library Cache Hit Ratio pct | To monitor the library cache hit ratio value in percentage. | % |
oracle.logons.per.sec | Logons Per Sec | The number of logons per second during the sample period. | Count |
oracle.long.running.queries | Oracle Long Running Queries | Validates the number of long running queries on a specific database. | Count |
oracle.maxdbfilepct.usage | Oracle Max DB File pct usage | To monitor the percentage of open oracle files. | % |
oracle.maxopencursor.username.count | Oracle Max Open Cursor Username Count | To monitor maximum open cursor value for each db username. | Count |
oracle.process.count | Process Count | Monitor the current processes running in the database. | N/A |
oracle.procsused.pct | Oracle Processes Used pct | To monitor db process usage in percentage. | % |
oracle.rac.tablespace.space.used | Oracle RAC Tablespace Space Used Top 20 Greaterthan 85 | To monitor top(20) RAC tablespace space usage where percentage > 85%. | % |
oracle.redo.log.space.requests | Redo Log Space Requests | The 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 Count | To monitor the number of redolog switch. | Count |
oracle.sequence.pctused | Oracle Sequence Pct Used | To monitor the sequence usage in percentage. | % |
oracle.session.cpu_used | Session Cpu Used | Monitors the session cpu usage in seconds. | Seconds(s) |
Refer to the Oracle Cloud (OCI) for more information about Oracle Cloud.