cellsrvstat Collects Storage Server Statistics Using cellsrvstat

Collects Storage Server Statistics Using cellsrvstat

Cellsrvstat is use to get quick cell level statistics from particular cell storage. Each CELL contains tool like cellsrvstat which gives brief information about CELL level statistics. It also helps you to get information of offloading and storage index.

It is very useful utility to get the cell level statistics for all the logical components of cell like Memory,IO,SmartIO,Flashcache etc

To take help for this utility execute below :

[root@ec117 ~]# cellsrvstat -h

LRM-00101: unknown parameter name 'h'

Usage:

cellsrvstat [-stat_group=<group name>,<group name>,]

[-offload_group_name=<offload_group_name>,]

[-database_name=<database_name>,]

[-stat=<stat name>,<stat name>,] [-interval=<interval>]

[-count=<count>] [-table] [-short] [-list]

stat A comma separated list of short strings representing

the stats. Default is all. (unless -stat is specified).

The -list option displays all stats.

Example: -stat=io_nbiorr_hdd,io_nbiowr_hdd

stat_group A comma separated list of short strings representing

stat groups. Default: all except database

(unless -stat_group is specified).

The -list option displays all stat groups.

The valid groups are: io, mem, exec, net,

smartio, flashcache, offload, database.

Example: -stat_group=io,mem

offload_group_name

A comma separated list of short strings representing

offload group names.

Default: cellsrvstat -stat_group=offload

(all offload groups unless -offload_group_name is specified).

Example: -offload_group_name=SYS_121111_130502

database_name A comma separated list of short strings representing

database group names.

Default: cellsrvstat -stat_group=database

(all databases unless -database_name is specified).

Example: -database_name=testdb,proddb

interval At what interval the stats should be obtained and

printed (in seconds). Default is 1 second.

count How many times the stats should be printed.

Default is once.

list List all metric abbreviations and their descriptions.

All other options are ignored.

table Use a tabular format for output. This option will be

ignored if all metrics specified are not integer

based metrics.

short Use abbreviated metric name instead of

descriptive ones.

error_out An output file to print error messages to, mostly for

debugging.

In non-tabular mode, The output has three columns. The first column

is the name of the metric, the second one is the difference between the

last and the current value(delta), and the third column is the absolute value.

In Tabular mode absolute values are printed as is without delta.

cellsrvstat -list command points out the statistics that are absolute values

[root@ec117 ~]# cellsrvstat -list

Statistic Groups:

io Input/Output related stats

mem Memory related stats

exec Execution related stats

net Network related stats

smartio SmartIO related stats

flashcache FlashCache related stats

ramcache RamCache related stats

health Cellsrv health/events related stats

offload Offload server related stats

database Database related stats

ffi FFI related stats

lio LinuxBlockIO related stats

mpp Reverse Offload related stats

Sparse Sparse stats

Statistics:

[ * - Absolute values. Indicates no delta computation in tabular format]

io_nbiorr_hdd Number of hard disk block IO read requests

io_nbiowr_hdd Number of hard disk block IO write requests

io_nbiorb_hdd Hard disk block IO reads (KB)

io_nbiowb_hdd Hard disk block IO writes (KB)

io_nbiorr_flash Number of flash disk block IO read requests

io_nbiowr_flash Number of flash disk block IO write requests

io_nbiorb_flash Flash disk block IO reads (KB)

io_nbiowb_flash Flash disk block IO writes (KB)

io_ndioerr Number of disk IO errors

io_ltow Number of latency threshold warnings during job

io_ltcw Number of latency threshold warnings by checker

io_ltsiow Number of latency threshold warnings for smart IO

io_ltrlw Number of latency threshold warnings for redolog writes

io_bcrti Current read block IO to be issued (KB) *

io_btrti Total read block IO to be issued (KB)

io_bcwti Current write block IO to be issued (KB) *

io_btwti Total write block IO to be issued (KB)

io_bcrii Current read blocks in IO (KB) *

io_btrii Total read block IO issued (KB)

io_bcwii Current write blocks in IO (KB) *

io_btwii Total write block IO issued (KB)

io_bcrsi Current read block IO in network send (KB) *

io_btrsi Total read block IO in network send (KB)

io_bcwsi Current write block IO in network send (KB) *

io_btwsi Total write block IO in network send (KB)

io_bcfp Current block IO being populated in flash (KB) *

io_btfp Total block IO KB populated in flash (KB)

io_qioc_hdd I/Os queued in IORM for hard disks

io_qioc_flash I/Os queued in IORM for flash disks

