PSPMTRANS32_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 = 404 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