一次刷新组的刷新过程

BEGIN dbms_refresh.refresh('"HW"."G101"'); END;

SELECT USER FROM SYS.DUAL

SELECT NAME FROM USER$  WHERE NAME = :b1

SELECT R.REFGROUP FROM SYS.RGROUP$ R  WHERE R.OWNER = :b1  AND R.NAME = :b2  AND R.INSTSITE = :b3 FOR UPDATE

SELECT NAME FROM SYS.USER$  WHERE USER# = :b1

SELECT OWNER FROM SYS.RGROUP$  WHERE REFGROUP = :b1  FOR UPDATE

SELECT C.OWNER,C.NAME FROM SYS.RGCHILD$ C  WHERE C.REFGROUP = :b1

SELECT ROLLBACK_SEG,FLAG,JOB,PURGE_OPT#,PARALLELISM#,HEAP_SIZE# FROM SYS.RGROUP$  WHERE REFGROUP = :b1

SELECT 1 FROM SYS.SNAP$  WHERE SOWNER = :b1  AND VNAME = :b2  AND INSTSITE = 0

SELECT SUBSTR(MLINK,2),TNAME,USLOG,SUBSTR(AUTO_FAST,1,1),BITAND(FLAG,:b1)  
FROM
 SYS.SNAP$  WHERE SOWNER = :b2  AND VNAME = :b3  AND INSTSITE = 0

select value$
from
 props$ where name = 'GLOBAL_DB_NAME'

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,
  o.dataobj#,o.flags
from
 obj$ o where o.obj#=:1

SELECT LOCKID  
FROM
 DBMS_LOCK_ALLOCATED  WHERE NAME = :b1 FOR UPDATE

UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION=SYSDATE + (:b1 / 86400 ) 
WHERE
 ROWID = :b2

SELECT NVL(DISABLED,'F'),FLAG  
FROM
 SYSTEM.DEF$_DESTINATION  WHERE DBLINK = NLS_UPPER(:b1)  AND CATCHUP = :b2

select    last_delivered, last_enq_tid, last_seq, disabled, rowid,   
  decode(apply_init, NULL, 1, 0), NVL(flag, '00000000')   
from
 system.def$_destination    where dblink = :1 and catchup = :2

update    system.def$_destination    set last_delivered = :1, last_enq_tid =
  :2,    last_seq = :3, last_txn_count = :4,    total_txn_count =
  total_txn_count + :5,    total_prop_time_throughput =
  total_prop_time_throughput + :6,    total_prop_time_latency =
  total_prop_time_latency + :7,    to_communication_size =
  to_communication_size + :8,    from_communication_size =
  from_communication_size + :9,    spare1 = spare1 + :10, spare2 = spare2 +
  :11,    spare3 = spare3 + :12, spare4 = spare4 + :13,    last_error_number =
   :14, last_error_message = :15   
where
 rowid = :16

select disabled, NVL(flag, '00000000')    
from
 system.def$_destination where rowid = :1

select    last_delivered, last_enq_tid, rowid   
from
 system.def$_destination dd    where (dd.dblink != :1) and (      exists (
  select 1 from system.def$_calldest cd        where cd.dblink = dd.dblink
  and cd.catchup = dd.catchup)      or exists ( select 1 from
  system.repcat$_repprop rp        where rp.dblink = dd.dblink and rp.how = 1
            and rp.extension_id = dd.catchup))

select    last_delivered, last_enq_tid   
from
 system.def$_destination

select enq_tid
from
 system.def$_aqcall    where (cscn < :1)

delete from system.def$_lob    
where
 (enq_tid = :1)

delete from system.def$_calldest    
where
 (enq_tid = :1)

delete from system.def$_aqcall    
where
 (enq_tid = :1)