io_util I/O utilization per disk *

nlw_io_util Non large write I/O utilization per disk *

mem_sgahu SGA heap used - kgh statistics (KB)

mem_sgahf SGA heap free - cellsrv statistics (KB)

mem_sgaos OS memory allocated to SGA (KB)

mem_sgahuc SGA heap used - cellsrv statistics - KB

mem_pgaos OS memory allocated to PGA (KB)

mem_pgahuc PGA heap used - cellsrv statistics (KB)

mem_allos OS memory allocated to cellsrv (KB)

mem_oflos OS memory allocated to offload groups (KB)

mem_oclos OS memory allocated to OCL (KB)

mem_totalos Total OS memory allocated (KB)

mem_sgatop Top 5 SGA consumers (KB) *

mem_sgasubtop Top 5 SGA subheap consumers (KB) *

mem_halfkaf Number of allocation failures in 512 bytes pool

mem_2kaf Number of allocation failures in 2KB pool

mem_4kaf Number of allocation failures in 4KB pool

mem_8kaf Number of allocation failures in 8KB pool

mem_16kaf Number of allocation failures in 16KB pool

mem_32kaf Number of allocation failures in 32KB pool

mem_64kaf Number of allocation failures in 64KB pool

mem_1maf Number of allocation failures in 1MB pool

mem_halfkhwm Allocation hwm in 512 bytes pool

mem_2khwm Allocation hwm in 2KB pool

mem_4khwm Allocation hwm in 4KB pool

mem_8khwm Allocation hwm in 8KB pool

mem_16khwm Allocation hwm in 16KB pool

mem_32khwm Allocation hwm in 32KB pool

mem_64khwm Allocation hwm in 64KB pool

mem_1mhwm Allocation hwm in 1MB pool

mem_lmtf Number of low memory threshold failures

mem_nmtf Number of no memory threshold failures

mem_dynar Dynamic buffer allocation requests

mem_dynaf Dynamic buffer allocation failures

mem_dynafl Dynamic buffer allocation failures due to low mem

mem_dynam Dynamic buffer allocated size (KB)

mem_dynamh Dynamic buffer allocation hwm (KB)

exec_incno Incarnation number *

exec_versf Number of module version failures *

exec_ntwork Number of threads working *

exec_ntnetwait Number of threads waiting for network *

exec_ntreswait Number of threads waiting for resource *

exec_ntmutexwait Number of threads waiting for a mutex *

exec_njx Number of Jobs executed for each job type

exec_topcpusqlid SQL ids consuming the most CPU

exec_topbufferjob Job types consuming most buffers *

exec_numpfrun Current number of running predicate filter jobs

exec_numimcrun Current number of running IMC population jobs

exec_numpfqueued Current number of queued predicate filter jobs

exec_numimcqueued Current number of queued IMC population jobs

exec_pfrunhwm High water mark of running predicate filter jobs

exec_imcrunhwm High water mark of running IMC population jobs

exec_totalrunhwm High water mark of total running jobs

exec_pfqueuedhwm High water mark of queued predicate filter jobs

exec_imcqueuedhwm High water mark of queued IMC population jobs

exec_pfloadavg Average number of running predicate filter jobs

exec_imcloadavg Average number of running IMC population jobs

exec_cputmlatratio Consumed CPU time ratio in the latest scheduling bucket *

exec_cputmwavgratio Consumed CPU time weighted average ratio *

net_rxb Total bytes received from the network

net_txb Total bytes transmitted to the network

net_rtxb Total bytes retransmitted to the network

net_sps Number of active sendports

net_sph Hwm of active sendports

net_rois Number of active remote open infos

net_roih HWM of remote open infos

net_rejc Number of rejected connection requests

net_ltc Number of times low threshold was exceeded

net_ltts Timestamp when low threshold was last exceeded *

net_lttd Avg. elapsed seconds when low threshold was exceeded *

net_ltcc Avg. # of closed conn. when low threshold was exceeded *

net_ltmi Min idle time (secs) of closed conn. for low threshold *

net_ltai Avg idle time (secs) of closed conn. for low threshold *

net_ltcd # of closed conn. when low threshold was exceeded *

net_htc Number of times high threshold was exceeded

net_htts Timestamp when high threshold was last exceeded *

net_httd Avg. elapsed seconds when high threshold was exceeded *

net_htcc Avg. # of closed conn. when high threshold was exceeded *

net_htmi Min idle time (secs) of closed conn. for high threshold *

net_htai Avg idle time (secs) of closed conn. for high threshold *

