Page tree
Skip to end of metadata
Go to start of metadata

This topic describes the metrics supported by the Oracle extractor suite, in particular by Oracle Enterprise Manager (OEM), for entities such as database server, database instance, database cluster, and Real Application Cluster (rac).

Note

All the metrics collected from Oracle Enterprise Manager are supported by the Database Diagnostics (DD) Pack. 

Database Server (dbs) metrics

Load

TrueSight Capacity Optimization metricDescriptionOEM metric
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 memoryactiveMem
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_UTILThe percentage of logical memory in use during the interval.usedLogicalMemoryPct

Disk activity summary (DiskActivitySummary)

TrueSight Capacity Optimization metricDescriptionOEM metric
DISK_IO_RATE

Disk Average I/O Rate aggregated by host

totiosmade

Disk activity (DiskActivity)

TrueSight Capacity Optimization metricDescriptionOEM metric
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

File system (Filesystems)

TrueSight Capacity Optimization metricDescriptionOEM metric
BYLDISK_USED_SPACE_PCT

The percentage of used disk space specified in the subobject.

pctAvailable
BYLDISK_SIZE

Logical disk size (bytes).

size

Network

TrueSight Capacity Optimization metricDescriptionOEM metric
BYIF_IN_BIT_RATEInput Bit Rate by Network InterfacereadRate
BYIF_BIT_RATETotal BitRate by Network InterfacetotalRate
BYIF_PKT_ERR_PCTError packets % by Network Interface totalErrorRate
BYIF_UTIL Network Utilization by Network InterfacetotalThroughput
BYIF_OUT_BIT_RATEOutput Bit Rate by Network InterfacewriteRate

Paging activity (PagingActivity)

TrueSight Capacity Optimization metricDescriptionOEM metric
MEM_PAGE_OUT_RATE Memory Page Output RatePagingActivityppgout

Host storage history (host_storage_history)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_DATA_FREE_SIZE

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

db_free
DB_DATA_USED_SIZEUsed space for database data filesdb_used
DB_TOTAL_FREE_SIZE

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

total_free
DB_TOTAL_USED_SIZEThe amount of used space within the allocated spacetotal_used
DB_TOTAL_UNALLOCATED_SIZE

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

total_unallocated
DISK_USED_SPACEThe total amount of used space on the physical disk, in bytesdisks_allocated
DISK_FREEThe total amount of free space on the physical disk, in bytes.disks_unallocated
ASM_NUMNumber of Automatic Storage Managementsummarized_asm
HOST_NUMNumber of Hostssummarized_hosts
DB_NUMNumber of Databasessummarized_dbs
TOTAL_FS_USEDUsed Disk Space on all filesystemstotal_used

Database Server configuration metrics

If the MGMT$HW_CPU_DETAILS view is available in OEM, the following cofiguration metrics are supported.

TrueSight Capacity Optimization metricDescriptionOEM metric
CPU_MODELThe model of the CPU.MA
CPU_MHZThe CPU speed.FREQ
TOTAL_REAL_MEMThe total real memory that is allocated to the database instance.MEM
DISK_SIZEThe disk size.DISK
CPU_NUMThe number of available CPUs.CPU_COUNT
LCPU_NUMThe number of available logical CPUs.CPU_COUNT

If the MGMT$HW_CPU_DETAILS view is not available but the MGMT$OS_HW_SUMMARY view is available, the following cofiguration metrics are supported.

TrueSight Capacity Optimization metricDescriptionOEM metric
CPU_MODELThe model of the CPU.MA
CPU_MHZThe CPU speed.FREQ
TOTAL_REAL_MEMThe total real memory that is allocated to the database instance.MEM
DISK_SIZEThe disk size.DISK
CPU_NUMThe number of available CPUs.CPU_COUNT

For the MGMT$TARGET_TYPE_PROPERTIES view, the following metrics are supported:

TrueSight Capacity Optimization metricDescriptionOEM metric
OS_TYPEThe type of operation system.OS
OS_VERThe version of the operating system.Version
NET_IP_ADDRESSThe IP address.IP_address

Database Instance (db) metrics

Database Archfull (ArchFull)

TrueSight Capacity Optimization metricDescriptionOEM metric
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

Database resource usage (Database_Resource_Usage)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_LOGONS_CURRENT

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

logons

Database instance efficiency (instance_efficiency)

TrueSight Capacity Optimization metricDescriptionOEM metric
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_CSCPU time used by database processes, in centisecondscpuusage_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

Database instance throughput (instance_throughput)

TrueSight Capacity Optimization metricDescriptionOEM metric
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

Dump full (dumpFull)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_DUMP_FREE_SIZEFree space available for dump areadumpAvail
DB_DUMP_ALLOCATED_SIZEAllocated space for dump areadumpTotal
DB_DUMP_USED_SIZEUsed space for database dump areadumpUsed
DB_DUMP_USED_SIZE_PCTPercentage of space used for database dump areadumpUsedPercent

