PSPMTRANS28_VW

index back

View on PMUs 406, 407, 408.

Performance monitor view on PMUs 406, 407, 408. The SQL PMUs.
SELECT A.PM_PERF_TRACE ,A.PM_INSTANCE_ID ,A.PM_TOP_INST_ID ,A.PM_PARENT_INST_ID ,A.PM_TRANS_DEFN_SET ,A.PM_TRANS_DEFN_ID ,%DecDiv(A.PM_TRANS_DURATION, 1000) ,A.PM_CONTEXT_VALUE1 ,A.PM_CONTEXT_VALUE2 ,A.PM_CONTEXT_VALUE3 ,A.PM_METRIC_VALUE1 ,A.PM_METRIC_VALUE7 ,A.PM_MON_STRT_DTTM ,A.PM_AGENT_STRT_DTTM FROM PSPMTRANSHIST A WHERE A.PM_TRANS_DEFN_SET = 1 AND A.PM_TRANS_DEFN_ID IN (406, 407, 408) AND A.PM_TOP_INST_ID IN ( SELECT B.PM_TOP_INST_ID FROM PSPMTRANSHIST B WHERE A.PM_TOP_INST_ID = B.PM_TOP_INST_ID AND B.PM_TRANS_DEFN_ID = 401)

PeopleSoft Field NameField TypeColumn TypeDescription
PM_PERF_TRACECharacter(30)VARCHAR2(30) NOT NULLPerformance Trace Name
PM_INSTANCE_IDNumber(20,0)DECIMAL(20) NOT NULLInstance Identifier
PM_TOP_INST_IDNumber(20,0)DECIMAL(20) NOT NULLTop Instance Identifier
PM_PARENT_INST_IDNumber(20,0)DECIMAL(20) NOT NULLParent Instance Identifier
PM_TRANS_DEFN_SETNumber(5,0)INTEGER NOT NULLPerformance monitor transaction definition set number.
PM_TRANS_DEFN_IDNumber(5,0)INTEGER NOT NULLPerformance Monitor Transaction Definition Identifier.
PM_TRANS_DURATIONNumber(22,3)DECIMAL(21,3) NOT NULLDuration (ms)
PM_CONTEXT_VALUE1Character(254)VARCHAR2(254) NOT NULLContext 1
PM_CONTEXT_VALUE2Character(254)VARCHAR2(254) NOT NULLContext 2
PM_CONTEXT_VALUE3Character(254)VARCHAR2(254) NOT NULLContext 3
PM_METRIC_VALUE1Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 1
PM_METRIC_VALUE7Character(128)VARCHAR2(128) NOT NULLMetric Value 7
PM_MON_STRT_DTTMDateTime(26)TIMESTAMPMonitor Received Date/Time
PM_AGENT_STRT_DTTMDateTime(26)TIMESTAMPAgent Start Date/Time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19