net_htcd # of closed conn. when high threshold was exceeded *

sio_ns Number of active smart IO sessions *

sio_hs High water mark of smart IO sessions *

sio_ncs Number of completed smart IO sessions

sio_oe Smart IO offload efficiency (percentage) *

sio_sis Size of IO avoided due to storage index (KB)

sip_fcf Number of SI population invalidated due to cache usage

sip_fcl Number of SI population invalidated due to rgn limit

sip_fcc Number of SI population jobs completed

sio_evfh SI failed eviction all groups hot

sio_efph SI failed eviction all pages hot

sio_efono SI failed eviction can't open offload group

sio_efrptm SI failed eviction too many pages to relocate to

sio_efrf SI failed eviction can't relocate all RIDXs

sio_ctb Current smart IO to be issued (KB) *

sio_ttb Total smart IO to be issued (KB)

sio_cii Current smart IO in IO (KB) *

sio_tii Total smart IO in IO (KB)

sio_cfp Current smart IO being cached in flash (KB) *

sio_tfp Total smart IO being cached in flash (KB)

sio_cic Current smart IO with IO completed (KB) *

sio_tic Total smart IO with IO completed (KB)

sio_cfc Current smart IO filtering completed (KB) *

sio_tfc Total smart IO filtering completed (KB)

sio_cfo Current smart IO filtered size (KB) *

sio_tfo Total smart IO filtered size (KB)

sio_tcpo Total cpu passthru output IO size (KB)

sio_tpo Total passthru output IO size (KB)

sio_cis Current smart IO in send (KB) *

sio_tis Total smart IO in send (KB)

sio_ciso Current smart IO filtered in send (KB) *

sio_tiso Total smart IO filtered in send (KB)

sio_fcr Total smart IO read from flash (KB)

sio_fcw Total smart IO initiated flash population (KB)

sio_hdr Total smart IO read from hard disk (KB)

sio_hdw Total smart IO writes (fcre) to hard disk (KB)

sio_n512kb Number of smart IO requests < 512KB

sio_n1mb Number of smart IO requests >= 512KB and < 1MB

sio_n2mb Number of smart IO requests >= 1MB and < 2MB

sio_n4mb Number of smart IO requests >= 2MB and < 4MB

sio_n8mb Number of smart IO requests >= 4MB and < 8MB

sio_ngt8mb Number of smart IO requests >= 8MB

sio_nbrf Number of times smart IO buffer reserve failures

sio_nrm Number of times smart IO request misses

sio_ncio Number of times IO for smartIO not allowed to be issued

sio_nplr Number of times smart IO prefetch limit was reached

sio_nssuo Number of times smart scan used unoptimized mode

sio_nfcuo Number of times smart fcre used unoptimized mode

sio_nsbuo Number of times smart backup used unoptimized mode

sio_cc1rsc Number of successful queued CC1 rewrites

sio_cc2qrsc Number of successful queued CC2 query rewrites

sio_cc2crsc Number of successful queued CC2 capacity rewrites

sio_cc1rscb Number of successful queued CC1 rewrite bytes

sio_cc2qrscb Number of successful queued CC2 query rewrite bytes

sio_cc2crscb Number of successful queued CC2 capacity rewrite bytes

sio_cc2brp Number of CC2 background requests processed

ocl_rh_iosnonccrec CC IOs Non-Eligible - OCL RH Monitoring

ocl_rh_iosnonccrecptCC IOS Non-Eligible - OCL RH Pop Fail Tracking

ocl_rh_nrmm HWM of Write-Heavy CC regions monitored

ocl_rh_nrmc Write-Heavy CC Regions Monitored

ocl_rh_nrmt Total Write-Heavy CC Regions Monitored

ocl_rh_nrrau Total Write-Heavy CC Regions Unmonitored (Read Active)

ocl_rh_nromu Total Write-Heavy CC Regions Unmonitored (Owner change)

ocl_rh_nrmpft HWM of CC regions Tracked (Population Failure)

ocl_rh_nrcpft CC Regions Tracked (Population Failure)

ocl_rh_nrtpft Total CC Regions Tracked (Population Failure)

ocl_rh_nrpfut Total CC Regions Untracked (Population Failure)

ncceio Total CC IOs

ncceios_nehcc Total CC IOs - Non-EHCC

ncceios Total CC Eligible IOs

nccneios Total CC Non-Eligible IOs

nccneios_ccd CC IOs Non-Eligible - CC Disabled

