DBA_HIST_ACTIVE_SESS_HISTORY

Hi Experts,

Our database version 19.17

Every time AWR snapshot happens, data from V$ACTIVE_SESSION_HISTORY goes into this table.But NOT all data from V$ACTIVE_SESSION_HISTORY goes into DBA_HIST_ACTIVE_SESS_HISTORY. When AWR snapshot happens, it picks only 1 out of 10 samples from V$ACTIVE_SESSION_HISTORY into history table.

if want to calculate DB Time from DBA_HIST_ACTIVE_SESS_HISTORY table, we need to consider sample time as 10 sec instead of 1 sec.

DB Time = [ Number of samples ] X [ Time interval between samples ]

        = count(1) * 10

We have a doubt here, Lets say if we have 2 sql ids,one ran for 10 sec and the other ran for 3 seconds.