PSPMTRANS15_VW

index back

PeopleCode Ad-hoc SQL View

Performance monitor view of completed transactions for all the ad-hoc SQL transactions.
SELECT C.PM_INSTANCE_ID , C.PM_TRANS_DEFN_SET , C.PM_TRANS_DEFN_ID , C.PM_AGENTID , C.OPRID , C.PM_CONTEXT_VALUE1 , C.PM_CONTEXT_VALUE2 , C.PM_CONTEXT_VALUE3 , C.PM_AGENT_STRT_DTTM , C.PM_MON_STRT_DTTM , C.PM_TRANS_DURATION , C.PM_PARENT_INST_ID , C.PM_TOP_INST_ID , C.PM_METRIC_VALUE1 , C.PM_METRIC_VALUE2 , C.PM_METRIC_VALUE3 , C.PM_METRIC_VALUE4 , C.PM_METRIC_VALUE5 , C.PM_METRIC_VALUE6 , C.PM_METRIC_VALUE7 , ' ' , ' ' , ' ' , 0 , 0 , 0 , C.PM_ADDTNL_DESCR FROM PSPMTRANSHIST C

PeopleSoft Field NameField TypeColumn TypeDescription
PM_INSTANCE_IDNumber(20,0)DECIMAL(20) NOT NULLInstance 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_AGENTIDNumber(10,0)DECIMAL(10) NOT NULLPerformance Monitor Agent Identifier.
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
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_AGENT_STRT_DTTMDateTime(26)TIMESTAMPAgent Start Date/Time
PM_MON_STRT_DTTMDateTime(26)TIMESTAMPMonitor Received Date/Time
PM_TRANS_DURATIONNumber(22,3)DECIMAL(21,3) NOT NULLDuration (ms)
PM_PARENT_INST_IDNumber(20,0)DECIMAL(20) NOT NULLParent Instance Identifier
PM_TOP_INST_IDNumber(20,0)DECIMAL(20) NOT NULLTop Instance Identifier
PM_METRIC_VALUE1Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 1
PM_METRIC_VALUE2Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 2
PM_METRIC_VALUE3Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 3
PM_METRIC_VALUE4Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 4
PM_METRIC_VALUE5Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 5
PM_METRIC_VALUE6Signed Number(30,4)DECIMAL(28,4) NOT NULLMetric Value 6
PM_METRIC_VALUE7Character(128)VARCHAR2(128) NOT NULLMetric Value 7
PM_CHART_XAXISCharacter(100)VARCHAR2(100) NOT NULLChart X-Axis Text
PM_CHART_SERIESCharacter(30)VARCHAR2(30) NOT NULLData Series
PM_CHART_HINTSCharacter(128)VARCHAR2(128) NOT NULLData Hints
PM_CHART_COLORNumber(3,0)SMALLINT NOT NULLChart Color
PM_CHART_YAXISNumber(13,2)DECIMAL(12,2) NOT NULLChart Y-Axis Values
PM_CHART_POSNumber(3,0)SMALLINT NOT NULLChart position
PM_ADDTNL_DESCRLong CharacterCLOBAdditional Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19