nccneios_rbfplib CC IOs Non-Eligible - Rejected by Fplib

fc_nreadh Number of read hits

fc_sreadh Read on flashcache hit(KB)

fc_nreadhk Number of keep read hits

fc_sreadhk Read on flashcache keep hit(KB)

fc_nreadm Number of read misses

fc_sreadm Total IO size for read miss(KB)

fc_nreadmk Number of keep read misses

fc_sreadm Total IO size for keep read miss(KB)

fc_nreadnoc Number of no cache reads

fc_sreadnoc Total size for nocache read(KB)

fc_nreadnock Number of keep no cache reads

fc_npreads Number of partial reads

fc_spreads Total size for partial reads(KB)

fc_nopreads Number of optimized partial reads

fc_npreadsk Number of keep partial reads

fc_nccr Number of NC cache reads

fc_nccrsz Total size of NC cache reads (KB)

fc_ncdr Number of NC read cache misses

fc_ncdrsz Total size of NC cache misses (KB)

fc_ncopr Number of NC optimized preads

fc_ncoprsz Total size of NC optimized preads (KB)

fc_ncpr Number of NC partial reads

fc_ncprsz Total size of NC partial reads (KB)

fc_reloccr Number of RELOC cache reads

fc_reloccrsz Total size of RELOC cache reads (KB)

fc_relocdr Number of RELOC read cache misses

fc_relocdrsz Total size of RELOC cache misses (KB)

fc_relocopr Number of RELOC optimized preads

fc_relocoprsz Total size of RELOC optimized preads (KB)

fc_relocpr Number of RELOC partial reads

fc_relocprsz Total size of RELOC partial reads (KB)

fc_ncwrites Number of cache writes

fc_scwrites Total size for cache writes(KB)

fc_ncwritesp Number of partial cache writes

fc_nredirty Number of redirty

fc_ncwritesk Number of keep cache writes

fc_scwritesk Total size for keep cache writes(KB)

fc_ncwritespk Number of partial keep cache writes

fc_nredirtyk Number of keep redirty

fc_nnocwrites Number of nocache writes

fc_snocwrites Total size for nocache writes(KB)

fc_nnocwritesp Number of partial nocache writes

fc_nnocwritesk Number of keep nocache writes

fc_npopulate Number of populates

fc_spopulate Total size for populate writes(KB)

fc_ntrim Number of trims

fc_physu Flash Physical Usage

fc_ndkwrwrites Number of disk writer writes

fc_sdkwrwrites Total size for disk writer writes(KB)

fc_ncdkwrwrites Number of disk writer coalesced writes

fc_scdkwrwrites Total size for disk writer coalesced writes(KB)

fc_dkwr_creads Number of disk writer chunk reads

fc_dkwr_creads_kb Total size for disk writer chunk reads(KB)

fc_dkwr_cwrites Number of disk writer chunk writes

fc_dkwr_cwrites_kb Total size for disk writer chunk writes(KB)

fc_lr_rej_iormlim Num lr rejections due to IORM limits

fc_lr_rej_iormthr Num lr rejections due to IORM threshold

fc_largeread_rej_kb Total size for rejected large read IOs(KB)

fc_scan_bytes_read Number of scan bytes attempted to read from cache(KB)

fc_scan_hitsize Number of SCAN bytes read from cache(KB)

fc_scan_parthit_cnt Number of partial cache hits for SCAN IO

fc_scan_nochdrs_cnt Number of no cache hit and no victim hdrs for SCAN IO

fc_scan_aux_failcnt Number of failed victim searches for SCAN IO

fc_scan_ret_clcnt Number of cache lines returned due to partial SCAN IO

fc_scan_evict_clcnt Number of cache lines evicted due to partial SCAN IO

fc_scan_smpthy_ccnt Number of cache lines initialized by sympathy caching

fc_scan_dwrepl_cnt Number of DW replacements during SCAN IO

fc_scan_oltprp_cnt Number of OLTP replacements during SCAN IO

fc_scan_selfrp_cnt Number of SELF replacements during SCAN IO

fc_scan_zhitrp_cnt Number of zero hit replacements during SCAN IO

fc_scan_frhdrrp_cnt Number of free cache line replacements during SCAN IO

fc_scan_tccool_cnt Number of times touch count cooling occurred

fc_pops_ttld_out Number of IOs failed to populate FC due to throttling

fc_cachedsize Cachesize(KB)

fc_keepsize Keepsize(KB)

fc_oltpsize OLTPsize(KB)

fc_nvchdrs Number of cache headers with valid data

