PSPMTRANS14_VW

(SQL View)
Index Back

PeopleCode Ad-hoc SQL View

Performance monitor view of completed transactions for all the ad-hoc SQL transactions.

SELECT C.PM_INSTANCE_ID , C.PM_TRANS_DEFN_SET , C.PM_TRANS_DEFN_ID , C.PM_AGENTID , C.OPRID , C.PM_PERF_TRACE , C.PM_CONTEXT_VALUE1 , C.PM_CONTEXT_VALUE2 , C.PM_CONTEXT_VALUE3 , C.PM_AGENT_STRT_DTTM , C.PM_MON_STRT_DTTM , C.PM_TRANS_DURATION , C.PM_PARENT_INST_ID , C.PM_TOP_INST_ID , C.PM_METRIC_VALUE1 , C.PM_METRIC_VALUE2 , C.PM_METRIC_VALUE3 , C.PM_METRIC_VALUE4 , C.PM_METRIC_VALUE5 , C.PM_METRIC_VALUE6 , C.PM_METRIC_VALUE7 , ' ' , ' ' , ' ' , 0 , 0 , 0 , C.PM_ADDTNL_DESCR FROM PSPMTRANSHIST C WHERE C.PM_TRANS_DEFN_SET = 1 AND C.PM_TRANS_DEFN_ID = 406

# 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_TRANS_DEFN_SET Number(5,0) INTEGER NOT NULL Performance monitor transaction definition set number.
3 PM_TRANS_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Transaction Definition Identifier.
4 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 PM_PERF_TRACE Character(128) VARCHAR2(128) NOT NULL Performance Trace Name
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_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time
11 PM_MON_STRT_DTTM DateTime(26) TIMESTAMP Monitor Received Date/Time
12 PM_TRANS_DURATION Number(22,3) DECIMAL(21,3) NOT NULL Duration (ms)
13 PM_PARENT_INST_ID Number(20,0) DECIMAL(20) NOT NULL Parent Instance Identifier
14 PM_TOP_INST_ID Number(20,0) DECIMAL(20) NOT NULL Top Instance Identifier
15 PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
16 PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
17 PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
18 PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
19 PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
20 PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
21 PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
22 PM_CHART_XAXIS Character(100) VARCHAR2(100) NOT NULL Chart X-Axis Text
23 PM_CHART_SERIES Character(30) VARCHAR2(30) NOT NULL Data Series
24 PM_CHART_HINTS Character(128) VARCHAR2(128) NOT NULL Data Hints
25 PM_CHART_COLOR Number(3,0) SMALLINT NOT NULL Chart Color
26 PM_CHART_YAXIS Number(13,2) DECIMAL(12,2) NOT NULL Chart Y-Axis Values
27 PM_CHART_POS Number(3,0) SMALLINT NOT NULL Chart position
28 PM_ADDTNL_DESCR Long Character CLOB Additional Description