PSPMEVENT9_VW

index back

Current Event View

View into the performance monitor current event table.
SELECT A.PM_INSTANCE_ID , A.PM_EVENT_DEFN_SET , A.PM_EVENT_DEFN_ID , A.PM_AGENTID , A.PM_AGENT_DTTM , A.PM_MON_DTTM , A.PM_PROCESS_ID , A.PM_FILTER_LEVEL , A.PM_METRIC_VALUE1 , A.PM_METRIC_VALUE2 , A.PM_METRIC_VALUE3 , A.PM_METRIC_VALUE4 , A.PM_METRIC_VALUE5 , A.PM_METRIC_VALUE6 , A.PM_METRIC_VALUE7 , A.PM_ADDTNL_DESCR FROM PSPMEVENTHIST A WHERE A.PM_EVENT_DEFN_SET = 1 AND A.PM_EVENT_DEFN_ID = 151

PeopleSoft Field NameField TypeColumn TypeDescription
PM_INSTANCE_IDNumber(20,0)DECIMAL(20) NOT NULLInstance Identifier
PM_EVENT_DEFN_SETNumber(5,0)INTEGER NOT NULLPerformance Monitor Event Definition Set - used to categorize events.
PM_EVENT_DEFN_IDNumber(5,0)INTEGER NOT NULLPerformance Monitor Event Identifier
PM_AGENTIDNumber(10,0)DECIMAL(10) NOT NULLPerformance Monitor Agent Identifier.
PM_AGENT_DTTMDateTime(26)TIMESTAMPAgent Date/Time
PM_MON_DTTMDateTime(26)TIMESTAMPMonitor Date/Time
PM_PROCESS_IDNumber(8,0)INTEGER NOT NULLProcess ID
PM_FILTER_LEVELCharacter(2)VARCHAR2(2) NOT NULLReset all filters
00=00-No Change
01=01-Standby
02=02-Error
03=03-Warning
04=04-Standard
05=05-Verbose
06=06-Debug
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_ADDTNL_DESCRLong CharacterCLOBAdditional Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19