fc_lrugets Number of attempts to get a cacheline from lru

fc_lrugetsf Number of failed attempts to get a cacheline from lru

fc_nfioerr Number of flash cache IO errors

fc_nbpfce Size of eviction from flash cache (KB)

fc_nolfio Number of outstanding large flash IOs

fc_nncan Number of writes resubmitted with nocancel

fc_lwr Number of writes logged by flashcache

fc_lrd Number of reads done by flashcache logger

fc_lnp Number of writes forced to be nonpoisoned by logger

fc_col_used Columnar Cache used size (KB)

fc_col_keep Columnar Cache keep Size (KB)

fc_col_scans Number of reads attempted in Columnar Cache

fc_col_scan_r_bytes Number of bytes eligible to be read from Col Cache(KB)

fc_col_nreadhk Number of keep read hits from columnar cache

fc_col_sreadhk Number of bytes of keep read hits from Col cache(KB)

fc_col_scanhits Number of scans read from Columnar Cache

fc_col_scanhitsize Number of SCAN bytes read from Columnar Cache

fc_col_bytes_saved Number of bytes saved by hits from Columnar Cache(KB)

fc_col_wio Total number of IOs initiated Columnar Cache population

fc_col_wio_size Total IO initiated Columnar Cache population (KB)

fc_col_size_align Number of CC non-eligible size alignment

fc_col_fail_mhdr Number of CC failures to find main cache header

fc_col_fail_chdr Number of CC failures to find child cache headers

fc_col_iormthrottle Number of CC populations throttled by IORM

fc_col_fcthrottle Number of CC populations throttled by FC

fc_col_skipdup Number of CC duplicate populations skipped

fc_col_skiplock Number of CC populations lock escalation failures

fc_col_evict Number of CC eviction

fc_col_evict_size Number of bytes evicted from CC (KB)

fc_col_cc1r Number of CC1 rewrites

fc_col_cc2rq Number of CC2 rewrites - query

fc_col_cc2rc Number of CC2 rewrites - capacity

fc_col_cc1rb Number of CC1 rewrite bytes

fc_col_cc2rbq Number of CC2 rewrite bytes - query

fc_col_cc2rbc Number of CC2 rewrite bytes - capacity

fc_col_cc2r_nehcc Number of CC2 Rewrites - Non-EHCC

fc_col_cc2rbc_nehcc Number of CC2 Rewrite bytes - Non-EHCC

ctd_cq_hwm HWM of CTD CommandQ *

ctd_cq_num_outs_cmdsOutstanding commands currently in CTD CommandQ *

ctd_cq_lck_cont_cnt Lock Contention cnt for CTD CommandQ *

ctd_cq_avg_sz Avg size of CTD CommandQ *

ctd_any_cgs_thrsh Any CGs currently thrashing *

ctd_glbl_thrsh CTD currently detects global thrashing *

ctd_cgs_thrsh_cnt CTD running thrashing count for all CGs *

ctd_glbl_thrsh_cnt CTD global running thrashing count *

fw_any_too_high FW Any Flash Cache Store wear too high *

fc_lw_nlwa num LW eligible to be absorbed *

fc_lw_nlrboi num lw rejected based on IORM *

fc_lw_nlrboml num lw rejected based on max limit *

fc_lw_nldsj num lw data sync jobs *

fc_lw_nldsjddti num lw data sync jobs deferred due to iorm *

fc_lw_nlrdtt num lw replenished due to thrashing *

fc_lw_nlrdtcs num lw replenished due to cl shortage *

fc_lw_nlrbolt num lw rejected based on lw thrashing *

fc_lw_nlwrboclt num lw rejected based on cg lw thrashing *

fc_lw_nnc num NRW cached *

fc_lw_nmc num MRW cached *

fc_lw_nrc num ROW cached *

fc_lw_nlirbc num LW IOs rejected total *

fc_lw_nrali num rejected ASM LW IOs *

fc_lw_nlrbogml num lw rejected based on global max limit *

fc_lw_nlrbofb num lw rejected based on flash busy *

fc_lw_nnidssl num nrw in data sync scan list *

fc_lw_nmidssl num mrw in data sync scan list *

fc_lw_nridssl num row in data sync scan list *

fc_lw_ndss num data sync scans *

fc_lw_nlf num lw flushed by data sync *

fc_lw_nlrboknc num lw rejected based on keep needing cls *

fc_lw_nlrbofw num lw rejected based on flash wear *

fc_lw_nlrboil num lw rejected based on IORM limits *

fc_lw_1 num never read cachelines absorbed *

