PSPMTRANS27_VW

(SQL View)
 Index Back

View on PMU 401.

Performance monitor view on PMU 401.

SELECT PM_PERF_TRACE ,PM_INSTANCE_ID ,PM_TOP_INST_ID ,PM_PARENT_INST_ID ,PM_AGENTID ,PM_TRANS_DURATION ,PM_CONTEXT_VALUE1 ,PM_CONTEXT_VALUE2 ,PM_CONTEXT_VALUE3 ,PM_METRIC_VALUE1 ,PM_METRIC_VALUE2 ,PM_METRIC_VALUE3 ,PM_METRIC_VALUE4 ,PM_METRIC_VALUE5 ,PM_METRIC_VALUE6 ,PM_METRIC_VALUE7 ,PM_MON_STRT_DTTM ,PM_AGENT_STRT_DTTM FROM PSPMTRANSHIST WHERE PM_TRANS_DEFN_SET = 1 AND 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_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
6 PM_TRANS_DURATION Number(22,3) DECIMAL(21,3) NOT NULL Duration (ms)
7 PM_CONTEXT_VALUE1 Character(254) VARCHAR2(254) NOT NULL Context 1
8 PM_CONTEXT_VALUE2 Character(254) VARCHAR2(254) NOT NULL Context 2
9 PM_CONTEXT_VALUE3 Character(254) VARCHAR2(254) NOT NULL Context 3
10 PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
11 PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
12 PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
13 PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
14 PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
15 PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
16 PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
17 PM_MON_STRT_DTTM DateTime(26) TIMESTAMP Monitor Received Date/Time
18 PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time