PSPMEVENT3_VW(SQL View) |
Index Back |
|---|---|
Current Event ViewView 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 |