fc_lw_2 num temp cachelines absorbed *

fc_lw_3 num maybe read cachelines absorbed *

fc_lw_4 num never read cachelines rejected *

fc_lw_5 num temp cachelines rejected *

fc_lw_6 num mabye read cachelines rejected *

fc_lw_7 num temp reads disk *

fc_lw_8 size temp reads disk *

fc_lw_9 num temp reads flash *

fc_lw_10 size temp reads flash *

fc_lw_11 num mrw reads disk *

fc_lw_12 size mrw reads disk *

fc_lw_13 num mrw reads flash *

fc_lw_14 size mrw reads flash *

fc_lw_15 num NRW currently cached in flash *

fc_lw_16 num MRW currently cached in flash *

fc_lw_17 num ROW currently cached in flash *

fc_lw_18 num LW rejected because flash compression is enabled *

fc_lw_19 num times lower HD busy thrshld used bcuz flash is idle *

rc_nreadh RamCache pop read hits

rc_sreadh RamCache pop read hits (KB)

rc_nreadm RamCache pop read misses

rc_sreadm RamCache pop read misses (KB)

rc_npreads RamCache partial reads

rc_spreads RamCache partial reads (KB)

rc_nccr RamCache NC read hits

rc_nccrsz RamCache NC read hits (KB)

rc_ncdr RamCache NC read misses

rc_ncdrsz RamCache NC read misses (KB)

rc_reloccr RamCache read hits

rc_reloccrsz RamCache read hits (KB)

rc_relocdr RamCache read misses

rc_relocdrsz RamCache read misses (KB)

rc_npopioctl RamCache pop ioctls

rc_npoprej RamCache pop reqs rej

rc_npopjob RamCache pop jobs

rc_npopreq RamCache pop requests

rc_npoppend RamCache pop pending

rc_npopskip RamCache pop skipped

rc_npopdone RamCache pop done

rc_npopdma RamCache pop dma

rc_npopinv RamCache pop invalid

rc_npopfailx RamCache pop failed esc

rc_npopfailr RamCache pop failed read

rc_npopfailrb RamCache pop failed readbelow

rc_npopfailre RamCache pop failed readerr

rc_npopfailpe RamCache pop failed poperr

rc_npopulate RamCache pop writes

rc_spopulate RamCache pop writes (KB)

rc_scan_bytes_read RamCache scan attempted (KB)

rc_scan_hitsize RamCache scan hits (KB)

rc_scan_parthit_cnt RamCache scan partial hits

rc_cachedsize RamCache size (KB)

rc_oltpsize RamCache OLTP size (KB)

rc_nvchdrs RamCache valid cache headers

rc_lrugets RamCache lru search attempts

rc_lrugetsf RamCache lru search failed attempts

health_errc Total number of events recorded in the Event Registry

health_errcbytype Num Events recorded in the Event Registry by type

health_toperr Top Events recorded in the Event Registry.

ofl_comp Offload group composite metric

This composite-type metric contains the following statistics:

ofl_srv_name, ofl_ti, ofl_to, ofl_po, ofl_cpo, ofl_sgaos, ofl_sgahu, ofl_top_sga, ofl_pgaos, ofl_pgahu, eofl_jvmos, ofl_jvmhu, ofl_groupos, ofl_grouppu, ofl_totalos, ofl_ridxevicted, ofl_pabse, ofl_pag, ofl_parg, ofl_pageevict, ofl_per, ofl_tea, ofl_se, ofl_nmiouora, ofl_nmsp, ofl_nmctfom, ofl_nmctfilm, ofl_nmctfilq, ofl_nmctfiuc, ofl_nmctfiommns, ofl_nmctfiommis, ofl_nmctfiomisc, ofl_nmctfiotur, ofl_nmctfiotir, ofl_nminncc, ofl_nmince, ofl_nminuw, ofl_nminur, ofl_nminom, ofl_nminnfr, ofl_nminiltitw, ofl_cc1hits, ofl_cc2qhits, ofl_cc2qhits_nehcc, ofl_cc2chits, ofl_cc2chits_nehcc, ofl_ecc1hits, ofl_ecc2qhits, ofl_ecc2qhits_nehcc, ofl_ecc2chits, ofl_ecc2chits_nehcc, ofl_clscc1, ofl_clscc2, ofl_ccpf_fpgs, ofl_ccpf_gcl

ofl_srv_name Offload server name *

ofl_ti Total input IO size (KB)

ofl_to Total output size (KB)

ofl_po Passthru output size (KB)

