PSPMTRANSCURRVW

(SQL View)
 Index Back

Current PMUs View

Performance monitor current PMU table.

SELECT PM_INSTANCE_ID , PM_INSTANCE_SEQ , PM_TRANS_DEFN_SET , PM_TRANS_DEFN_ID , PM_AGENTID , OPRID , PM_PERF_TRACE , PM_ACTION , PM_TRANS_DELETED , PM_CONTEXT_VALUE1 , PM_CONTEXT_VALUE2 , PM_CONTEXT_VALUE3 , PM_CONTEXTID_1 , PM_CONTEXTID_2 , PM_CONTEXTID_3 , PM_AGENT_STRT_DTTM , PM_AGENT_LAST_DTTM , PM_MON_STRT_DTTM , PM_MON_LAST_DTTM , PM_TIMEOUT_DTTM , PM_PARENT_INST_ID , PM_TOP_INST_ID , PM_PROCESS_ID , PM_METRIC_VALUE1 , PM_METRIC_VALUE2 , PM_METRIC_VALUE3 , PM_METRIC_VALUE4 , PM_METRIC_VALUE5 , PM_METRIC_VALUE6 , PM_METRIC_VALUE7 , PM_ADDTNL_DESCR FROM PSPMTRANSCURR WHERE PM_ADDTNL_DESCR IS NOT NULL

# 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_INSTANCE_SEQ Number(5,0) INTEGER NOT NULL Instance sequence number
3 PM_TRANS_DEFN_SET Number(5,0) INTEGER NOT NULL Performance monitor transaction definition set number.
4 PM_TRANS_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Transaction Definition Identifier.
5 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 PM_PERF_TRACE Character(128) VARCHAR2(128) NOT NULL Performance Trace Name
8 PM_ACTION Character(1) VARCHAR2(1) NOT NULL Action
0=0-Start
1=1-Update
2=2-Stop
3=3-Atomic
4=4-Unknown
9 PM_TRANS_DELETED Character(1) VARCHAR2(1) NOT NULL PMU Deleted
10 PM_CONTEXT_VALUE1 Character(254) VARCHAR2(254) NOT NULL Context 1
11 PM_CONTEXT_VALUE2 Character(254) VARCHAR2(254) NOT NULL Context 2
12 PM_CONTEXT_VALUE3 Character(254) VARCHAR2(254) NOT NULL Context 3
13 PM_CONTEXTID_1 Number(5,0) INTEGER NOT NULL Context Identifier 1
14 PM_CONTEXTID_2 Number(5,0) INTEGER NOT NULL Context Identifier 2
15 PM_CONTEXTID_3 Number(5,0) INTEGER NOT NULL Context Identifier 3
16 PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time
17 PM_AGENT_LAST_DTTM DateTime(26) TIMESTAMP Agent Last Update Date/Time
18 PM_MON_STRT_DTTM DateTime(26) TIMESTAMP Monitor Received Date/Time
19 PM_MON_LAST_DTTM DateTime(26) TIMESTAMP Monitor Last Update Date/Time
20 PM_TIMEOUT_DTTM DateTime(26) TIMESTAMP Timeout datetime
21 PM_PARENT_INST_ID Number(20,0) DECIMAL(20) NOT NULL Parent Instance Identifier
22 PM_TOP_INST_ID Number(20,0) DECIMAL(20) NOT NULL Top Instance Identifier
23 PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
24 PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
25 PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
26 PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
27 PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
28 PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
29 PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
30 PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
31 PM_ADDTNL_DESCR Long Character CLOB Additional Description