sel * from table (monitorsession(-1,'*',0)) as t1;
Result:
HostId 1
SessionNo 1025
LogonPENo 30719
RunVprocNo 30719
PartName DBC/SQL
PEstate IDLE
LogonTime 2024/02/07 14:45:25.00
UserId 1
LSN 0
UserName DBC
UserAccount DBC
PECPUsec 3.08000000000000E-001
XActCount 1.00000000000000E 000
ReqCount 2.00000000000000E 000
ReqCacheHits 0.00000000000000E 000
AMPState IDLE
AMPCPUSec 4.00000000000000E-003
AMPIO 8.20000000000000E 001
ReqSpool 0.00000000000000E 000
Blk1HostId 0
Blk1SessNo 0
Blk1UserId 0
Blk1Lmode
Blk1Otype
Blk1ObjDBID 0
Blk1ObjTID 0
Blk1Status
Blk2HostId 0
Blk2SessNo 0
Blk2UserId 0
Blk2Lmode
Blk2Otype
Blk2ObjDBID 0
Blk2ObjTID 0
Blk2Status
Blk3HostId 0
Blk3SessNo 0
Blk3UserId 0
Blk3Lmode
Blk3Otype
Blk3ObjDBID 0
Blk3ObjTID 0
Blk3Status
MoreBlockers
LogonSource (TCP/IP) 9436 127.0.0.1 DBC 10412 ROOT BTEQ 01 LSS
HotAmp1CPU 0.00000000000000E 000
HotAmp2CPU 0.00000000000000E 000
HotAmp3CPU 0.00000000000000E 000
HotAmp1CPUId 0
HotAmp2CPUId 0
HotAmp3CPUId 0
HotAmp1IO 0.00000000000000E 000
HotAmp2IO 0.00000000000000E 000
HotAmp3IO 0.00000000000000E 000
HotAmp1IOId 0
HotAmp2IOId 0
HotAmp3IOId 0
LowAmp1CPU 0.00000000000000E 000
LowAmp2CPU 0.00000000000000E 000
LowAmp3CPU 0.00000000000000E 000
LowAmp1CPUId 0
LowAmp2CPUId 0
LowAmp3CPUId 0
LowAmp1IO 0.00000000000000E 000
LowAmp2IO 0.00000000000000E 000
LowAmp3IO 0.00000000000000E 000
LowAmp1IOId 0
LowAmp2IOId 0
LowAmp3IOId 0
AvgAmpCPUSec 0.00000000000000E 000
AvgAmpIOCnt 0.00000000000000E 000
AmpCount 0
TempSpaceUsg 0.00000000000000E 000
ReqStartTime 0000/00/00 00:00:00.00
ReqCPU 0.00000000000000E 000
ReqIO 0.00000000000000E 000
ReqNo 0
WlcId 30
DontReclassifyFlag 0
ProxyUser
CPUDecayLevel 0
IODecayLevel 0
TacticalCPUException 0
TacticalIOException 0
ReqIOKB 0.00000000000000E 000
ReqPhysIO 0.00000000000000E 000
ReqPhysIOKB 0.00000000000000E 000
ReqStepsCompletedCnt 0
RedriveProtection MN
CurrentRedriveParticipation F
ReqRedriveSpoolSpace 0.00000000000000E 000
BlockerSessionCnt 0
ReqTblOpBytesIn 0.00000000000000E 000
ReqTblOpBytesOut 0.00000000000000E 000
ProxyUserId 0
ZoneId 0
ReqHotAmpCPU 0.00000000000000E 000
ReqHotAmpCPUId -1
ReqHotAmpIO 0.00000000000000E 000
ReqHotAmpIOId -1
ReqInvolvedAMPCnt 0
ReqFirstRespTime 0000/00/00 00:00:00.00
ReqLocalQueryStatus 0
ReqRemoteHostId 0
ReqRemoteSessionId 0
ReqRemoteRequestId 0
ReqRemoteQueryId 0.00000000000000E 000
ReqHotAmpSpool 0.00000000000000E 000
ReqHotAmpSpoolId -1
ReqMapNo 0
ReqMaxNumMapAMPs 0
ReqMinNumMapAMPs 0
ReqSysDefNumMapAMPs 0
ReqRemoteHostIp
ReqServerName
ReqFlexReleased 0
ReqAdmissionTime 0000/00/00 00:00:00.00
ComputeWorkerInUse F
QueryID 307197241654252384.
CollectionTime 2024-03-16 12:35:00.00000