MonitorMySessions Usage Notes - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
The following CPU fields in the MonitorMySessions response are affected by the MonSesCPUNormalization field:
  • AMPCPUSec
  • AvgAmpCPUSec
  • HotAmp1CPU
  • HotAmp2CPU
  • HotAmp3CPU
  • LowAmp1CPU
  • LowAmp2CPU
  • LowAmp3CPU
  • PECPUSec
  • RequestAmpCPU

The MonSesCPUNormalization field, controls whether normalized or non-normalized statistical CPU data is reported by the functions MonitorMySessions and MonitorSession, and by the MONITOR SESSION request.

See MonitorSession and MONITOR SESSION for a list of these CPU fields.

A Trusted Session enables a middle-tier application to switch the user on an already active database session to another user (proxy user). When the user is switched, all subsequent requests use the privileges and session attributes of the proxy user. MonitorMySessions returns the logon user name and ID in the UserName and UserId fields and the proxy user name and ID in the ProxyUserName and ProxyUserId fields.

When connected as a permanent proxy user, MonitorMySessions returns information on sessions directly logged on as the permanent proxy user, but does not return the current session or any other proxy user sessions for the permanent proxy user.