Oracle X$ View:X$KJMSDP

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.

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569