本文由 资源共享网 – ziyuan 发布，转载请注明出处，如有问题请联系我们！Oracle SQL集群源代码实例

SELECT TO_CHAR(snaps.begin_interval_time, 'DD-MON-YYYY HH24:MI') begin_time,

  snaps.instance_number,

  hist.name,

  TRUNC((hist.bytes_received - lag (hist.bytes_received) OVER (

        PARTITION BY hist.name, startup_time, hist.instance_number

        ORDER BY begin_interval_time, startup_time, 

  hist.instance_number, hist.name))/1048576,2) bytes_rcvd,

  TRUNC((hist.bytes_sent     - lag (hist.bytes_sent) OVER (

        PARTITION BY hist.name, startup_time, hist.instance_number

        ORDER BY begin_interval_time, startup_time, 

          hist.instance_number, hist.name))/1048576,2) bytes_sent

FROM dba_hist_ic_client_stats hist,

  DBA_HIST_SNAPSHOT snaps

WHERE snaps.snap_id           = hist.snap_id

AND snaps.instance_number     = hist.instance_number

AND snaps.begin_interval_time > sysdate-1

AND hist.name                 ='ipq'

ORDER BY snaps.snap_id, instance_number;

col username for a12

col "QC SID" for A6

col SID for A6

col "QC/Slave" for A10

col "Requested DOP" for 9999

col "Actual DOP" for 9999

col server_set for  A10

set pages 100

select

  decode(px.qcinst_id,NULL,username,

        ' - '||lower(substr(s.program,length(s.program)-4,4) ) ) "Username",

  decode(px.qcinst_id,NULL, 'QC', '(Slave)') "QC/Slave" ,

  to_char( px.server_set) server_set,

  to_char(s.sid) "SID",

  decode(px.qcinst_id, NULL ,to_char(s.sid) ,px.qcsid) "QC SID",

  px.req_degree "Requested DOP",

  px.degree "Actual DOP"

from

  v$px_session px,

  v$session s

where

  px.sid=s.sid (+)

 and

  px.serial#=s.serial#

order by 5 , 1 desc

/