DBA_HIST_SYSSTAT is Different Output at CDB and PDB Level (Doc ID 2711623.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• The following information is different from CDB and PDB:
  select H.SNAP_ID,
  TO_CHAR(S.BEGIN_INTERVAL_TIME,'MM/DD/YYYY hh24:mi:ss') as BEGIN_INTERVAL_TIME,
  TO_CHAR(S.END_INTERVAL_TIME, 'MM/DD/YYYY hh24:mi:ss') as END_INTERVAL_TIME,
  H.VALUE
  FROM DBA_HIST_SYSSTAT H JOIN DBA_HIST_SNAPSHOT S
  ON H.SNAP_ID=S.SNAP_ID
  AND H.DBID=S.DBID
  AND H.INSTANCE_NUMBER=S.INSTANCE_NUMBER
  WHERE STAT_NAME='user logons cumulative'
   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.