PSPMEVENT3_VW

(SQL View)
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 = 150

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
2 PM_EVENT_DEFN_SET Number(5,0) INTEGER NOT NULL Performance Monitor Event Definition Set - used to categorize events.
3 PM_EVENT_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Event Identifier
4 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
5 PM_AGENT_DTTM DateTime(26) TIMESTAMP Agent Date/Time
6 PM_MON_DTTM DateTime(26) TIMESTAMP Monitor Date/Time
7 PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
8 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
9 PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
10 PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
11 PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
12 PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
13 PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
14 PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
15 PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
16 PM_ADDTNL_DESCR Long Character CLOB Additional Description