ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > Linux操作系统 > Linux操作系统 > 基于AWR实现STATSPACK报告(3-RAC统计)

基于AWR实现STATSPACK报告(3-RAC统计)

原创 Linux操作系统 作者：redhouser 时间：2011-07-01 16:51:18 0 删除 编辑

RAC Statistics  DB/Inst: ORADB/oraDB1  Snaps: 66-67
                                Begin        End
                                -----      -----
           Number of Instances:     2     2
++++-分析-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Number of Instances:
SELECT COUNT(b.thread#)
  FROM dba_hist_thread b
 WHERE b.snap_id = &bid
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.status = 'OPEN';
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Global Cache Load Profile
~~~~~~~~~~~~~~~~~~~~~~~~~                  Per Second       Per Transaction
                                      ---------------       ---------------
  Global Cache blocks received:                629.63                 19.07
    Global Cache blocks served:                448.20                 13.58
     GCS/GES messages received:              2,345.46                 71.05
         GCS/GES messages sent:              1,836.10                 55.62
            DBWR Fusion writes:                  5.96                  0.18
Estd Interconnect traffic (KB):              9,439.34
++++-分析-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Global Cache blocks received:round((:gccurv+:gccrrv)/:ela,2),round((:gccurv+:gccrrv)/:tran,2)
Global Cache blocks served:round((:gccusv+:gccrsv)/:ela,2),round((:gccusv+:gccrsv)/:tran,2)
GCS/GES messages received:round((:pmrv+:npmrv)/:ela,2),round((:pmrv+:npmrv)/:tran,2)
GCS/GES messages sent:round((:dpms+:dnpms)/:ela,2),round((:dpms+:dnpms)/:tran,2)
DBWR Fusion writes:round(:dbfr/:ela,2),round(:dbfr/:tran,2)
Estd Interconnect traffic (KB):round((((:gccrrv+:gccurv +:gccrsv+:gccusv) * :bs) + ((:dpms+:dnpms+:pmrv+:npmrv) * 200))/1000/:ela,2)
其中：
gccurv-->gc current blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current blocks received';

gccrrv-->gc cr blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr blocks received';

ela-->
SELECT (CAST(e.end_interval_time AS DATE) -
       CAST(b.end_interval_time AS DATE)) * 1440 * 60
  FROM dba_hist_snapshot b, dba_hist_snapshot e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid;

tran-->ucom+urol
SELECT sum(e.VALUE) - sum(b.VALUE)
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name in('user commits','user rollbacks');

gccusv-->gc current blocks served
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current blocks served';

gccrsv-->gc cr blocks served
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr blocks served';

pmrv-->gcs msgs received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='gcs msgs received';

npmrv-->ges msgs received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='ges msgs received';

dpms-->gcs messages sent
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gcs messages sent';

dnpms-->ges messages sent
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='ges messages sent';

dbfr-->DBWR fusion writes
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='DBWR fusion writes';

bs-->db_block_size
SELECT VALUE
  FROM dba_hist_parameter t
 WHERE t.dbid = &dbid
   AND t.instance_number = &inst_num
   AND t.snap_id = &bid
   AND t.parameter_name = 'db_block_size';
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Global Cache Efficiency Percentages (Target local+remote 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer access -  local cache %:   93.82
Buffer access - remote cache %:    1.57
Buffer access -         disk %:    4.61
++++-分析-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Buffer access -  local cache %:round(100*(1- (:phyrc +:gccrrv+:gccurv)/:gets), 2)
Buffer access - remote cache %:round(100* (:gccurv+:gccrrv)/:gets, 2) 
Buffer access -         disk %:round(100 * :phyrc/:gets, 2)
其中：
phyrc-->physical reads cache
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='physical reads cache';

gccurv-->gc current blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current blocks received';

gccrrv-->gc cr blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr blocks received';

gets-->total number of buffers gets from cache
SELECT sum(e.VALUE) - sum(b.VALUE)
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name in('consistent gets from cache','db block gets from cache');
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Global Cache and Enqueue Services - Workload Characteristics
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                     Avg global enqueue get time (ms):     0.0

          Avg global cache cr block receive time (ms):     0.9
     Avg global cache current block receive time (ms):     0.9

            Avg global cache cr block build time (ms):     0.0
             Avg global cache cr block send time (ms):     0.0
            Avg global cache cr block flush time (ms):     6.9
      Global cache log flushes for cr blocks served %:     1.8

         Avg global cache current block pin time (ms):     0.0
        Avg global cache current block send time (ms):     0.0
       Avg global cache current block flush time (ms):     2.0
 Global cache log flushes for current blocks served %:     0.0
++++-分析-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Avg global enqueue get time (ms): (:glgt / (:glag+:glsg)) * 10)

Avg global cache cr block receive time (ms):10 * :gccrrt / :gccrrv
Avg global cache current block receive time (ms):10 * :gccurt / :gccurv

Avg global cache cr block build time (ms):10 * :gccrbt / :gccrsv
Avg global cache cr block send time (ms):10 * :gccrst / :gccrsv
Avg global cache cr block flush time (ms):10 * :gccrft / :gccrfl
Global cache log flushes for cr blocks served %:100 * :gccrfl/:gccrsv

Avg global cache current block pin time (ms):10 * :gccupt / :gccusv
Avg global cache current block send time (ms):10 * :gccust / :gccusv
Avg global cache current block flush time (ms):10 * :gccuft / :gccufl
Global cache log flushes for current blocks served %:100 * :gccufl/:gccusv
其中：
glgt-->global enqueue get time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='global enqueue get time';

glag-->global enqueue gets async
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='global enqueue gets async';

glsg-->global enqueue gets sync
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='global enqueue gets sync';

gccrrt-->gc cr block receive time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr block receive time';

gccrrv-->gc cr blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr blocks received';

gccurt-->gc current block receive time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current block receive time';

gccurv-->gc current blocks received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current blocks received';

gccrbt-->gc cr block build time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr block build time';

gccrsv-->gc cr blocks served
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr blocks served';

gccrst-->gc cr block send time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr block send time';

gccrft-->gc cr block flush time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc cr block flush time';

gccrfl-->
SELECT e.flushes - b.flushes
  FROM dba_hist_cr_block_server b, dba_hist_cr_block_server e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid;

gccupt-->gc current block pin time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current block pin time';

gccusv-->gc current blocks served
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current blocks served';

gccust-->gc current block send time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current block send time';

gccuft-->gc current block flush time
SELECT e.VALUE - b.VALUE
  FROM dba_hist_sysstat b, dba_hist_sysstat e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.stat_name = e.stat_name
   AND b.stat_name ='gc current block flush time';

gccufl-->
SELECT (e.flush1 + e.flush10 + e.flush100 + e.flush1000 + e.flush10000) -
       (b.flush1 + b.flush10 + b.flush100 + b.flush1000 + b.flush10000)
  FROM dba_hist_current_block_server b, dba_hist_current_block_server e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Global Cache and Enqueue Services - Messaging Statistics
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                     Avg message sent queue time (ms):     0.0
             Avg message sent queue time on ksxp (ms):     0.3
                 Avg message received queue time (ms):     0.0
                    Avg GCS message process time (ms):     0.0
                    Avg GES message process time (ms):     0.0

                            % of direct sent messages:   37.24
                          % of indirect sent messages:   56.30
                        % of flow controlled messages:    6.45
++++-分析-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Avg message sent queue time (ms):msgsqt / :msgsq
Avg message sent queue time on ksxp (ms):msgsqtk / :msgsqk
Avg message received queue time (ms):msgrqt / :msgrq
Avg GCS message process time (ms):pmpt / :pmrv
Avg GES message process time (ms):npmpt / :npmrv

% of direct sent messages:(100 * :dmsd) / (:dmsd + :dmsi + :dmfc)
% of indirect sent messages:(100 * :dmsi) / (:dmsd + :dmsi + :dmfc)
% of flow controlled messages: 100 * :dmfc / (:dmsd+:dmsi+:dmfc)
其中：
msgsqt-->msgs sent queue time (ms)
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs sent queue time (ms)';

msgsq-->msgs sent queued
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs sent queued';

msgsqtk-->msgs sent queue time on ksxp (ms)
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs sent queue time on ksxp (ms)';

msgsqk-->msgs sent queued on ksxp
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs sent queued on ksxp';

msgrqt-->msgs received queue time (ms)
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs received queue time (ms)';

msgrq-->msgs received queued
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='msgs received queued';

pmpt-->gcs msgs process time(ms)
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='gcs msgs process time(ms)';

pmrv-->gcs msgs received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='gcs msgs received';

npmpt-->ges msgs process time(ms)
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='ges msgs process time(ms)';

npmrv-->ges msgs received
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='ges msgs received';


dmsd-->messages sent directly
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='messages sent directly';

dmfc-->messages flow controlled
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='messages flow controlled';

dmsi-->messages sent indirectly
SELECT e.VALUE - b.VALUE
  FROM dba_hist_dlm_misc b, dba_hist_dlm_misc e
 WHERE b.dbid = e.dbid
   AND b.instance_number = e.instance_number
   AND b.dbid = &dbid
   AND b.instance_number = &inst_num
   AND b.snap_id = &bid
   AND e.snap_id = &eid
   AND b.name = e.name
   AND b.name ='messages sent indirectly';
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


 

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/18922393/viewspace-701149/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： 基于AWR实现STATSPACK报告(2-系统效率)
下一篇： 基于AWR实现STATSPACK报告(4-等待事件)
请登录后发表评论 登录
全部评论
redhouser

注册时间：2011-05-26

  • 博文量
    211
  • 访问量
    876680

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593