update    system.def$_destination    set last_delivered = :1, last_enq_tid =
  :2,    last_seq = :3, last_txn_count = :4,    total_txn_count =
  total_txn_count + :5,    total_prop_time_throughput =
  total_prop_time_throughput + :6,    total_prop_time_latency =
  total_prop_time_latency + :7,    to_communication_size =
  to_communication_size + :8,    from_communication_size =
  from_communication_size + :9,    spare1 = spare1 + :10, spare2 = spare2 +
  :11,    spare3 = spare3 + :12, spare4 = spare4 + :13   
where
 rowid = :14

select user#
from
 sys.user$ where name = 'OUTLN'

SET CONSTRAINTS ALL DEFERRED

SELECT '"' || CON$.NAME  || '"'   
FROM
 CON$,USER$,CDEF$,OBJ$  WHERE USER$.NAME = :b1  AND OBJ$.NAME = :b2  AND
  OBJ$.OWNER# = USER$.USER#  AND OBJ$.NAMESPACE = 1  AND CDEF$.OBJ# =
  OBJ$.OBJ#  AND CDEF$.TYPE# = 2  AND BITAND(CDEF$.DEFER,1) = 1  AND
  CON$.CON# = CDEF$.CON#

SELECT tname, snapid, flag, flag2, status, master_version,        tables,
  lobmaskvec, query_len, mas_roll_seg,         mlink, snapshot, auto_fun,
  uslog, NVL(rscn, 0), refhnt, objflag,        auto_fast,        
  sna_type_oid, sna_type_hashcode, sna_type_owner, sna_type_name,        
  mas_type_oid, mas_type_hashcode, mas_type_owner, mas_type_name 
FROM
 sys.snap$ WHERE sowner = :1 and vname = :2 and instsite = :3

SELECT masobj#, masflag, mowner, master, lastsuccess, snaptime, sysdate,     
     loadertime, sysdate, NVL(refscn, 0), fcmaskvec, ejmaskvec,        
  sub_handle, change_view 
FROM
 sys.snap_reftime$  WHERE sowner = :1 AND vname = :2 AND instsite = :3 ORDER
  BY tablenum

select sysdate + 100000/86400
from
 dual

update sys.sumpartlog$ s set s.timestamp = :1, s.scn = :2 
where
  s.bo# = :3  and    s.timestamp >= to_date('4000-01-01:00:00:00',
  'YYYY-MM-DD:HH24:MI:SS')

begin   sys.dbms_snapshot_utl.set_up@CCC.US.ORACLE.COM   (:mown_col, :mas_col,
   :rollseg_col, :flag_col, :outflag_col,    :snaptime_col, :loadertime_col,
  :num_sid, :snapid_tab,    :max_tab_scn_col, :max_dl_scn_col, 
  :max_pmop_scn_col, :trunc_scn_col,    :max_ins_tim_col, :max_upd_tim_col,
  :max_del_tim_col,    :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col, 
    :hdl_col, :hdl_indx_col, :rscn);  end;

select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1,
  spare2
from
 obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or
  remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and
  :5 is null)and(subname=:6 or subname is null and :6 is null)

insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,
  remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2)
values
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16, :17)

select snacol, mascol, maspos, colrole, snapos
from
 sys.snap_colmap$   WHERE sowner = :1 AND vname = :2 AND tabnum = :3 AND
  instsite = :4

begin   sys.dbms_snapshot_utl.verify_log@CCC.US.ORACLE.COM   (:mown_col,
  :mas_col, :masobj_col, :flag_col,    :outflag_col, :lognm_col, :oldest_col,
  :oldestpk_col, :oldloader_col,    :oldest_oid_col, :oldestnew_col,
  :fcvec_col, :youngest_fc_col,    :hdl_col, :hdl_indx_col, :lrscn_col,
  :stat_col,    :typ_own_col, :typ_nam_col, :toid_col, :hashcode_col);  end;

update sys.snap$ set snapshot = :1, snaptime = :2,    auto_date = :3, snapid =
   :4, error# = 0 
where
 vname = :6 and sowner = :5 and instsite = :7

select 1
from
 sumpartlog$ a where  a.bo# = :1 and bitand(a.flags,5) != 5 and  rownum = 1

