VIEW: SYS.INT$DBA_HIST_SHRD_SVR_SUMMARY

Source

View Text - Preformatted

select
  sn.snap_id, sn.dbid, sn.instance_number,
  s.num_samples, s.sample_time,
  s.sampled_total_conn, s.sampled_active_conn,
  s.sampled_total_srv, s.sampled_active_srv,
  s.sampled_total_disp, s.sampled_active_disp,
  s.srv_busy, s.srv_idle, s.srv_in_net, s.srv_out_net,
  s.srv_messages, s.srv_bytes,
  s.cq_wait, s.cq_totalq,
  s.dq_totalq,
  decode(s.con_dbid, 0, s.dbid, s.con_dbid),
  0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SHARED_SERVER_SUMMARY s
where     sn.snap_id         = s.snap_id
      and sn.dbid            = s.dbid
      and sn.instance_number = s.instance_number

View Text - HTML Formatted

SELECT SN.SNAP_ID
, SN.DBID
, SN.INSTANCE_NUMBER
, S.NUM_SAMPLES
, S.SAMPLE_TIME
, S.SAMPLED_TOTAL_CONN
, S.SAMPLED_ACTIVE_CONN
, S.SAMPLED_TOTAL_SRV
, S.SAMPLED_ACTIVE_SRV
, S.SAMPLED_TOTAL_DISP
, S.SAMPLED_ACTIVE_DISP
, S.SRV_BUSY
, S.SRV_IDLE
, S.SRV_IN_NET
, S.SRV_OUT_NET
, S.SRV_MESSAGES
, S.SRV_BYTES
, S.CQ_WAIT
, S.CQ_TOTALQ
, S.DQ_TOTALQ
, DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_SHARED_SERVER_SUMMARY S WHERE SN.SNAP_ID = S.SNAP_ID
AND SN.DBID = S.DBID
AND SN.INSTANCE_NUMBER = S.INSTANCE_NUMBER