DBA AWR Interconnect Traffic

Description

Categories
Enginatics
Repository
GitHub
Displays information about the usage of an interconnect device by instance in a RAC configuration.

ipq - Parallel query communications
dlm - Database lock management
cache - Global cache communications

All other values are internal to Oracle and are not expected to have high usage.

SQL 20 lines

Parameters 5

ParameterTypeList of values SQL
Date FromLOV
dhs.begin_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))
Date ToLOV
dhs.begin_interval_time<=xxen_util.server_time(fnd_date.displaydt_to_date(:date_to))
NameLOV
dhics.name=:name
Diagnostic Pack enabledLOV
1=1
Container DataLOV
dhs.dbid=(select vd.dbid from v$database vd)