Oracle X$ View:X$KJMSDP-优快云博客

本文介绍了Oracle数据库中X$KJMSDP表的结构及用途。该表记录了每个配置实例的LMS进程信息，默认LMS进程数量为CPU数量除以4，至少为2。LMS进程负责GCS消息和块的传递。文章还详细列出了表中的各字段及其含义。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

转载于:https://www.cnblogs.com/macleanoracle/archive/2010/04/01/2967414.html