Database Reference
In-Depth Information
Table 6-2.
AWR - RAC- Global Cache Load Profile Formula
Profile
Formula
(
gc current blocks received
+
gc cr blocks received
)/elapsed time
Global Cache blocks received
(
gc current blocks served
+
gc cr blocks served
)/elapsed time
Global Cache blocks served
(
gcs msgs received
+
ges msgs received
)/elapsed time
GCS/GES messages received
(
gcs messages sent
+
ges messages sent
)/elapsed time
GCS/GES messages sent
DBWR Fusion writes
DBWR fusion writes/elapsed time
(((
gc cr blocks received
+
gc current blocks received
+
gc cr blocks served
+
gc current blocks served
) *
db_block_size
) +
((
gcs messages sent
+
ges messages sent
+
gcs msgs received
+
ges msgs received
) * 200)/1024/elapsed time )
Estd. (Estimated) Interconnect traffic
The formula in Table
6-2
is based on statistic values obtained from
GV$SYSSTAT
or
GV$DLM_MISC
views. The
elapsed time is the time between the start and end of collection period. In the case of an AWR report, the elapsed
time is the time between the two snapshots being compared. The load profile can be grouped by services using the
GV$SERVICE_STATS
view to obtain a more focused performance metric.
Figure
6-7
provides the overall performance of the instance with respect to global cache movement between
instances.
Figure 6-7.
12c AWR - RAC- Global Cache Transfer Stats
Search WWH ::
Custom Search