Entities, metrics, and lookup details for Oracle Enterprise Manager

CPU_UTIL_WAIO                 

Percentage of time the CPU was waiting for I/O during the interval.

cpuIOWait

CPU_UTIL 

Percentage of time the CPU was not idle during the interval.

cpuUtil

CPU_UTIL_USER 

The percentage of time the CPU was in user mode during the interval.

cpuUser

CPU_RUN_QUEUE 

CPU Run Queue Length

cpuLoad

MEM_UTIL 

The percentage of physical memory in use during the interval.

memUsedPct

MEM_ACTIVE 

Sum of the physical memory sizes of the data and stack regions for processes that are currently on the run queue or processes that have executed recently, in percentage over physical memory

activeMem

DISK_IO_RATE 

Disk Average I/O Rate aggregated by host

totIO

CPU_UTIL_SYSTEM 

Percentage of time the CPU was in system mode during the interval for each CPU of the system. The subobject specifies the CPU id.

cpuKernel

DISK_SVC_TIME 

Disk Average Service Time aggregated by host

longestServ

PROCESS_NUM_RUNNING 

Running Process Num

noOfProcs

MEM_PAGE_SCAN_RATE 

The number of pages scanned per second by the VMM during the interval.

pgScanRate

SWAP_SPACE_UTIL 

The percentage of utilization of the swap space. The subobject specifies the disk name.

swapUtil

MEM_REAL_UTIL

The percentage of logical memory in use during the interval.

usedLogicalMemoryPct

DISK_IO_RATE

Disk Average I/O Rate aggregated by host

totiosmade

BYDISK_UTIL

The percentage of time in which this disk device was busy transferring data during the interval. The subobject specifies the disk name.

DiskActivitybusy

BYDISK_PHYS_IO_RATE

The average number of physical I/O requests per second for this disk. The subobject specifies the disk ID.

DiskActivityreadwrite

BYDISK_SERVICE_TIME

The average service time for I/O requests that were issued to the device.

DiskActivityavserv

BYDISK_QUEUE_TIME

The average time spent by I/O requests into the queue.

DiskActivityavwait

BYDISK_READ_RATE

The average Bytes per second read from this disk device during the interval. The subobject specifies the Disk id.

diskActivReadsBlks

BYDISK_PHYS_IO_READ_RATE

The average number of physical IO read requests per second for this disk

diskActivReadsPerSec

BYDISK_WRITE_RATE

The average Bytes per second written to this disk device during the interval. The subobject specifies the Disk id.

diskActivWritesBlks

BYDISK_PHYS_IO_WRITE_RATE

The average number of physical IO write requests per second for this disk.

diskActivWritesPerSec

BYLDISK_USED_SPACE_PCT

The percentage of used disk space specified in the subobject.

pctAvailable

BYLDISK_SIZE

Logical disk size (bytes).

size

BYIF_IN_BIT_RATE

Input Bit Rate by Network Interface

readRate

BYIF_BIT_RATE

Total BitRate by Network Interface

totalRate

BYIF_PKT_ERR_PCT

Error packets % by Network Interface 

totalErrorRate

BYIF_UTIL

Network Utilization by Network Interface

totalThroughput

BYIF_OUT_BIT_RATE

Output Bit Rate by Network Interface

writeRate

MEM_SWAP_OUT_BYTE_RATE

 The amount of memory that is moved from the swap to real memory per second.

PagingActivityppgout

DB_DATA_FREE_SIZE

Free space available for data files (DB Data Allocated Size - DB Data Used Size).

db_free

DB_DATA_USED_SIZE

Used space for database data files

db_used

DB_TOTAL_FREE_SIZE

The amount of free space the total allocated data can grow on.

total_free

DB_TOTAL_USED_SIZE

The amount of used space within the allocated space

total_used

DB_TOTAL_UNALLOCATED_SIZE

The database space not yet allocated for data, logs and control files

total_unallocated

DISK_USED_SPACE