ofl_cpo CPU passthru output size (KB)

ofl_sgaos OS memory allocated to SGA (KB)

ofl_sgahu SGA heap used - OAL statistics (KB)

ofl_top_sga Offload server top SGA consumers (KB) *

ofl_pgaos OS memory allocated to PGA (KB)

ofl_pgahu PGA heap used - OAL statistics (KB)

eofl_jvmos OS memory allocated to JVM (KB)

ofl_jvmhu JVM used memory (KB)

ofl_groupos OS memory allocated to group pool (KB)

ofl_grouppu Group pool used (KB)

ofl_totalos Total OS memory (KB)

ofl_ridxevicted SI # RIDXs Evicted

ofl_pabse SI #pages added by background eviction

ofl_pag SI #pages added foreground evict to global free list

ofl_parg SI #pages added foreground evict to requesting group

ofl_pageevict SI #pages evicted without relocation

ofl_per SI #pages evicted with relocation

ofl_tea SI total number of eviction attempts

ofl_se SI # successful evictions

ofl_nmiouora SI # IOs update on read attempts

ofl_nmsp SI # successful population

ofl_nmctfom SI #IOs can't use SI due to objd mismatch

ofl_nmctfilm SI #IOs can't use SI due to lo mscn

ofl_nmctfilq SI #IOs can't use SI due to lo qscn

ofl_nmctfiuc SI #IOs can't use SI due to unclus col

ofl_nmctfiommns SI #IOs can't use SI due to siminmax no seed

ofl_nmctfiommis SI #IOs can't use SI due to siminmax inef seed

ofl_nmctfiomisc SI #IOs can't use SI due to misc

ofl_nmctfiotur SI #IOs can't use SI due to io 2 uninit rgn

ofl_nmctfiotir SI #IOs can't use SI due to io 2 invalid rgn

ofl_nminncc SI #idx not built no cluster col

ofl_nmince SI #idx not built compute err

ofl_nminuw SI #idx not built unaligned write

ofl_nminur SI #idx not built unaligned read

ofl_nminom SI #idx not built obj mismatch

ofl_nminnfr SI #idx not built no free ridx

ofl_nminiltitw SI #idx not built io less than io thres write

ofl_cc1hits Number of CC1 hits

ofl_cc2qhits Number of CC2 query hits

ofl_cc2qhits_nehcc Number of CC2 query hits - Non EHCC

ofl_cc2chits Number of CC2 capacity hits

ofl_cc2chits_nehcc Number of CC2 capacity hits - Non EHCC

ofl_ecc1hits Number of encrypted CC1 hits

ofl_ecc2qhits Number of encrypted CC2 query hits

ofl_ecc2qhits_nehcc Number of encrypted CC2 query hits - Non EHCC

ofl_ecc2chits Number of encrypted CC2 capacity hits

ofl_ecc2chits_nehcc Number of encrypted CC2 capacity hits - Non EHCC

ofl_clscc1 CC1 Col Layout Success

ofl_clscc2 CC2 Col Layout Success

ofl_ccpf_fpgs CC Pop Fail (fpgetsize)

ofl_ccpf_gcl CC Pop Fail (getcollayout)

db_comp Database group composite metric

This composite-type metric contains the following statistics:

db_name, db_oflgrp_open, db_oflgrp_open_fail, db_oflgrp_msg, db_oflgrp_msg_fail, db_cellsrv_sioi, db_cellsrv_sioo, db_cellsrv_po, db_celloflsrv_sioi, db_celloflsrv_sioo, db_celloflsrv_po, db_cpupo, db_sisb, db_nnou

db_name Database name *

db_oflgrp_open Total offload group opens

db_oflgrp_open_fail Total offload group open failures

db_oflgrp_msg Total offload group messages

db_oflgrp_msg_fail Total offload group message failures

db_cellsrv_sioi Total smart IO input to cellsrv (KB)

db_cellsrv_sioo Total smart IO output from cellsrv (KB)

db_cellsrv_po Total passthru output from cellsrv (KB)

db_celloflsrv_sioi Total smart IO input to celloflsrv (KB)

db_celloflsrv_sioo Total smart IO output from celloflsrv (KB)

db_celloflsrv_po Total passthru output from celloflsrv (KB)

db_cpupo Total CPU passthru output IO size (KB)

db_sisb Total storage index saved bytes (KB)

db_nnou Total number of non-optimized usages

ffi_rsr number of reads straddling consecutive FFI regions

ffi_wsr number of writes straddling consecutive FFI regions