Database size (DATABASE_SIZE)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_TOTAL_USED_SIZESpace utilization percentage for the datastore specified in the subobject [DATA]USED_GB
DB_TOTAL_ALLOCATED_SIZESpace utilization percentage for the datastore specified in the subobject [DATA]ALLOCATED_GB

Tablespace allocation (tbspAllocation)

TrueSight Capacity Optimization metricDescriptionOEM metric
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

Problem table space (problemTbsp)

TrueSight Capacity Optimization metricDescriptionOEM metric
BYDS_DATA_USED_SIZE_PCT

Space utilization percentage for the datastore specified in the subobject DATA

pctUsed

System Global Area pool wastage (sga_pool_wastage)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_SGA_SHARED_POOL_FREE_PCTOracle SGA Pool Wastage - shared pool free percentageshared_free_pct
DB_SGA_JAVA_POOL_FREE_PCTOracle SGA Pool Wastage - Java pool free percentagejava_free_pct
DB_SGA_LARGE_POOL_FREE_PCTOracle SGA Pool Wastage - large pool free percentagelarge_free_pct
DB_JAVA_POOL_SIZETotal size for the Java PoolJava Pool (MB)
DB_SGA_MAXIMUM_SIZEMaximum size for the SGA (System Global Area). Oracle specific metric.Maximum SGA (MB)
DB_SGA_SIZETotal 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_SIZESize for the PGA (Program Global Area). Oracle specific metric.pga_aggregate_target
DB_MEMORY_TARGETThe value of the parameter memory_target for an Oracle database instancememory_target

Database instance configuration metrics

For the MGMT$TARGET_PROPERTIES view, the following metrics are supported:

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_HOST_NAMEThe host name where the database is installed.MachineName
DB_PRODUCT_VERSIONThe version of the database.DBVersion
DB_CPU_COUNTThe number of database CPUs.CPUCount
DB_NAMEThe name of the database.DBName
DB_PRODUCT_NAMEThe name of the product.VersionBanner

Real Application Clusters (rac) metrics

Tablespace allocation (tbspAllocation)

TrueSight Capacity Optimization metricDescriptionOEM metric

BYDS_DATA_ALLOCATED_SIZE

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

spaceAllocated
BYDS_DATA_USED_SIZESpace used by the datastore specified in the subobject [DATA]spaceUsed

Problem tablespace (problemTbsp)

TrueSight Capacity Optimization metricDescriptionOEM metric

BYDS_DATA_USED_SIZE_PCT

Space utilization percentage for the datastore specified in the subobject DATA

pctUsed

Service performance (service_performance)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_CPU_USED

Percentage of CPU used by database processes.

cpuload

Database size (DATABASE_SIZE)

TrueSight Capacity Optimization metricDescriptionOEM metric
DB_TOTAL_USED_SIZESpace utilization percentage for the datastore specified in the subobject [DATA]USED_GB
DB_TOTAL_ALLOCATED_SIZESpace utilization percentage for the datastore specified in the subobject [DATA]ALLOCATED_GB

Monitored hosts metrics

The following configuration and performance metrics are supported for monitored hosts:

Configuration

  • CPU_FAMILY
  • CPU_MHZ
  • CPU_MODEL
  • CPU_NUM
  • DISK_SIZE
  • LCPU_NUM
  • NET_IP_ADDRESS
  • OS_FAMILY
  • OS_TYPE
  • OS_VER
  • TOTAL_REAL_MEM

Performance

  • CPU_RUN_QUEUE
  • CPU_UTIL
  • CPU_UTIL_SYSTEM
  • CPU_UTIL_USER
  • CPU_UTIL_WAIO
  • DISK_IO_RATE
  • MEM_ACTIVE
  • MEM_PAGE_OUT_RATE
  • MEM_PAGE_SCAN_RATE
  • MEM_REAL_UTIL
  • MEM_UTIL
  • PROCESS_NUM_RUNNING
  • SWAP_SPACE_UTIL

Configuration metrics

  • OS_VER
  • OS_TYPE
  • NET_IP_ADDRESS
  • CPU_MHZ
  • TOTAL_REAL_MEM
  • DISK_SIZE
  • CPU_NUM
  • DB_HOST_NAME
  • DB_PRODUCT_VERSION
  • DB_CPU_COUNT
  • DB_NAME
  • DB_PRODUCT_NAME

Lookup details

The OEM extractor defines multiple lookup fields. The following table lists the sequence of field set for strong and weak lookup.

For more information, see Understanding entity identification and lookup.

Entity typeStrong lookup fieldsWeak lookup fields
Database System (dbs)OGUID,HOSTNAMENAME
Database Instance (db)OGUIDDB_INSTANCE_NAME&&DB_HOSTNAME
Database Cluster (dbc)OGUID-
Real Application Clusters (rac)OGUIDRAC_NAME

9 Comments

  1.  

    1.  

  2.  

    1.  

    2.  

  3.  

    1.  

  4.  

    1.