The total amount of used space on the physical disk, in bytes

disks_allocated

DISK_FREE

The total amount of free space on the physical disk, in bytes.

disks_unallocated

ASM_NUM

Number of Automatic Storage Management

summarized_asm

HOST_NUM

Number of Hosts

summarized_hosts

DB_NUM

Number of Databases

summarized_dbs

TOTAL_FS_USED

Used Disk Space on all filesystems

total_used

CPU_MODEL

The model of the CPU.

MA

CPU_MHZ

The CPU speed.

FREQ

TOTAL_REAL_MEM

The total real memory that is allocated to the database instance.

MEM

DISK_SIZE

The disk size.

DISK

CPU_NUM

The number of available CPUs.

CPU_COUNT

LCPU_NUM

The number of available logical CPUs.

CPU_COUNT

CPU_MODEL

The model of the CPU.

MA

CPU_MHZ

The CPU speed.

FREQ

TOTAL_REAL_MEM

The total real memory that is allocated to the database instance.

MEM

DISK_SIZE

The disk size.

DISK

CPU_NUM

The number of available CPUs.

CPU_COUNT

OS_TYPE

The type of operation system.

OS

OS_VER

The version of the operating system.

Version

NET_IP_ADDRESS

The IP address.

IP_address

DB_LOG_FREE_SIZE

Free space available for log files (DB Log Allocated Size - DB Log Used Size).

archAvail

DB_LOG_ALLOCATED_SIZE

Allocated space for database log files.

archTotal

DB_LOG_USED_SIZE

Used space for database log files.

archUsed

DB_LOG_USED_SIZE_PCT

Percentage of space used for database log files (DB Log Used Size / DB Log Allocated Size).

archUsedPercent

DB_LOGONS_CURRENT

Total number of current logons. Useful only in V$SYSSTAT.

logons

DB_BUFFER_CACHE_HIT_RATIO

Monitors the rate at which Oracle finds the data blocks it needs in memory over the lifetime of an instance. This monitor indicates the current ratio of buffer cache hits to total requests.

bufcachehit_pct

DB_CPU_TIME_CS

CPU time used by database processes, in centiseconds

cpuusage_ps

DB_CPU_USED

Percentage of database call time that is spent on the CPU.

cpu_time_pct

DB_DICTIONARY_HIT_RATIO

Percentage of times that a procedure execution found the procedure's query plan in procedure cache and available for use.

dictionaryhit_pct

DB_LIBRARY_CACHE_HIT_RATIO

Database library cache hit ratio.

libcache_hit_pct

DB_SOFT_PARSE_PCT

Database soft parse percentage.

softparse_pct

DB_COMMIT_RATE

Number of commits per second.

commits_ps

DB_FULL_SCANS_RATE

Rate at which full table scans of long tables occur.

indxscansfull_ps

DB_PHYSICAL_READS

Total number of data blocks read from disk. This number equals the value of physical reads direct plus all reads into buffer cache.

physreads_ps

DB_TRAN_RATE

The number of transactions per second.

transactions_ps

DB_CONSISTENT_CHANGES

Number of times a user process applied rollback entries to perform a consistent read on the block. Workloads that produce a great deal of consistent changes can consume a great deal of resources.

consistentreadchanges_ps

DB_CONSISTENT_GETS

Number of times a consistent read was requested for a block.

consistentreadgets_ps

DB_BLOCK_CHANGES

Closely related to "consistent changes", this statistic counts the total number of changes that were part of an update or delete operation applied to all blocks in the SGA.

dbblkchanges_ps

DB_BLOCK_GETS

Number of times a CURRENT block was requested.

dbblkgets_ps

DB_EXECUTE_COUNT

Total number of calls (user and recursive) that executed SQL statements.

executions_ps

DB_PARSE_COUNT_TOTAL

Total number of parse calls (hard and soft). A soft parse is a check on an object already in the shared pool, to verify that the permissions on the underlying object have not changed.

parses_ps