ffi_wnep number of writes blocking other writes in 4MB region

ffi_fwjb number of FFIWriteJob waited for pin

ffi_frjb number of FFIRemoveJob waited for pin

ffi_ffjb number of FFIFlushJob waited for pin

ffi_fjb number of FFIJob waited for pin

ffi_nfr number of regions initialized by FFI

ffi_nfrf number of regions FFI inited, later flushed to disk

ffi_nff number of failures to FFI, griddisk cacheline not found

lio_ncio number of IOs cancelled due to disk failure

lio_ncioht num IOs cancelled due to possible disk failure

lio_ncwht num writes redirected due to possible disk failure

lio_nciods num IOs cancelled before reaching OS

lio_niers num IOs exceeding retry threshold

lio_mir IO retries high water mark

lio_ncios num cancellable IOs submitted

lio_nucios num non cancellable IOs submitted

mpp_nrn Number of Remote Nodes (I)

mpp_nri Number of Remote Instances (I)

mpp_ccpu_util Current Cell CPU utilization (I)

mpp_nreq Number of requests (C)

mpp_nreq_pbk Number of requests that were pushed (C)

mpp_apr_supdate Average pushback rate for since last stat update (I)

mpp_apr Average pushback rate for last 200 ms (I)

mpp_nr_blcc Num of reqs not pushed due to low cell cpu (C)

mpp_nr_bhcon Num of reqs not pushed due to high cell outnet (C)

mpp_nr_bhrnin Num of reqs not pushed due to high db node innet (C)

mpp_nincr_mb Num rate increase by reverse offload info from db (C)

mpp_ndecr_mb Num rate decrease by reverse offload info from db (C)

mpp_nincr_rn Num rate increases from db node cpu information (C)

mpp_ndecr_rn Num rate decreases from db node cpu information (C)

mpp_ndecr_ccpu Num rate decreases from low cell cpu utilization (C)

mpp_ndecr_con Num rate decreases from high cell outnet util (C)

mpp_ndecr_rn_in Num rate decreases from high db node innet util (C)

sparse_ncb num buckets compacted by sparse HT background scan

sparse_ios num IOs with sparse regions

sparse_ios_kb Total sparse IOs (KB)

sparse_smartio Total redirected smart ios (KB)

Statistics for IO

[root@ec117 ~]# cellsrvstat -stat_group io

===Current Time=== Thu Apr 18 01:21:54 2024

== Input/Output related stats ==

Number of hard disk block IO read requests 0 0

Number of hard disk block IO write requests 0 0

Hard disk block IO reads (KB) 0 0

Hard disk block IO writes (KB) 0 0

Number of flash disk block IO read requests 0 6

Number of flash disk block IO write requests 0 0

Flash disk block IO reads (KB) 0 3

Flash disk block IO writes (KB) 0 0

Number of disk IO errors 0 0

Number of latency threshold warnings during job 0 0

Number of latency threshold warnings by checker 0 0

Number of latency threshold warnings for smart IO 0 0

Number of latency threshold warnings for redolog writes 0 0

Current read block IO to be issued (KB) 0 0

Total read block IO to be issued (KB) 0 0

Current write block IO to be issued (KB) 0 0

Total write block IO to be issued (KB) 0 0

Current read blocks in IO (KB) 0 0

Total read block IO issued (KB) 0 0

Current write blocks in IO (KB) 0 0

Total write block IO issued (KB) 0 0

Current read block IO in network send (KB) 0 0

Total read block IO in network send (KB) 0 0

Current write block IO in network send (KB) 0 0

Total write block IO in network send (KB) 0 0

Current block IO being populated in flash (KB) 0 0

Total block IO KB populated in flash (KB) 0 0

I/Os queued in IORM for hard disks 0 0

I/Os queued in IORM for flash disks 0 0

I/O utilization per disk

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH03 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH06 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH04 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH05 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH01 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH02 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_06 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_05 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_01 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_08 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_11 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_09 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_12 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_07 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_03 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_02 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_10 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/ec_04 0 0.00

END I/O utilization per disk

Non large write I/O utilization per disk

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH03 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH06 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH04 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH05 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH01 0 0.00

/opt/oracle/cell18.1.0.0.0_LINUX.X64_170915.1/disks/raw/exacell2_FLASH02 0 0.00

END Non large write I/O utilization per disk

Get Statistics Output From Each Cell At A Time

[root@ec117 ~]# cellsrvstat -interval=5 -count=1

===Current Time=== Thu Apr 18 01:24:21 2024