如何在Oracle 9i上找到高水位线(用于会话)

SELECT
  username,
  sid,
  MAX(pga_max_mem) AS max_memory_used
FROM
  v$session
GROUP BY
  username,
  sid;

SELECT
  INST_ID,
  SNAP_ID,
  TIMESTAMP,
  VALUE
FROM
  DBA_HIST_SYSMETRY
WHERE
  MET_NAME = 'sessions'
  AND VALUE_TYPE = 'HIGH_WATERMARK';

SELECT
  INST_ID,
  SESSION_ID,
  SESSION_TYPE,
  LOGON_TIME,
  LOGOFF_TIME,
  MAX_MEMORY_USED
FROM
  DBA_HIST_ACTIVE_SESS_HISTORY;