update sum$ set containerobj#=:2,containertype=:3,containernam=:4,
  fullrefreshtim=:5,increfreshtim=:6,lastrefreshscn=:7,lastrefreshdate=:8,
  refreshmode=:9,pflags=:10,mflags=:11,numdetailtab=:12,numaggregates=:13,
  numkeycolumns=:14,numjoins=:15,numinlines=:16,sumtextlen=:17,sumtext=:18,
  fromoffset=:19,fromlen=:20,objcount=:21,metaversion=:22, xpflags=:23,
  numwhrnodes=:24, numhavnodes=:25where obj#=:1

SELECT operation#, cols, sql_txt, tabnum, fcmaskvec, ejmaskvec, setnum  
FROM
 sys.snap_refop$   WHERE ((operation# >= 0 AND operation# <= 6) OR operation#
  = 10)   AND sowner = :1 AND vname = :2 AND instsite = :3   ORDER BY tabnum,
  setnum, operation#

UPDATE sys.snap$ SET status = :1, rscn = :2, refhnt = :3, flag = :4
WHERE
 vname = :5 AND sowner = :6 AND instsite = :7

UPDATE sys.snap_reftime$  SET snaptime = :1, loadertime = :2, refscn = :3,   
    fcmaskvec = :4, ejmaskvec = :5, masobj# = :6,     sub_handle = :7,
  change_view = :8 
WHERE
 sowner = :9 AND vname = :10 AND tablenum = :11 AND instsite = :12

select count(*), max(scn)
from
 sumdelta$, sumdep$  where sumobj# = :1 and p_obj# = tableobj# and scn > :2

select  count(*), max(scn)  
from
   (select sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags    from sumpartlog$ sp,
  sumdep$ sd    where sd.sumobj# = :1 and sd.p_obj# = sp.bo#    group by
  sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags    minus    select sp.BO#,
  sp.PMOPTYPE, sp.scn, sp.flags    from sumpartlog$ sp    where sp.bo# not in
           (select sk.DETAILOBJ#           from sumkey$ sk           where
  sk.sumobj# = :1 and sk.DETAILCOLFUNCTION in (2,3) )           and
  bitand(sp.flags, 2) != 2          and sp.PMOPTYPE in (2,3,5,7)    group by
  sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags)  where scn > : 2

update sumdetail$ set detailobjtype=:3, detailalias=:4, refreshscn=:5,
  detaileut=:6, spare4=:7, inline# =:8, dataless =:10 
where
 sumobj#=:1 and detailobj#=:2 and instance# =:9

select min(s1.lastrefreshscn) 
from
 sum$ s1, sumdetail$ s2  where s1.obj#= s2.sumobj# and s2.detailobj# = :1 and
  s1.obj#!= :2

delete from sumpartlog$
where
 bo#=:1 and scn<:2

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."PHONENUMBER"
FROM
 (SELECT MLOG$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."MLOG$_T_USERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
  ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."PHONENUMBER") NOT IN (SELECT
  MAS_TAB$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."T_USERINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE LOG$."PHONENUMBER" =
  MAS_TAB$."PHONENUMBER")

DELETE FROM "HW"."T_USERINFO_MV" SNAP$
WHERE
 "PHONENUMBER" = :1

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."PHONENUMBER",
  CURRENT$."PASSWD",CURRENT$."USERNAME",CURRENT$."IDCARD",
  CURRENT$."USEREMAIL",CURRENT$."LOCALID",CURRENT$."BRANDID",
  CURRENT$."PAYKIND",CURRENT$."MOBILETYPE",CURRENT$."HASOPENEMS",
  CURRENT$."HASOPENMMS",CURRENT$."ISARREAR"
FROM
 (SELECT "T_USERINFO"."PHONENUMBER" "PHONENUMBER","T_USERINFO"."PASSWD"
  "PASSWD","T_USERINFO"."USERNAME" "USERNAME","T_USERINFO"."IDCARD" "IDCARD",
  "T_USERINFO"."USEREMAIL" "USEREMAIL","T_USERINFO"."LOCALID" "LOCALID",
  "T_USERINFO"."BRANDID" "BRANDID","T_USERINFO"."PAYKIND" "PAYKIND",
  "T_USERINFO"."MOBILETYPE" "MOBILETYPE","T_USERINFO"."HASOPENEMS"
  "HASOPENEMS","T_USERINFO"."HASOPENMMS" "HASOPENMMS","T_USERINFO"."ISARREAR"
  "ISARREAR" FROM "HW"."T_USERINFO"@CCC.US.ORACLE.COM "T_USERINFO") CURRENT$,
  (SELECT DISTINCT MLOG$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."MLOG$_T_USERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
  ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."PHONENUMBER" =
  LOG$."PHONENUMBER"

UPDATE "HW"."T_USERINFO_MV" SET "PHONENUMBER" = :1,"PASSWD" = :2,"USERNAME" =
  :3,"IDCARD" = :4,"USEREMAIL" = :5,"LOCALID" = :6,"BRANDID" = :7,"PAYKIND" =
  :8,"MOBILETYPE" = :9,"HASOPENEMS" = :10,"HASOPENMMS" = :11,"ISARREAR" = :12
WHERE
 "PHONENUMBER" = :1

INSERT INTO "HW"."T_USERINFO_MV"  ("PHONENUMBER","PASSWD","USERNAME","IDCARD",
  "USEREMAIL","LOCALID","BRANDID","PAYKIND","MOBILETYPE","HASOPENEMS",
  "HASOPENMMS","ISARREAR")
VALUES
 (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."MEMBERNUMBER" ,
  LOG$."PHONENUMBER"
FROM
 (SELECT MLOG$."MEMBERNUMBER" "MEMBERNUMBER" , MLOG$."PHONENUMBER"
  "PHONENUMBER" FROM "HW"."MLOG$_T_MEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
  "SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."MEMBERNUMBER"
  , LOG$."PHONENUMBER") NOT IN (SELECT MAS_TAB$."MEMBERNUMBER" "MEMBERNUMBER"
  , MAS_TAB$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."T_MEMBERINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE LOG$."MEMBERNUMBER" =
   MAS_TAB$."MEMBERNUMBER" AND LOG$."PHONENUMBER" = MAS_TAB$."PHONENUMBER")

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."MEMBERID",
  CURRENT$."PHONENUMBER",CURRENT$."MEMBERNUMBER",CURRENT$."MEMBERNAME",
  CURRENT$."MEMBERDETAILS"
FROM
 (SELECT "T_MEMBERINFO"."MEMBERID" "MEMBERID","T_MEMBERINFO"."PHONENUMBER"
  "PHONENUMBER","T_MEMBERINFO"."MEMBERNUMBER" "MEMBERNUMBER",
  "T_MEMBERINFO"."MEMBERNAME" "MEMBERNAME","T_MEMBERINFO"."MEMBERDETAILS"
  "MEMBERDETAILS" FROM "HW"."T_MEMBERINFO"@CCC.US.ORACLE.COM "T_MEMBERINFO")
  CURRENT$, (SELECT DISTINCT MLOG$."MEMBERNUMBER" "MEMBERNUMBER" ,
  MLOG$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."MLOG$_T_MEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
  AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."MEMBERNUMBER" =
  LOG$."MEMBERNUMBER" AND CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"

INSERT INTO "HW"."T_MEMBERINFO_MV"  ("MEMBERID","PHONENUMBER","MEMBERNUMBER",
  "MEMBERNAME","MEMBERDETAILS")
VALUES
 (:1,:2,:3,:4,:5)

UPDATE "HW"."T_MEMBERINFO_MV" SET "MEMBERID" = :1,"PHONENUMBER" = :2,
  "MEMBERNUMBER" = :3,"MEMBERNAME" = :4,"MEMBERDETAILS" = :5
WHERE
 "MEMBERNUMBER" = :3 AND "PHONENUMBER" = :2

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."USERSETID"
FROM
 (SELECT MLOG$."USERSETID" "USERSETID" FROM
  "HW"."MLOG$_T_CUSTOMIZE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
  AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."USERSETID") NOT IN (SELECT
  MAS_TAB$."USERSETID" "USERSETID" FROM "HW"."T_CUSTOMIZE"@CCC.US.ORACLE.COM
  "MAS_TAB$" WHERE LOG$."USERSETID" = MAS_TAB$."USERSETID")

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."USERSETID",
  CURRENT$."PHONENUMBER",CURRENT$."SERVICETYPE",CURRENT$."SPECIALPHONE",
  CURRENT$."SETTYPE",CURRENT$."BEGINTIME",CURRENT$."ENDTIME",
  CURRENT$."PHONESTATE",CURRENT$."TIMETYPE",CURRENT$."LOOPTYPE",
  CURRENT$."RESOURCETYPE",CURRENT$."TONEGROUPID",CURRENT$."LOOPNO",
  CURRENT$."SETTIME",CURRENT$."STATUS",CURRENT$."DESCRIPTION"
FROM
 (SELECT "T_CUSTOMIZE"."USERSETID" "USERSETID","T_CUSTOMIZE"."PHONENUMBER"
  "PHONENUMBER","T_CUSTOMIZE"."SERVICETYPE" "SERVICETYPE",
  "T_CUSTOMIZE"."SPECIALPHONE" "SPECIALPHONE","T_CUSTOMIZE"."SETTYPE"
  "SETTYPE","T_CUSTOMIZE"."BEGINTIME" "BEGINTIME","T_CUSTOMIZE"."ENDTIME"
  "ENDTIME","T_CUSTOMIZE"."PHONESTATE" "PHONESTATE","T_CUSTOMIZE"."TIMETYPE"
  "TIMETYPE","T_CUSTOMIZE"."LOOPTYPE" "LOOPTYPE","T_CUSTOMIZE"."RESOURCETYPE"
  "RESOURCETYPE","T_CUSTOMIZE"."TONEGROUPID" "TONEGROUPID",
  "T_CUSTOMIZE"."LOOPNO" "LOOPNO","T_CUSTOMIZE"."SETTIME" "SETTIME",
  "T_CUSTOMIZE"."STATUS" "STATUS","T_CUSTOMIZE"."DESCRIPTION" "DESCRIPTION"
  FROM "HW"."T_CUSTOMIZE"@CCC.US.ORACLE.COM "T_CUSTOMIZE") CURRENT$, (SELECT
  DISTINCT MLOG$."USERSETID" "USERSETID" FROM
  "HW"."MLOG$_T_CUSTOMIZE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
  AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."USERSETID" =
  LOG$."USERSETID"

INSERT INTO "HW"."T_CUSTOMIZE_MV"  ("USERSETID","PHONENUMBER","SERVICETYPE",
  "SPECIALPHONE","SETTYPE","BEGINTIME","ENDTIME","PHONESTATE","TIMETYPE",
  "LOOPTYPE","RESOURCETYPE","TONEGROUPID","LOOPNO","SETTIME","STATUS",
  "DESCRIPTION")
VALUES
 (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16)

UPDATE "HW"."T_CUSTOMIZE_MV" SET "USERSETID" = :1,"PHONENUMBER" = :2,
  "SERVICETYPE" = :3,"SPECIALPHONE" = :4,"SETTYPE" = :5,"BEGINTIME" = :6,
  "ENDTIME" = :7,"PHONESTATE" = :8,"TIMETYPE" = :9,"LOOPTYPE" = :10,
  "RESOURCETYPE" = :11,"TONEGROUPID" = :12,"LOOPNO" = :13,"SETTIME" = :14,
  "STATUS" = :15,"DESCRIPTION" = :16
WHERE
 "USERSETID" = :1

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."GROUPID" ,
  LOG$."PHONENUMBER"
FROM
 (SELECT MLOG$."GROUPID" "GROUPID" , MLOG$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."MLOG$_T_GROUPINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
  AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."GROUPID" , LOG$."PHONENUMBER")
  NOT IN (SELECT MAS_TAB$."GROUPID" "GROUPID" , MAS_TAB$."PHONENUMBER"
  "PHONENUMBER" FROM "HW"."T_GROUPINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE
  LOG$."GROUPID" = MAS_TAB$."GROUPID" AND LOG$."PHONENUMBER" =
  MAS_TAB$."PHONENUMBER")

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."USERGROUPID",
  CURRENT$."PHONENUMBER",CURRENT$."GROUPID",CURRENT$."GROUPNAME",
  CURRENT$."DESCRIPTION"
FROM
 (SELECT "T_GROUPINFO"."USERGROUPID" "USERGROUPID",
  "T_GROUPINFO"."PHONENUMBER" "PHONENUMBER","T_GROUPINFO"."GROUPID" "GROUPID",
  "T_GROUPINFO"."GROUPNAME" "GROUPNAME","T_GROUPINFO"."DESCRIPTION"
  "DESCRIPTION" FROM "HW"."T_GROUPINFO"@CCC.US.ORACLE.COM "T_GROUPINFO")
  CURRENT$, (SELECT DISTINCT MLOG$."GROUPID" "GROUPID" , MLOG$."PHONENUMBER"
  "PHONENUMBER" FROM "HW"."MLOG$_T_GROUPINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
  "SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."GROUPID" =
  LOG$."GROUPID" AND CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"

INSERT INTO "HW"."T_GROUPINFO_MV"  ("USERGROUPID","PHONENUMBER","GROUPID",
  "GROUPNAME","DESCRIPTION")
VALUES
 (:1,:2,:3,:4,:5)

UPDATE "HW"."T_GROUPINFO_MV" SET "USERGROUPID" = :1,"PHONENUMBER" = :2,
  "GROUPID" = :3,"GROUPNAME" = :4,"DESCRIPTION" = :5
WHERE
 "GROUPID" = :3 AND "PHONENUMBER" = :2

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."GROUPID" ,
  LOG$."MEMBERNUMBER" , LOG$."PHONENUMBER"
FROM
 (SELECT MLOG$."GROUPID" "GROUPID" , MLOG$."MEMBERNUMBER" "MEMBERNUMBER" ,
  MLOG$."PHONENUMBER" "PHONENUMBER" FROM
  "HW"."MLOG$_T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" >
  :1 AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."GROUPID" ,
  LOG$."MEMBERNUMBER" , LOG$."PHONENUMBER") NOT IN (SELECT MAS_TAB$."GROUPID"
  "GROUPID" , MAS_TAB$."MEMBERNUMBER" "MEMBERNUMBER" , MAS_TAB$."PHONENUMBER"
  "PHONENUMBER" FROM "HW"."T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM "MAS_TAB$"
  WHERE LOG$."GROUPID" = MAS_TAB$."GROUPID" AND LOG$."MEMBERNUMBER" =
  MAS_TAB$."MEMBERNUMBER" AND LOG$."PHONENUMBER" = MAS_TAB$."PHONENUMBER")

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."GROUPMEMBERID",
  CURRENT$."PHONENUMBER",CURRENT$."GROUPID",CURRENT$."MEMBERNUMBER"
FROM
 (SELECT "T_GROUPMEMBERINFO"."GROUPMEMBERID" "GROUPMEMBERID",
  "T_GROUPMEMBERINFO"."PHONENUMBER" "PHONENUMBER",
  "T_GROUPMEMBERINFO"."GROUPID" "GROUPID","T_GROUPMEMBERINFO"."MEMBERNUMBER"
  "MEMBERNUMBER" FROM "HW"."T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM
  "T_GROUPMEMBERINFO") CURRENT$, (SELECT DISTINCT MLOG$."GROUPID" "GROUPID" ,
  MLOG$."MEMBERNUMBER" "MEMBERNUMBER" , MLOG$."PHONENUMBER" "PHONENUMBER"
  FROM "HW"."MLOG$_T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
  "SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."GROUPID" =
  LOG$."GROUPID" AND CURRENT$."MEMBERNUMBER" = LOG$."MEMBERNUMBER" AND
  CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"

INSERT INTO "HW"."T_GROUPMEMBERINFO_MV"  ("GROUPMEMBERID","PHONENUMBER",
  "GROUPID","MEMBERNUMBER")
VALUES
 (:1,:2,:3,:4)

UPDATE "HW"."T_GROUPMEMBERINFO_MV" SET "GROUPMEMBERID" = :1,"PHONENUMBER" =
  :2,"GROUPID" = :3,"MEMBERNUMBER" = :4
WHERE
 "GROUPID" = :3 AND "MEMBERNUMBER" = :4 AND "PHONENUMBER" = :2

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."LOOPTONEID"
FROM
 (SELECT MLOG$."LOOPTONEID" "LOOPTONEID" FROM
  "HW"."MLOG$_T_LOOPTONE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
  ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."LOOPTONEID") NOT IN (SELECT
  MAS_TAB$."LOOPTONEID" "LOOPTONEID" FROM "HW"."T_LOOPTONE"@CCC.US.ORACLE.COM
  "MAS_TAB$" WHERE LOG$."LOOPTONEID" = MAS_TAB$."LOOPTONEID")

SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."LOOPTONEID",
  CURRENT$."PHONENUMBER",CURRENT$."TONEGROUPID",CURRENT$."TONEID",
  CURRENT$."OFFSET",CURRENT$."LOOPNO"
FROM
 (SELECT "T_LOOPTONE"."LOOPTONEID" "LOOPTONEID","T_LOOPTONE"."PHONENUMBER"
  "PHONENUMBER","T_LOOPTONE"."TONEGROUPID" "TONEGROUPID",
  "T_LOOPTONE"."TONEID" "TONEID","T_LOOPTONE"."OFFSET" "OFFSET",
  "T_LOOPTONE"."LOOPNO" "LOOPNO" FROM "HW"."T_LOOPTONE"@CCC.US.ORACLE.COM
  "T_LOOPTONE") CURRENT$, (SELECT DISTINCT MLOG$."LOOPTONEID" "LOOPTONEID"
  FROM "HW"."MLOG$_T_LOOPTONE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" >
  :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."LOOPTONEID" =
  LOG$."LOOPTONEID"

INSERT INTO "HW"."T_LOOPTONE_MV"  ("LOOPTONEID","PHONENUMBER","TONEGROUPID",
  "TONEID","OFFSET","LOOPNO")
VALUES
 (:1,:2,:3,:4,:5,:6)

UPDATE "HW"."T_LOOPTONE_MV" SET "LOOPTONEID" = :1,"PHONENUMBER" = :2,
  "TONEGROUPID" = :3,"TONEID" = :4,"OFFSET" = :5,"LOOPNO" = :6
WHERE
 "LOOPTONEID" = :1

begin   sys.dbms_snapshot_utl.wrap_up@CCC.US.ORACLE.COM   (:mow_col, :mas_col,
   :masobj_col, :rollseg_col, :flag_col,    :snaptime_col, :loadertime_col,  
  :snapid_col, :snaptype_col, :masindx_col);  end;

SELECT FLAG  
FROM
 SYS.JOB$  WHERE JOB = :b1

UPDATE SYS.JOB$ J SET FLAG=:b1,NEXT_DATE=NVL(:b2,J.NEXT_DATE)
WHERE
 JOB = :b3

BEGIN dbms_support.stop_trace; END;

SELECT SID  
FROM
 V$MYSTAT  WHERE ROWNUM = 1

SELECT SERIAL#  
FROM
 V$SESSION  WHERE SID = :b1

SELECT STATUS  
FROM
 V$SESSION  WHERE SID = :b1  AND SERIAL# = :b2