X$KJMSDP
The table X$KJMSDP has entries for each LMS process that is configured for the instance. The default
number of LMS processes is the number of CPU’s divided by 4, but 2 as a minimum. The LMS processes are
responsible for the delivery of the GCS messages and blocks to the other instances.
Column name Data Type Description ADDR RAW(4) Identifier / Address INDX NUMBER LMS id (starts with 0) INST_ID NUMBER Instance id PID NUMBER LMS process id (starts with 0) FLAG NUMBER Flags: ACTUAL_RCV NUMBER Actual Global Cache Service messages received LOGICAL_RCV NUMBER Logical Global Cache Service messages received LOGICAL_PTIME NUMBER Logical Global Cache Service messages process time (ms) SBUF_TIME NUMBER Time for flushing send buffer (ms) FC_SENT NUMBER Number of flow control messages sent NULL_REQ NUMBER Number of null requests send by this process WAIT_TICKET NUMBER Number of times waited for tickets CRB_SENT NUMBER Number of CR blocks sent CRB_STIME NUMBER CR block sent time (ms) RCVQ_TIME NUMBER Receive message queue time ERRCHK_TIME NUMBER Error check time FMSGBUFS_TIME NUMBER Flush message buffer time RCFGFRZ_TIME NUMBER Reconfiguration freeze time RCFGSYNC_TIME NUMBER Reconfiguration sync time PBATFLUSH_TIME NUMBER Process batch flush time SQFLUSH_TIME NUMBER Send queue flush time DRMSYNC_TIME NUMBER DRM sync time RCVMSG_TIME NUMBER Time to receive messages BPMSG_TIME NUMBER Batch message process time PMSG_TIME NUMBER Time to process message from receiver SCANQ_TIME NUMBER Scan queue time PDCQ_TIME NUMBER Time to check down-convert queue PTOQ_TIME NUMBER Time to check deferred ping queue FSCH_TIME NUMBER Time to flush the side-channel messages IPBAT_TIME NUMBER Time for embedded batch message processing RETRYQ_TIME NUMBER Retry queue time
X$KJMSDP
As with the LMD process, it is important to check if there are waits for tickets. If this occurs, look at the
corresponding section at the description of the table X$KJMDDP for further explanation.
Leave a Reply