Perfmon variable
|
Description
|
---|---|
Time (sec)
|
In onetime report: length of the measurement time interval, in seconds. The latest interval is on the right side of the table.
|
TimeMs
|
In a differential report: measurement time interval, in milliseconds. The oldest interval is in the first row of the table.
|
File open
|
File open calls/sec
|
File read
|
File read calls/sec
|
File write
|
File write calls/sec
|
File append
|
File append calls/sec
|
File flush
|
File flush calls/sec
|
File lock
|
File lock calls/sec
|
Cache find
|
Cache fetches/sec
|
Cache read
|
Cache misses/sec
|
Cache write
|
Cache page flushes/sec
|
Cache prefetch
|
Cache prefetched pages/sec
|
Cache prefetch wait
|
Cache waits for prefetched pages/sec
|
Cache preflush
|
Preflushing cache pages/sec
|
Cache LRU write
|
A write from cache is done when performing an LRU replacement. This indicates that the client thread must write one block to disk before reading a new block from the disk because there has not been a free disk block available. A very high value can indicate high I/O load, or it can indicate that I/O preflusher values are not optimal.
|
Cache slot wait
|
This counter indicates that there is concurrent access to the same block and one thread must wait for the other. Depending on the cache configuration, it can also indicate that the mutex count for the cache is not optimal and there are false conflicts. The default mutex count does not cause false conflicts here.
|
Cache slot replace
|
Database cache slot is replaced and old slot is removed.
|
Cache write storage leaf
|
Database cache has written a storage tree leaf page to disk.
|
Cache write storage index
|
Database cache has written a storage tree index page to disk.
|
Cache write bonsai leaf
|
Database cache has written a Bonsai-tree leaf page to disk.
|
Cache write bonsai index
|
Database cache has written a Bonsai-tree index page to disk.
|
Cache preflush bytes
|
Number of bytes written by preflusher before log file is flushed. The counter is reset at each flush.
|
Cache preflush flush
|
Number of preflush calls/sec before log file is flushed.
|
RPC messages
|
Total number of sent messages/sec
|
RPC read
|
Total number of read messages/s
|
RPC write
|
Total number of write messages/sec
|
RPC uncompressed
|
When RPC compression enabled, number of bytes/sec
|
RPC compressed
|
When RPC compression enabled, number of compressed byte/s
|
RPC connected
|
Number of client connect requests
|
RPC disconnected
|
Number of client disconnect requests
|
Com sel empty
|
TCP socket select nil returns/sec
|
Com sel found
|
TCP socket select successes/sec
|
SQL prepare
|
SQL prepare statements/sec
|
SQL execute
|
SQL execute statements/sec
|
SQL fetch
|
SQL fetch statements/sec
|
SQL direct execute
|
SQL execute statements/sec using direct statement execute
|
SQL execute simple
|
Number of simple SQL statement executes
A simple SQL statement is a statement that accesses a single table and does not contain joins, subqueries, function calls, ORDER BY or GROUP BY constructions, and all WHERE conditions are combined with an AND logical operator.
|
SQL execute complex
|
Number of complex SQL executes
|
SQL direct fetch
|
SQL fetch statements/sec using direct statement execute
|
DBE insert
|
Table engine row inserts/sec
|
DBE delete
|
Table engine row deletes /sec
|
DBE update
|
Table engine row updates /sec
|
DBE fetch
|
Table engine row fetches /sec
|
DBE fetch M-table
|
Number of rows fetched from in-memory tables
|
DBE fetch D-table
|
Number of rows fetched from disk-based tables
|
DBE dd operation
|
Server has executed SQL data dictionary operation.
|
Parallel fetch
|
Number of rows fetched using parallel operations
|
Parallel fetch wait
|
Number of waits for user connections when using parallel operations
|
Parallel threads active
|
Number of threads used for parallel operations
|
Proc compile
|
Number of procedure compilations
|
Proc exec
|
Procedure executions/sec
|
Proc SQL prepare
|
Number of SQL prepare calls from a procedure code
|
Proc SQL execute
|
Number of SQL execute calls from a procedure code
|
Proc SQL fetch
|
Number of SQL fetch calls from a procedure code
|
Trig compile
|
Number of trigger compilations
|
Trig exec
|
Trigger executions/sec
|
Trig SQL prepare
|
Number of SQL prepare calls from a trigger code
|
Trig SQL execute
|
Number of SQL execute calls from a trigger code
|
Trig SQL fetch
|
Number of SQL fetch calls from a trigger code
|
SA fetch
|
SA-level row fetches/sec
|
SA insert
|
SA-level row inserts/sec
|
SA delete
|
SA-level row deletes/sec
|
SA update
|
SA-level row updates/sec
|
Trans commit
|
Committed transactions/sec
|
Trans abort
|
Aborted transactions/sec
|
Trans rollback
|
Rolled back transactions/sec
|
Trans readonly
|
Read-only transactions/sec
|
Trans buf
|
Current transaction buffer size
|
Trans buf cleanup
|
Cumulative number of cleanup operations since startup
|
Trans buf added
|
Cumulative number of transactions added since startup
|
Trans buf removed
|
Cumulative number of transactions removed since startup
|
Trans validate
|
Current number of active commit-time validations
|
Trans active
|
Current number of active transactions
|
Trans read level
|
This counter indicates the current transaction read level. This counter value increases all the time. Because the counter value is 32-bit variable, it can have a negative value, but still logically the value is increasing. If the value stays the same for a long time with concurrent write transactions, it indicates that a long transaction is blocking the read level and can cause merge blocking and an increase in the Bonsai tree size.
|
Ind write
|
Index writes/sec
|
Ind nomrg write
|
number of nonmerged rows (committed and uncommitted)
|
Search active
|
Table engine-level active searches.
|
Search replan
|
Number of search replans
A search is replanned when table content is significantly changed. Replan is done to make sure that search plans are optimal for the changed table content.
|
Db size
|
Total database size on disk, in KB
|
Db free size
|
Free space in the database (page level), in KB
|
Mem size
|
Total size of dynamically allocated memory, in KB
|
Mem page alloc
|
Number of explicitly allocated pages
|
Mem page free
|
Number of free pages
|
Merge quickstep
|
Quick merge steps/sec
|
Merge step
|
Full merge steps/sec
|
Merge step (purge)
|
Node split-inflicted merge keys/sec (if enabled)
|
Merge step (user)
|
User thread-activated merge row/sec
|
Merge oper
|
Lower-level merge operations/sec
|
Merge cleanup
|
Transaction buffer cleanup calls/sec (if split purge enabled)
|
Merge active
|
Yes/no (1/0)
|
Merge nomrg write
|
Current number of index entries waiting for merge
|
Merge file write
|
Merge-inflicted file writes/sec
|
Merge file read
|
Merge-inflicted file reads/sec
|
Merge level
|
Current merge level (read level of the oldest active transaction)
|
Backup step
|
Database backup steps/sec (also in netbackup and netcopy)
|
Backup active
|
Yes/no (1/0)
|
Checkpoint active
|
Checkpoint status
Value 0 means checkpoint is not active. Values 1 and above means checkpoint is active; values above 1 indicate the progress of the checkpoint.
|
Checkpoint count
|
Checkpoint serial number from startup
|
Checkpoint file write
|
Checkpoint file writes/sec
|
Checkpoint file read
|
Checkpoint file reads/sec
|
Est read samples
|
Estimator sample refresh call/s
|
Sorter start sort
|
Number of external sorts started
|
Sorter add row
|
Number of rows added to external sorter
|
Sorter fetch row
|
Number of rows read from external sorter
|
Sorter open file
|
Number of files opened/sec in external sorter
|
Sorter activecnt
|
Number of currently active external sorts
|
Sorter waitcnt
|
Number of external sort requests waiting to be started.
|
Sorter wait
|
Number of external sort requests waits/sec.
|
Sorter filecnt
|
Number of temporary files currently used for external sorting.
|
Sorter memblockcnt
|
Number of memory blocks currently used for external sorting.
|
Sorter failed
|
Number of time external sort has failed to start.
|
Sync repl msg forw
|
Replica: forwarded messages/sec
|
Sync repl msg getr
|
Replica: received message replies/sec
|
Sync repl msg exec
|
Replica: executed messages/sec
|
Sync mast msg read
|
Master: message reads/sec
|
Sync mast msg exec
|
Master: message execs/sec
|
Sync mast msg write
|
Master: message writes/sec
|
Sync mast subs
|
Master: refreshes/sec
|
Log write
|
Log record writes/sec
|
Log file write
|
Log block writes/sec
|
Log file write bytes
|
Number of log block writes in bytes before log file is flushed
|
Log nocp write
|
Pending log records since last checkpoint
|
Log size
|
Total size of log file, in KB
|
Log flush (L)
|
Logical log flushes/sec (for example, commit)
|
Log flush (P)
|
Physical log flushes/sec
|
Log grpcommwkup
|
Group commit wakeups/sec
|
Log flush full
|
Log page full flushes/sec
|
Log wait flush
|
Current number of user threads waiting for log operation
|
Log writeq full rec
|
Log writes while log write queue full (in number of records)
|
Log writeq full byt (byte size)
|
Log writes while log write queue full (in bytes)
|
Log writeq records
|
Number of records in current log writer queue.
|
Log writeq bytes
|
Number of bytes in log writer queue.
|
Log writeq pending bytes
|
Number of bytes for the next log writer queue flush.
|
Log availq items
|
Number of records added to available items queue
|
Log writeq add
|
Number of records added to log writer queue.
|
Log writeq write
|
Number of records written from log writer queue to log file.
|
Log writeq items allocated count
|
Number of write queue items in the system
|
Log writeq bytes allocated count
|
Amount of memory in bytes allocated for write queue items in the system
|
Log writeq items freed
|
Internal use only.
|
Log writeq items blocking waits
|
Internal use only.
|
Log writeq items only distribute
|
Internal use only.
|
Log writeq remove abort stmt
|
Number of aborted statements removed from the log queue
|
Perfmon variable
|
Description
|
Log writeq remove abort trx
|
Number of aborted transactions removed from the log queue
|
Log grpcommits
|
Number of transactions in the most recent group commit
Transaction commits are grouped in one log burst which is written to the log file in a single write.
|
Log grpcommits (phase2)
|
Number of HotStandby phase 2 transactions in the most recent group commit.
Note You can use this counter only in HotStandby setups.
|
HSB operation count
|
Primary/Secondary: transferred log record/sec
|
HSB commit count
|
Primary: commit record/sec
|
HSB packet count
|
Primary: messages/sec
|
HSB flush count
|
Primary/Secondary: message flushes/sec
|
HSB cached bytes
|
Primary/Secondary: current size memory based log buffer, in bytes
|
HSB cached ops
|
Primary/Secondary: current size of the memory-based log buffer, in operations (log records)
|
HSB flusher bytes
|
Number of bytes of the HSB log in the send queue to the Secondary
|
HSB notsent bytes
|
Number of bytes in the HSB log that has been accumulated (for example, during a catchup) and not sent to the Secondary yet
|
HSB grouped acks
|
Secondary: current number of ack groups (physical acks)
|
HSB state
|
Name of the current HSB state
|
HSB wait cpmes
|
Yes/no (1/0) Primary: waiting for checkpoint ack from the Secondary
|
HSB secondary queues
|
Secondary: current number of queues pending processing
|
HSB log reqcount
|
HSB log write requests/sec
|
HSB log waitct
|
HSB log waits-for-write requests/sec
|
HSB log freespc
|
HSB: number of log operations there is space for in the protocol window
|
HSB last catchup recs
|
Size of HSB catchup in number of sent log records
The counter is reset when the catchup is started.
You can use this pmon to monitor the progress of the catchup. After catchup is complete, the value shows the size of the completed catchup.
|
HSB catchup reqcnt
|
HSB log write requests/sec, for catchup
|
HSB catchup waitcnt
|
HSB log waits-for-write requests/sec, for catchup
|
HSB catchup freespc
|
HSB: number of log operations there is space for in the protocol window, for catchup
|
HSB alone freespc
|
Primary: in Primary alone, bytes there is room for in the transaction log
|
HSB grpcommits
|
Number of transactions in the most recent group commit
Transaction commits are grouped in one log burst which is send to Secondary as one packet.
You can only use this counter on the Primary.
|
HSB phase1 wait
|
Internal use only.
|
HSB secondary ops in packet
|
Number of log records the Secondary received from the Primary in the most recent log record packet.
|
HSB secondary trx count
|
Number of open transactions the Secondary has received from the Primary
|
HSB secondary locks
|
Number of row-level locks on the Secondary
|
HSB secondary lock reqs
|
Number of lock requests on the Secondary
|
HSB secondary lock waits
|
Number of lock waits on the Secondary since the server was started
|
HSB secondary op waits
|
Number of times operations (transactions) on the Secondary have been waiting to continue execution
|
HSB secondary buffers
|
Number of buffered log record packets the Secondary has received from the Primary
|
HSB secondary serial mode count
|
Number of times the Secondary parallel executor has switched to serial mode instead of running in parallel
|
HSB secondary dispatch queuelength
|
Size of the most recent dispatch thread (operations to dispatch) on the Secondary
|
Tabcur create
|
Number of internal table cursor calls
|
Tabcur reset full
|
Number of full constraint reset calls in table cursor
|
Tabcur reset smpl
|
Number of simple constraint reset calls in table cursor
|
Tabcur estimate
|
Number of cost estimate calls in table cursor
|
Tabcur cached estimate
|
Number of table cursor cost estimates found from cached estimates
|
Tabcur table scan
|
Number of table scans executed in SQL statements.
A high number of table scans can mean that SQL statements are not executed optimally or some index definitions are missing from tables.
|
Tabcur index access
|
Number of index accesses executed in SQL statements
A high number of index accesses in comparison to number of table scans usually means that SQL statements are properly optimized and correct indexes are defined for tables.
|
Thread count
|
Current number of threads
|
Trans wait readlvl
|
Waits/sec for read level at commit
Trans wait readlvl is a counter that is incremented every time a transaction needs to wait for global read level to become sufficiently high so that the transaction changes become visible (to others) at commit. In regular load situations, this is instantaneous and no wait is needed. In high load situations, a short wait loop might be required.
The value of this counter is never decremented. Minor increments (single digits) during 30 second pmon interval are only an indication of a short high-load situation in the server.
|
Lock ok
|
Successful lock requests/sec
|
Lock timeout
|
Lock timeouts/sec
|
Lock deadlock
|
Deadlocks/s
|
Lock deadlock check
|
Number of lock manager deadlock checks done.
|
Lock deadlock loop
|
Number of lock manager deadlock check loops done.
|
Lock wait
|
Lock waits/sec
|
Lock count
|
Number of locks in lock manager.
|
Dropped search buffers
|
Number of search buffers removed from disk-based table searches because too many buffers were used.
|
Number of search buffers
|
Current number of search buffers used for disk-based tables.
|
NOCHECK operations
|
Internal number of nocheck operations performed.
|
MME cur num of locks
|
Current no. MME locks
|
MME max num of locks
|
Peak number of MME locks (since startup)
|
MME cur num of lock chains
|
Current no. MME hash buckets
|
MME max num of lock chains
|
Peak no. MME hash buckets (since startup)
|
MME longest lock chain path
|
MME: longest hash overflow path
|
MME mem used by tuples
|
MME memory allocated to tuples in kilobytes
|
MME mem used by indexes
|
MME memory allocated to indexes in kilobytes
|
MME mem used by page structs
|
MME memory allocated to the shadow structures in kilobytes
|
MME page splits
|
Number of MME page splits
|
MME page joins
|
Number of MME page joins
|
MME unnec mutexed searches
|
Number of MME rows fetched while unnecessarily in exclusive mode
|
MME nonmatched (RO)
|
Number of MME rows that did not match search criteria fetched in shared mode
|
MME nonmatched (EXCL)
|
Number of MME rows that did not match search criteria fetched in exclusive mode
|
MME inserts with x gate
|
Number of inserts done in exclusive mode. Insert switches from shared mode to exclusive mode for example, when the insert causes index node split.
|
MME deletes with x gate
|
Number of MME deletes performed in exclusive mode
|
MME hotspot protection
|
Number of times an MME search enters exclusive mode to access a hotspot
|
MME index key inserts
|
Number of keys inserted to MME indexes, includes keys inserted during a database recovery (not accurate1)
|
MME index key deletes
|
Number of keys deleted from MME indexes. (not accurate1)
|
MME bnode resizes
|
Number of times a MME bnode has been resized
|
MME vtrie mutex collisions
|
Number of times optimistic mutexing in vtrie has collided (not accurate1, congestion2)
|
MME vtrie version colls
|
Number of times a version check in vtrie has collided (not accurate1, congestion2)
|
MME vtrie vertical splits
|
Number of times a search path in vtrie has been vertically split by a key insert (not accurate1)
|
MME vtrie new branches
|
Number of times a new branch has been added to a vtrie node (not accurate1)
The approximate branching factor of the vtrie can be calculated as
(MME vtrie new branches - MME vtrie branch deletes) / (MME vtrie vertical splits - MME vtrie vertical joins) + 2.
This branching factor is only for the vtrie part of the index, the bnode leaf level branching factor cannot be estimated.
|
MME vtrie vertical joins
|
Number of times a key delete from vtrie has caused a node on the search path to be deleted (not accurate1)
|
MME vtrie branch deletes
|
Number of times a key delete from vtrie has caused a branch to be removed from a vtrie node (not accurate1)
|
MME vtrie search retries
|
Number of vtrie search retries per second
|
MME vtrie insert retries
|
Number of times a vtrie insert has been retried because of a collision (not accurate1, congestion2)
|
MME vtrie delete retries
|
Number of times a vtrie delete has been retried because of a collision (not accurate1, congestion2)
|
MME bnode mutex collisions
|
Number of times bnode accesses have caused a mutex collision (not accurate1, congestion2)
|
MME bnode version colls
|
Number of times bnode accesses have failed because of a version collision (not accurate1, congestion2)
|
MME purge invalidations
|
Number of purge invalidations per second
|
MME ffmem privctx init
|
Internal use only
|
MME ffmem privctx done
|
Internal use only
|
MME ffmem purge
|
How frequently in seconds the purge routine is called
|
MME ffmem purge step
|
How frequently in seconds the purge step routine is called
|
Posted events queue
|
Number of posted events that have not been consummated by the subscribers
|
Index search both
|
Search is done from both the Bonsai tree and the storage tree
|
Index search storage
|
Index search is done from storage tree only
|
B-tree node search keys
|
DBE B tree searches/sec
|
B-tree node search mismatch
|
A search was done by using the mismatch index search structure within a B-tree node. Mismatch index is a search structure where an array of mismatch index positions is built within a B-tree node. This mismatch index is a compact and linear data structure that is used to perform a fast scan over compressed key information to find a key position within the B-tree node. It attempts to optimize the search by using fast access in the processor cache row by packing relevant search information in one to three processor cache pages.
|
B-tree node build mismatch
|
A new mismatch index search structure is built within a B-tree node. Mismatch index is a search structure where an array of mismatch index positions is built within a B-tree node. This mismatch index is a compact and linear data structure that is used to perform a fast scan over compressed key information to find a key position within the B-tree node. It attempts to optimize the search by using fast access in the processor cache row by packing relevant search information in one to three processor cache pages.
|
B-tree node split
|
Number of B-tree node splits/sec
|
B-tree node join
|
Number of joined B-tree nodes
|
B-tree node relocate
|
A B-tree node is relocated. This happens when a block that belongs to a previous checkpoint is changed for the first time. Typically, this value is highest immediately after a checkpoint.
|
B-tree node delete empty
|
An empty B-tree node is deleted.
|
B-tree node storage fill factor
|
|
B-tree node Bonsai fill factor
|
|
B-tree node exclusive
|
Exclusive access to the B-tree is used. This can happen, for example, in a node split case such as when the tree root is split.
|
B-tree key read
|
Normal key value is read from the B-tree.
|
B-tree key read delete
|
Delete mark is read from the B-tree.
|
B-tree key read oldversion
|
Old row version is read from the B-tree.
|
B-tree key read abort
|
A row from an aborted transaction is read from the B-tree. This includes all transactions that were not successfully completed.
|
B-tree storage leaf len
|
Average length for storage tree leaf node.
|
B-tree storage index len
|
Average length for storage tree index node.
|
B-tree bonsai leaf len
|
Average length for Bonsai-tree leaf node.
|
B-tree bonsai index len
|
Average length for Bonsai-tree index node.
|
Bonsai-tree height
|
Current Bonsai tree height in levels.
|
Storage tree height
|
Current storage tree height in levels.
|
B-tree lock node
|
Number of B-tree node lock calls.
|
B-tree lock tree
|
Number of whole B-tree lock calls.
|
B-tree lock full path
|
Number of B-tree full node path lock calls.
|
B-tree lock partial path
|
Number of B-tree partial node path lock calls.
|
B-tree get no lock
|
Number of B-tree no lock calls.
|
B-tree get shared lock
|
Number of B-tree shared lock calls.
|
Pessimistic gate wait
|
Number of waits for pessimistic disk-based table gate.
|
Merge gate wait
|
Number of waits for merge gate.
|
Storage gate wait
|
Number of waits for storage tree gate.
|
Bonsai Gate wait
|
Number of waits for Bonsai-tree gate.
|
Action gate wait
|
Number of action gait waits
|
MME pages gate wait
|
Number of gate waits when accessing pages in MME storage
|
MME index gate wait
|
Number of gate waits when accessing MME index
|
Gate wait
|
There is a wait in a gate object. A gate object is an internal synchronization mechanism.
|
Logreader spm reqcount
|
Logreader log space request/sec
|
Logreader spm waitct
|
Logreader log space waits/sec
|
Logreader spm freespc min
|
Minimum value of log reader space manager free space (number of operations that can be buffered).
Each log reader cursor has its own free space counter; if there are multiple open log reader cursors, the value is the minimum value of free space of all open cursors. If the free space of any log reader cursor is zero, the value of this counter is zero and transaction throttling (slowdown) is enacted.
|
Logreader spm freespc max
|
Maximum value of log reader space manager free space (number of operations that can be buffered). If there are multiple open log reader cursors, the value is the maximum value of free space of all open cursors.
|
Logreader logdata queue len
|
Logreader: number of log record blocks waiting for processing.
|
Logreader record queue len
|
Logreader: number of log records waiting for propagation.
|
Logreader stmt queue len
|
Logreader: number of statements waiting for statement commit/rollback.
|
Logreader open cursors
|
Logreader: number of open cursors to SYS_LOG.
|
Logreader records processed
|
Logreader: number of log records processed/sec.
|
Logreader records sent
|
Logreader: number of log records sent for propagation/sec.
|
Logreader commits processed
|
Logreader: number of commits processed/sec.
|
Logreader commits sent
|
Logreader: number of commits sent to the propagator/sec.
|
Logreader messages sent
|
Logreader: number of wakeup messages to open cursors/sec.
|
Logreader catchup state
|
Logreader catchup state.
|
Logreader catchup queue len
|
Logreader: number of log records in catchup queue.
|
Logreader catchup queue size
|
Logreader: size of the catchup queue, in bytes.
|
Logreader pending queue len
|
Logreader: number of pending log records in the in-memory log buffer.
|
Logreader memcache queue len
|
Logreader: length of the in-memory buffer queue, in operations.
|
Logreader batch queue len
|
Logreader: current number of operations queued for the next batch.
|
Logreader flush batch full
|
Logreader: a full transaction back was flushed from logreader.
|
Logreader flush batch force
|
Logreader: a non-full transaction batch was flushed from logreader.
|
TS applied transactions
|
Number of transactions applied into solidDB® by IBM InfoSphere CDC instance when solidDB® is a target datastore.
|
Passthrough open connections
|
Number of SQL passthrough connections to back-end
|
Passthrough open statements
|
Number of prepared statements to back-end
|
Passthrough reads
|
Number of executed read-type statements that return rows (for example, SELECT statements)
|
Passthrough non reads
|
Number of executed write-type statements that return rows (for example, INSERT statements)
|
Passthrough commits
|
Number of committed statements
|
Passthrough rollbacks
|
Number of rollback statements
|
Passthrough result cnv
|
Number of fetched (read) rows for which conversion between back-end and solidDB® data types have been performed. For example, conversion is needed if the data type in the backend is CHAR(5) and VARCHAR in solidDB®.
|
Passthrough param cnv
|
Number of statements for which conversion between statement parameters have been performed
|
Passthrough failures
|
Number of statements that could not be prepared in back-end
|
Passthrough reprepared
|
Number of statements that have been reprepared because write-type statements other that INSERT, UPDATE, and DELETE have been executed in the back-end. Repreparation is needed in such cases to ensure that the table definitions have not been changed, which in turn would cause errors with the prepared statements.
|
Passthrough complex by num non indexed constraints
|
Number of statements that are passed through based on the parameter Passthrough.ComplexNumNonindexedConstr
|
Passthrough complex by num ordered rows
|
Number of statements that are passed through based on the parameter Passthrough.ComplexNumOrderedRows
|
Passthrough complex by num tables
|
Number of statements that are passed through based on the parameter Passthrough.ComplexNumTables
|
XA trans start
|
Number of XA transactions that have been started
|
XA trans end
|
Number of XA transactions that have ended
|
XA trans resume
|
Number of XA transactions that have been resumed
|
XA trans prepare
|
Number of XA transactions that have been prepared
|
XA trans commit
|
Number of XA transactions that have been committed
|
XA trans rollback
|
Number of XA transactions that have been rolled back
|
XA trans forget
|
Number of XA transactions that have been forgotten
|
XA trans recover
|
Number of XA transactions that have been recovered
|
XA trans active
|
Number of XA transactions that are active at the time of the query
|
SMA connection count
|
Number of SMA connections
|
SMA shared memory used
|
Amount of shared memory used
|
TC wait read level
|
Number of times read operations on the Secondary have been waiting to be executed, when using Transparent Connectivity (TC)
|
DB actiongate lock time, latest
|
Amount of time in milliseconds the last lock lasted
|
DB actiongate lock time, sum
|
Amount of time in milliseconds all locks have lasted since server startup
|
DB actiongate lock count
|
Number of locks since server startup
|
Latency below 1 ms
|
Number of statements for which the latency is below 1 millisecond.
To enable the collection of latency statistics:
1 Start the collection of latency statistics with the command:
ADMIN COMMAND 'perfmon timers start'
2 View the latency statistics with the command:
ADMINCOMMAND 'perfmon latency'
|
Latency below 2 ms
|
Number of statements for which the latency is below 1 millisecond.
|
Latency below 4 ms
|
Number of statements for which the latency is below 2 milliseconds.
|
Latency below 8 ms
|
Number of statements for which the latency is below 4 milliseconds.
|
Latency below 16 ms
|
Number of statements for which the latency is below 16 milliseconds.
|
Latency below 32 ms
|
Number of statements for which the latency is below 32 milliseconds.
|
Latency below 64 ms
|
Number of statements for which the latency is below 64 milliseconds.
|
Latency below 128 ms
|
Number of statements for which the latency is below 128 milliseconds.
|
Latency below 256 ms
|
Number of statements for which the latency is below 256 milliseconds.
|
Latency below 512 ms
|
Number of statements for which the latency is below 512 milliseconds.
|
Latency over 512 ms
|
Number of statements for which the latency is over 512 milliseconds.
|
Time sec
|
Printout time of this pmon in seconds
|
Cache seg remains default contra request
|
Number of cache pages (per second) that are allocated to default (unassigned) segment against request
|
Cache seg remains special contra request
|
Number of cache pages (per second) that are allocated to assigned segments against request
|
Cache seg set default, victim from other
|
Number of cache pages (per second) that came from assigned segment
|
Cache seg set default, victim from self
|
Number of cache pages (per second) that came from the same segment
|
Cache seg set special, victim from other
|
Number of cache pages (per second) that came from other assigned or unassigned segment
|
Cache seg set special, victim from self
|
Number of cache pages (per second) that came from the same assigned segment
|
Cache seg remains default per request
|
Number of cache pages (per second) that are allocated to default (unassigned) segment as requested
|
Cache seg remains special per request
|
Number of cache pages (per second) that are allocated to default assigned segments as requested
|
Perfmon variable
|
Description
|
Cache seg set default, original dropped
|
Number of cache pages in a dropped segment
|