PM_PERF_TRACEPM_INSTANCE_IDPM_TOP_INST_IDPSPMTRANS28_VW(SQL View) |
Index Back |
|---|---|
View on PMUs 406, 407, 408.Performance monitor view on PMUs 406, 407, 408. The SQL PMUs. |
| SELECT A.PM_PERF_TRACE ,A.PM_INSTANCE_ID ,A.PM_TOP_INST_ID ,A.PM_PARENT_INST_ID ,A.PM_TRANS_DEFN_SET ,A.PM_TRANS_DEFN_ID ,%DecDiv(A.PM_TRANS_DURATION, 1000) ,A.PM_CONTEXT_VALUE1 ,A.PM_CONTEXT_VALUE2 ,A.PM_CONTEXT_VALUE3 ,A.PM_METRIC_VALUE1 ,A.PM_METRIC_VALUE7 ,A.PM_MON_STRT_DTTM ,A.PM_AGENT_STRT_DTTM FROM PSPMTRANSHIST A WHERE A.PM_TRANS_DEFN_SET = 1 AND A.PM_TRANS_DEFN_ID IN (406, 407, 408) AND A.PM_TOP_INST_ID IN ( SELECT B.PM_TOP_INST_ID FROM PSPMTRANSHIST B WHERE A.PM_TOP_INST_ID = B.PM_TOP_INST_ID AND B.PM_TRANS_DEFN_ID = 401) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_PERF_TRACE |
Character(128) | VARCHAR2(128) NOT NULL | Performance Trace Name |
| 2 | PM_INSTANCE_ID |
Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
| 3 | PM_TOP_INST_ID |
Number(20,0) | DECIMAL(20) NOT NULL | Top Instance Identifier |
| 4 | PM_PARENT_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Parent Instance Identifier |
| 5 | PM_TRANS_DEFN_SET | Number(5,0) | INTEGER NOT NULL | Performance monitor transaction definition set number. |
| 6 | PM_TRANS_DEFN_ID | Number(5,0) | INTEGER NOT NULL | Performance Monitor Transaction Definition Identifier. |
| 7 | PM_TRANS_DURATION | Number(22,3) | DECIMAL(21,3) NOT NULL | Duration (ms) |
| 8 | PM_CONTEXT_VALUE1 | Character(254) | VARCHAR2(254) NOT NULL | Context 1 |
| 9 | PM_CONTEXT_VALUE2 | Character(254) | VARCHAR2(254) NOT NULL | Context 2 |
| 10 | PM_CONTEXT_VALUE3 | Character(254) | VARCHAR2(254) NOT NULL | Context 3 |
| 11 | PM_METRIC_VALUE1 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 1 |
| 12 | PM_METRIC_VALUE7 | Character(128) | VARCHAR2(128) NOT NULL | Metric Value 7 |
| 13 | PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |
| 14 | PM_AGENT_STRT_DTTM | DateTime(26) | TIMESTAMP | Agent Start Date/Time |