DB_PHYSICAL_WRITES

Total number of data blocks written to disk. This number equals the value of physical writes direct plus all writes from buffer cache.

physwrites_ps

DB_REDO_WRITES

Total number of writes by LGWR to the redo log files. Redo blocks written divided by this statistic equals the number of blocks per write.

redowrites_ps

DB_SORTS_DISK

Number of sort operations that required at least one disk write. Sorts that require I/O to disk are quite resource-intensive. Try increasing the size of the initialization parameter SORT_AREA_SIZE.

sortsdisk_ps

DB_TABLE_SCANS_LONG_TABLES

Long tables can be defined as tables that do not meet the short table criteria as described in table scans (short tables).

tabscanslong_ps

DB_LOGONS

Total number of logons from the time when the instance started. Useful only in V$SYSSTAT. It gives an instance overview of all processes that logged on.

logons_ps

 DB_USER_CALLS_RATE

usercalls_ps

DB_DUMP_FREE_SIZE

Free space available for dump area

dumpAvail

DB_DUMP_ALLOCATED_SIZE

Allocated space for dump area

dumpTotal

DB_DUMP_USED_SIZE

Used space for database dump area

dumpUsed

DB_DUMP_USED_SIZE_PCT

Percentage of space used for database dump area

dumpUsedPercent

DB_TOTAL_USED_SIZE

Space utilization percentage for the datastore specified in the subobject [DATA]

USED_GB

DB_TOTAL_ALLOCATED_SIZE

Space utilization percentage for the datastore specified in the subobject [DATA]

ALLOCATED_GB

BYDS_DATA_ALLOCATED_SIZE

Space allocated by the datastore specified in the subobject DATA

spaceAllocated

BYDS_DATA_USED_SIZE

Space used by the datastore specified in the subobject DATA

spaceUsed

BYDS_DATA_USED_SIZE_PCT

Space utilization percentage for the datastore specified in the subobject DATA

pctUsed

DB_SGA_SHARED_POOL_FREE_PCT

Oracle SGA Pool Wastage - shared pool free percentage

shared_free_pct

DB_SGA_JAVA_POOL_FREE_PCT

Oracle SGA Pool Wastage - Java pool free percentage

java_free_pct

DB_SGA_LARGE_POOL_FREE_PCT

Oracle SGA Pool Wastage - large pool free percentage

large_free_pct

DB_JAVA_POOL_SIZE

Total size for the Java Pool

Java Pool (MB)

DB_SGA_MAXIMUM_SIZE

Maximum size for the SGA (System Global Area). Oracle specific metric.

Maximum SGA (MB)

DB_SGA_SIZE

Total size for the SGA (System Global Area). Oracle specific metric.

Total SGA (MB)

DB_SGA_FIXED_SIZE

The installed Oracle products and options determine the fixed size, which changes only if the installed products are altered or removed.

Fixed SGA (MB)

DB_SGA_VARIABLE_SIZE

Its value is determined by parameters such as SHARED_POOL_SIZE, PROCESSES, SESSIONS, and TRANSACTIONS at startup. These parameters control the maximum number of user processes, sessions created by users on the system, and transactions allowed on the system at one time.

Variable SGA (MB)

DB_SGA_REDO_BUFFERS

Size of the redo buffer.

Redo Buffers

DB_PGA_SIZE

Size for the PGA (Program Global Area). Oracle specific metric.

pga_aggregate_target

DB_MEMORY_TARGET

The value of the parameter memory_target for an Oracle database instance

memory_target

DB_HOST_NAME

The host name where the database is installed.

MachineName

DB_PRODUCT_VERSION

The version of the database.

DBVersion

DB_CPU_COUNT

The number of database CPUs.

CPUCount

DB_NAME

The name of the database.

DBName

DB_PRODUCT_NAME

The name of the product.

VersionBanner

DB_HOST_NAME

The host name where the pluggable database is installed.

MachineName

DB_NAME

The name of the pluggable database.

