PSPMEVENT6_VW

index back

Current Event View

View into the performance monitor current event table. View shows Process Resource events.
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 = 200

PeopleSoft Field Name Field Type Column Type Description
PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
PM_EVENT_DEFN_SET Number(5,0) INTEGER NOT NULL Performance Monitor Event Definition Set - used to categorize events.
PM_EVENT_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Event Identifier
PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
PM_AGENT_DTTM DateTime(26) TIMESTAMP Agent Date/Time
PM_MON_DTTM DateTime(26) TIMESTAMP Monitor Date/Time
PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
PM_FILTER_LEVEL Character(2) VARCHAR2(2) NOT NULL Reset 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_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
PM_ADDTNL_DESCR Long Character CLOB Additional Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19