DBName

DB_PRODUCT_VERSION

The version of the database.

DBVersion

BYDS_DATA_ALLOCATED_SIZE

Space allocated by the datastore specified in the subobject [DATA]

spaceAllocated

BYDS_DATA_USED_SIZE

Space used by the datastore specified in the subobject [DATA]

spaceUsed

BYDS_DATA_ALLOCATED_SIZE

Space allocated by the datastore specified in the subobject [DATA]

spaceAllocated

BYDS_DATA_USED_SIZE

Space used by the datastore specified in the subobject [DATA]

spaceUsed

BYDS_DATA_USED_SIZE_PCT

Space utilization percentage for the datastore specified in the subobject DATA

pctUsed

DB_CPU_USED

Percentage of CPU used by database processes.

cpuload

DB_TOTAL_USED_SIZE

Space utilization percentage for the datastore specified in the subobject [DATA]

USED_GB

DB_TOTAL_ALLOCATED_SIZE

Space utilization percentage for the datastore specified in the subobject [DATA]

ALLOCATED_GB

DB_PRODUCT_VERSION

The version of the database.

DBVersion

HOST_NAME

The host name of the virtual machine.

HostName

INSTANCE_ID

The ID of the ASM instance.

InstanceID

ASM_INSTANCE_NAME

The name of the ASM instance.

InstanceName

IS_CLUSTERED_DB

A boolean value that indicates whether the given database is a cluster database.

cluster_database

OS_TYPE

The name of the operating system.

orcl_gtp_os

VERSION

The version of the technology.

Version

CLUSTER_NAME

The name of the cluster.

ClusterName

DB_PRODUCT_VERSION

The version of the database.

DBVersion

ASM_SERVICE_NAME

The name of the ASM service.

ServiceName

HOST_NAME

The host name of the installed ASM cluster.

MachineName

OS_TYPE

The name of the operating system.

orcl_gtp_os

VERSION

The version of the technology.

VersionCategory

DISK_GROUP_NAME

The name of the disk group.

DISK_GROUP

DISK_GROUP_REDUNDANCY

The level of disk group redundancy.

REDUNDANCY

DISK_GROUP_SIZE

The size of the disk group.

TOTAL_SIZE (GB)

DISK_NUM

The number of disks in a disk group.

MEMBER_DISK_COUNT

DISK_GROUP_FREE

The available free space in the disk group in bytes.

free_mb

DISK_GROUP_UTIL

The percentage of space that is used by the disk group.

percent_used

BYDB_DISK_USED

The total size of the used disk per database in bytes.

total_mb

DISK_GROUP_IMBALANCE

The percentage of difference between the space that is allocated to the fullest and emptiest disks in the disk group. This imbalance is specified as a percent of full disk size. A large size imbalance indicates the need for a manual rebalancing of the disk group.

imbalance

DISK_GROUP_SIZE_VARIANCE

The percentage of difference between the size of the largest and smallest disks in the disk group. This variance is zero if all the disks are of the same size. A large size variance indicates the need for reconfiguring the disks to evenly distribute the file contents and space across the disks in the disk group.

variance

DISK_GROUP_FREE_IMBALANCE

The percentage of available free space on the fullest disk before the rebalancing of disks. A small value of this imbalance indicates the need to evenly distribute the file contents and space across the disks in the disk group.

computedMinFree

Database System (dbs) 

OGUID,HOSTNAME

NAME

Database Instance (db)

OGUID

DB_INSTANCE_NAME&&DB_HOSTNAME

Pluggable Database Instance (pdb)

OGUID

DB_INSTANCE_NAME&&DB_HOSTNAME

Database Cluster (dbc)

OGUID

-

Real Application Clusters (rac)

OGUID

RAC_NAME

ASM Instance (asmi:ora)

OGUID

-

ASM Cluster (asmc:ora)

OGUID

-

ASM Disk Group (asmdg:ora)

OGUID

DISK_GROUP_NAME